cancel
Showing results for 
Search instead for 
Did you mean: 

BODS error - Row delimiter was seen for row number

0 Kudos

Hi SAP BI Gurus,

I am new to BI and BOBJ and would really appreciate your help on this issue. We have a daily batch job in the BODS that loads data from ECC to assigned tables. The past few days, we have been getting intermittent errors during the run and this is the ABAP Data Flow that is getting the error.

FIL-080105: |Data flow DF_COEP1|Reader COEP

A row delimiter was seen for row number <1> while processing column number <65> in file <//ECCPRD/bods/ABAP/aR3dt.dat>.

The row delimiter should be seen after <79> columns. Check the file for bad data, or redefine the input schema for the file by editing the file format in the UI.

Please note that the error does not happen every day. As such, we cannot pinpoint exactly what is causing this issue. I did notice that there are 4 different ABAP Data Flows using the generic file name aR3dt.dat in their respective Data Transports. In other words, there are 4 ABAP Data Flows sharing one generic file name. DF_COEP1 is the last Data Flow called and the only one among the 4 that is having issues with the row delimiter.

Is this error because of the sharing of the generic file name or is that irrelevant? I am thinking of changing the file name in the Data Transport for DF_COEP1 from aR3dt.dat to ZCOEP.dat, for example. However, I wanted to get the opinion of the experts first. I cannot test the fix in non-PRD systems because the error only happens in PRD. As such, I need to be sure the fix really works because the WebI report that’s generated with data from the BODS is very critical to the management team. Any mix-up that results from my fix will be highlighted by the top guys.

We are using BODS 4.2, Designer Version 14.2.5.800.


Thank you.


Aileen

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member316405
Participant
0 Kudos

You need to check the ABAP program of the .dat file by which it is created.There must be the difference between the number of fields it is defined in the Dataflow and the number rows produced by the ABAP program in the file.So please compare the fields generated by the program and the fields in the R3 dataflow. you also mentioned this is just happening in Production only so compare the program between Testing and Production,should be same version.

Thanks,

Niranjan

former_member185603
Active Contributor
0 Kudos

You need to post this question BODS area.

0 Kudos

Thanks. I just did it.