Page 1 of 1
Need Help on Parsing an XML file
Posted: Tue Jul 26, 2011 4:23 am
by mac4rfree85
Hi Guys,
I have designed a job which was running fine with a particular XML file. Now I have got a similiar XML file . The job is failing with the below error.
Code: Select all
Src,0:Error reading on import.
Src,0:Consumed more than 100000 bytes looking for record delimiter; aborting
Src,0:Import error at record 75.
Src,0:The runLocally() of the operator failed.
Can somebody throw some light on where the error could be.
Re: Need Help on Parsing an XML file
Posted: Tue Jul 26, 2011 6:23 am
by pandeesh
mac4rfree85 wrote:Hi Guys,
Now I have got a similiar XML file . The job is failing with the below error.
How you are telling that's the similar xml file?
Does the metadata matches?
The import failed is because of some incorrect metadata definition.
Double check your data and the metadata specification.
Posted: Tue Jul 26, 2011 6:41 am
by eostic
Do some searching..this looks like the classic "trying to read the xml document with a Sequential Stage"..... Search the forum or follow the link below to my blog and find the xml entries in the table of contents...look for the various ways to read xml using the External Source Stage.
Posted: Tue Jul 26, 2011 6:44 am
by Mike
Add environment variable APT_DEFAULT_TRANSPORT_BLOCK_SIZE to your job parameters, then increase its default size by some binary multiple.
e.g.
APT_DEFAULT_TRANSPORT_BLOCK_SIZE=16777216
Mike
Posted: Tue Jul 26, 2011 6:53 am
by Mike
I think Ernie is probably more on target. I think increasing the transport blocksize was more of a solution for moving large XML documents from MQ to the XML Input stage.
Mike
Posted: Tue Jul 26, 2011 8:20 am
by chulett