Row delimiter was seen for row number <439155> in Rapi

dataservices rapidmarts
1

Hi Friends,

While monitoring the Rapid mart Job I found one of the rapid mart job Purchase rapid mart failed.

When I checked the error logs I found the following error

  [b][i]Row delimiter was seen for row number <439155>
  in Rapid mart while processing column number <36> in file <Pth-]
  the row delimiter should be seen after <49>  columns .
  Please check the file for bad data or redefine input schema for the file 
  by editing the file format in ui[/i][/b]

Please assist in resolving these error

Please find the attached snip

Thanks in advance
Regards
Fasi

Md_Fasi (BOB member since 2011-11-19)

2

What are the columns around the position 36 in the ABAP dataflow? Is one of them a free form text column like “Description”. It seems to me that the data stored in the SAP database contains some characters it shouldn’t, the character we use as column delimiter.

If you idnetify such potential candidate, why don’t you change the mapping to NULL for a test to see if we found it? Then we can start looking for real solutions if required.

Werner Daehn :de: (BOB member since 2004-12-17)