Hi,
I am extracting an XML source to a sequential file.I am using a folder stage as input to the XML input stage,defined the metadata through manager and loaded into a sequential filestage.No Errors no warnings.
But data is not flowing from XML Input stage to sequential stage.
Any inputs most appreciated.
Sample source
<category>
<category_id>1</category_id>
<category_desc>xxxxxx</category_desc>
</category>
In the documentation also i can get very few inputs regarding XML Where can i get the documentation for this.Should i contact IBM.
Thank you in advance,
Bala.
XML input source rows are not passing.
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 23
- Joined: Wed Jan 18, 2006 10:43 am
Hi Bala,
What kind of error msg are you getting in the director log?
when i tried out with a sample as you told,
Folder stage -> XML input -> Seq file
it's passing through...
is ur xml passing thru folder stage to XML input stage? did u check that?
if it is passing thru the first stage and u r not able to see anything in ur seq file, then one reason i cud think of is: ur xml is not validated properly, so it is not able to load...
u wud get an error in the log saying document parsing failed, Xalan fatal error...
So, let me know whether it is going thru the first stage, and failing at the second stage, then probably it has to do with ur xml input...
but if it is not passing thru first stage only, then maybe we can go in detail the column names and values u r passing ....
good luck,
Usha
What kind of error msg are you getting in the director log?
when i tried out with a sample as you told,
Folder stage -> XML input -> Seq file
it's passing through...
is ur xml passing thru folder stage to XML input stage? did u check that?
if it is passing thru the first stage and u r not able to see anything in ur seq file, then one reason i cud think of is: ur xml is not validated properly, so it is not able to load...
u wud get an error in the log saying document parsing failed, Xalan fatal error...
So, let me know whether it is going thru the first stage, and failing at the second stage, then probably it has to do with ur xml input...
but if it is not passing thru first stage only, then maybe we can go in detail the column names and values u r passing ....
good luck,
Usha
-
- Participant
- Posts: 23
- Joined: Wed Jan 18, 2006 10:43 am
Bala,
if u can see that 1 row is passing, then there is nothing wrong with the first stage...
but u cannot see anything in the director log???
hmmm...have u checked "Log reject errors" in the XML input stage??
do that ...and then run ur job...in ur director log, u can see the warning msg...that something is wrong with the XML.
if u can see that 1 row is passing, then there is nothing wrong with the first stage...
but u cannot see anything in the director log???
hmmm...have u checked "Log reject errors" in the XML input stage??
do that ...and then run ur job...in ur director log, u can see the warning msg...that something is wrong with the XML.