Page 1 of 1

Sequential Stage in PX

Posted: Fri Jan 19, 2007 6:28 pm
by seethamsetty
Yes I am able proceed and need to check with accuracy of data.

Hello,

I am trying to read a xml file in sequential stage PX with two columns (Filename and Record).It is not able to read/

It gives the following error.

Sequential_File_0,0: Consumed more than 100,000 bytes looking for record delimiter; aborting

Record Delimiter = end
Field Delimiter =comma
Field quote = double
I have given the above in the format tab.

Any one has come across this problem

Thanks
seethamsetty

Posted: Fri Jan 19, 2007 6:38 pm
by DSguru2B
There have been a few folks that encountered this problem. Search on the error message.

Posted: Fri Jan 19, 2007 9:21 pm
by ray.wurlod
Is your XML file really comma delimited? That's very unusual. The stage gave up after not finding a comma (or maybe line terminator) in the first 100KB. I would, too.