Skip to Content
author's profile photo Former Member
Former Member

Row delimiter erroe while running R3 jobs

Hi Experts

We are using BODS 4.2.

We have a job which uses ABAP dataflow to fetch data from SAP R3 server.

We are using "FTP" option to fetch data.

For some rows we are getting below error:

A row delimiter was seen for row number <190009> while processing column number <14> in file <D:/SAP BODI/Local Dir/Zsap_bsis>.

The row delimiter should be seen after <23> columns. Check the file for bad data, or redefine the input schema for the file by

editing the file format in the UI.

When i examined the file in question at this particular row number,i found this:

The data is somewhat getting split at row number 190009 .

Can you help me to get rid of this error.

How can we identify which delimiter is being used here??

Regards

Ankit Pandey

Delimiter Error.jpg (173.1 kB)
Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Jun 10, 2014 at 07:23 PM

    Hi,

    you can set the write error rows to file in the error handling section of the file format

    this way you can capture the row that are failing and fix the issue and load this file again

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 11, 2014 at 07:27 AM

    Hi Sandeep

    We are able to see which rows are getting rejected,but not able to figure out why it is happening.

    We have an ABAP workflow in our job which exceutes a program on SAP sever.The ABAP is processed and the file is sent to the local directory on our job server using ftp.

    The same process used to work fine in older versions of BODS(3.x).

    The issue we are observing is in this newer version of BODS(4.2).

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.