Page 1 of 1
offset warning in the sequential stage
Posted: Wed Sep 15, 2010 8:34 am
by kollurianu
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.
Posted: Wed Sep 15, 2010 8:45 am
by anbu
What is your delimiter?
Posted: Wed Sep 15, 2010 8:48 am
by kumar_s
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]
Posted: Wed Sep 15, 2010 5:34 pm
by ray.wurlod
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.
Posted: Tue Sep 28, 2010 1:19 pm
by kollurianu
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.