Page 1 of 1
Not fetching data from XML Input stage
Posted: Tue Jul 23, 2013 5:48 am
by deesh
Hi,
I have extracting xml data through using below stages
rowgen ---> trans---> xml input----->seq
I have tried with one file it's working fine, but trying with 2nd file not producing data and not getting any error or warning in director logs, it showing success with exporting 0 records.
but both files have same xsd.
but if i give 2nd file schema and namespace declaration,second file also working..
Please help me in this case
Posted: Sun Jul 28, 2013 12:39 pm
by eostic
Look at the "xpath" in the Description Properties of the output link of the xmlInput Stage....see if they have prefixes defined in the xpath (such as /xyz:name ) ...if so, then you need the namespaces to be "in" the actual xml......or not, if they aren't there. Look at your documents carefully....something is different about them.
Most often when you get zero rows means that the xpath is wrong, the spelling is wrong, or you have namespaces and no namespaces in the xpath, or namespaces in the xpath and none in the document.
Ernie
Posted: Mon Jul 29, 2013 6:04 am
by deesh
but i think it is not the reason, because both the xml files related to same xsd...
Posted: Mon Jul 29, 2013 6:30 am
by chulett
As noted by Ernie, the difference is in your files. So, what is different between them?
Posted: Mon Jul 29, 2013 6:44 am
by arunkumarmm
If you don't include the namespace in your X-Path, it will not fetch the data. Maybe one of your files is defined with namespace and the other is not. If this is the case, the same X - Path will not work for both.
E.g.,
With namespace:
/ns1:root/ns:1records/ns1:value/text()
Without:
/root/records/value/text()
Posted: Tue Aug 06, 2013 2:27 am
by deesh
Total xsd contain 950 columns.
but the input file generate with only few columns, input file data columns may change file to file, but columns are satisfy any from 950 columns.
Posted: Tue Aug 06, 2013 9:04 pm
by eostic
That's fine. Provided that you aren't getting other errors, rejections, or invalid documents, then something is different ....check the xpaths, check the namespaces ...see if the namespace declarations at the top are different between the documents....... Something is different.
Maybe it is being read incorrectly --- is the difference something about the size? Is one massively larger than the other?
Ernie