offset warning in the sequential stage

kollurianu · Post by **kollurianu** » Wed Sep 15, 2010 8:34 am

Hi All ,

I am getting the following warning for a csv file

seq_src_PORTFOLIO_LKP,0: Delimiter for field "IP_PORTFOLIO" not found; input: {0d}, at offset: 0

seq_src_PORTFOLIO_LKP,0: Import warning at record 27.

any inputs greatly appreciated , thanks in advance.

anbu · Post by **anbu** » Wed Sep 15, 2010 8:45 am

What is your delimiter?

kumar_s · Post by **kumar_s** » Wed Sep 15, 2010 8:48 am

Doesn't the below lines give you more information?
Take a look at the record 27 for the field "IP_PORTFOLIO", and see if that fits your metadata defenition.

seq_src_PORTFOLIO_LKP,0: Delimiter for field "IP_PORTFOLIO" not found; input: {0d}, at offset: 0

seq_src_PORTFOLIO_LKP,0: Import warning at record 27.

[/quote]

ray.wurlod · Post by **ray.wurlod** » Wed Sep 15, 2010 5:34 pm

Remember that the first record is number 0. So record 27 is the twenty-eighth record in the file. Offset 0 is the beginning of the file, and the first character of your file in that line is {0d} - that is, a line feed character.

kollurianu · Post by **kollurianu** » Tue Sep 28, 2010 1:19 pm

ray.wurlod wrote:Remember that the first record is number 0. So record 27 is the twenty-eighth record in the file. Offset 0 is the beginning of the file, and the first character of your file in that line is {0d} - that is, a line feed character.

Thanks Ray! for your response and explanation.