BODS : Column delimiter errors on SAPR/3 datastore

[Former Member]

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.

[Former Member]

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

[Former Member]

Hey Indu,

Its because you have a bad column, sometime what happens is the delimiter for columns could be actually embedded in a field ( For Example if i use a Text field i have the usual delimiter for column is # this sign could be embedded in the text field like ABC# now this would actually create an additional columns which is not defined in the input and when the engine tries to read the file it would throw out a column delimiter). We've had similar problems so we drill down to point to where we find character embedded and use a SAP scalar Function to strip down special Characters)

The function that we used is

ZBW_SPECIAL_CHAR_CHECK ( Try to look at this function in se37 )

Hope this helps

Thanks

Alan Seelan

[Former Member]

Hi Alan.

Thanks for the response.

I did check all the fields of the SAP R/3 Table. We did not find # or any special character embedded in the name of any of the fields in R/3. And also in SE 37 i did not find the related function module.

We even checked the ABAP program which the system generated, we were unable to figure out, where the extra delimiter is coming.

Thanks

Indu

[Former Member]

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