Not fetching data from XML Input stage

deesh · Post by **deesh** » Tue Jul 23, 2013 5:48 am

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

eostic · Post by **eostic** » Sun Jul 28, 2013 12:39 pm

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

deesh · Post by **deesh** » Mon Jul 29, 2013 6:04 am

but i think it is not the reason, because both the xml files related to same xsd...

chulett · Post by **chulett** » Mon Jul 29, 2013 6:30 am

As noted by Ernie, the difference is in your files. So, what is different between them?

arunkumarmm · Post by **arunkumarmm** » Mon Jul 29, 2013 6:44 am

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()

deesh · Post by **deesh** » Tue Aug 06, 2013 2:27 am

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.

eostic · Post by **eostic** » Tue Aug 06, 2013 9:04 pm

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