Consumed more than 100,000 bytes looking for record delimite

[rajeevm]

Hi

I am actually trying to read the data from .csv file thru sequential file stage and load into the sequential file. I am getting fatal error as below:

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

Final delimter - end
Field delimiter - |
quote -none

I cannot even view the data also . What 's causing the problem . I did my previous job with the same options it was loading fine.

I really appreciate your responses.

Thanks
rajeev

[ray.wurlod]

It's read 100,000 bytes without finding the first "|" character. It's assumed that your data don't match your metadata, and given up.

[rajeevm]

Thanks Ray for your reply

But the problem was with the Record delimiter . When I added that property and default it to Unix new line .The job just ran fine .

Thanks
rajeev

[ray.wurlod]

A closer reading of the error message would have told me that.