Skip to Content

BODS : Column delimiter errors on SAPR/3 datastore

Hi All.

Can anyone advise as to why this error comes up while we try to pull data from SAP R/3 TABLE.

We are using a datastore which has the option to Generate & execute / direct download with a path defined locally on the BODS dev server.

We dont see the error on production server.

Can anyone advise as to how to resolve this : https://cw.sdn.sap.com/cw/ideas/2596

I dont seem to understand... as to what exactly needs to be done for resolving this error.

The workflow to be done to fix this... would be helpful.

Thanks

indu

=========================================================

ERROR ON BODS :

3848 7508 FIL-080104 7/20/2011 6:42:52 PM |Dataflow Test_WF|Reader New_R3DataFlow1

3848 7508 FIL-080104 7/20/2011 6:42:52 PM A column delimiter was seen after column number <15> for row number <1> in file <D:/bodi/ZR3TEST.DAT>. The total number of

3848 7508 FIL-080104 7/20/2011 6:42:52 PM columns defined is <15>, so a row delimiter should be seen after column number <15>. Please check the file for bad data, or

3848 7508 FIL-080104 7/20/2011 6:42:52 PM redefine the input schema for the file by editing the file format in the UI.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Aug 03, 2011 at 06:01 AM

    Hi.

    Request help to resolve this problem of delimiters :

    We have this problem on BODS jobs when we use execute-preloaded option while using SAP R/3 data source.

    This problem we see on a new table of sap R/3 which we are trying to use in our work flow.

    The existing jobs on sap R/3 tables do not have any problems.

    This is the error seen on error log :

    (12.1) 08-02-11 19:31:02 (E) (3968:4204) FIL-080105: |Dataflow DF_Zunbill_rev|Reader ZUNBILLREVENUE

    A row delimiter was seen for row number <1> while processing column number <8> in file

    <//172.10.16.69/bods_share/zunbill_rev.dat>. The row delimiter should be seen after <9> columns. Please check the file for bad

    data, or redefine the input schema for the file by editing the file format in the UI.

    (12.1) 08-02-11 19:31:03 (E) (3968:4204) FIL-080105: |Dataflow DF_Zunbill_rev|Reader ZUNBILLREVENUE

    A row delimiter was seen for row number <2> while processing column number <8> in file

    <//172.10.16.69/bods_share/zunbill_rev.dat>. The row delimiter should be seen after <9> columns. Please check the file for bad

    data, or redefine the input schema for the file by editing the file format in the UI.

    (12.1) 08-02-11 19:31:03 (E) (3968:4204) FIL-080105: |Dataflow DF_Zunbill_rev|Reader ZUNBILLREVENUE

    A row delimiter was seen for row number <3> while processing column number <8> in file

    <//172.10.16.69/bods_share/zunbill_rev.dat>. The row delimiter should be seen after <9> columns. Please check the file for bad

    data, or redefine the input schema for the file by editing the file format in the UI.

    =======================================================================

    Can anyone advise as to how we resolve this.

    In this post : https://cw.sdn.sap.com/cw/ideas/2596 there is a suggestion.

    Since am relatively new to BODS / BW, am not understanding what is being said,

    as to use the replace sub string function.

    How do we include this function in the ABAP program ?

    iF Anyone can help on this, that would be great.

    Many thanks.

    indu

    Edited by: Indumathy Narayanan on Aug 3, 2011 8:10 AM

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi.

      We created a new environment on a new machine with windows 2003 server / sql server 2005 for BODS repository and installed BODS 3.1 - as in our production environment.

      However, when we tried to create a DF which has a datastore option of SAP R/3 which says generate and execute... we get the column delimiter error warning again - WHEN we run the job of the DF.

      We really do not know. Why this error comes in our dev / QA environments.

      While our production environment is running fine without errors.

      The delimiters errors - are for the programs which are system generated.

      How do we fiddle with that and find out what exactly is causing the problem ?

      Not really understanding.

      How we really fix this - once for all.

      Is this a bug.

      Thanks

      indu

      Jeff : Do you have any advise. We are a sort of stuck in our ETL jobs of pulling data from SAP R/3 due to this problem.

      thanks

      Edited by: Indumathy Narayanan on Aug 18, 2011 3:11 PM

      Edited by: Indumathy Narayanan on Aug 18, 2011 3:51 PM

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.