Need Help on Parsing an XML file

[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.

[pandeesh]

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.

[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.

[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

[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

[chulett]

Specifically: http://dsrealtime.wordpress.com/2007/12 ... -a-source/