Hi All,
I am getting below error from an ABAP DF, all help is appreciated.
|Data flow DF|Reader R3_DF
A column delimiter was seen after column number <2> for row number <3102683> in file </xxxx.dat>.
The total number of columns defined is <2>, so a row delimiter should be seen after column number <2>. Check the file for bad
Thanks
Sam
If ABAP is preloaded then check the ABAP program in your SAP ECC and check how many columns are defined in the program to how many columsn are the in the ABAP dataflow.
The job is expecting only 2 columns in the dataflow but the columns defined are 3 in the program. Also please check if there is any bad data in the .data file generated by ABAP like any of the data contains the delimiter.
Hi SPK,
This issue is actually caused by the non-printable(most probably due to CRLF i.e. Carriage return and Line Feed) characters getting added in the data which occupy a space for a column. As a result, our data does not get mapped perfectly to the columns and the leftover data looks for a column to map but doesn't get any. Hence, the error.
Open your dataset using different editors like notepad or MS WORD(turn on Show/Hide) and have a closer look at the data, you'll find the affected row.
Look for a mechanism to eliminate unwanted data(eliminating at the Source would be the best deal).
Regards- Santosh G.
Add a comment