Err SAP: Bad data,row delimiter should be see after a column

dataservices job design
1

Hi,

Am facing the following issue while running a job in data servies.
My source is a SAP R/3. The error is as shown in the attachment, am facing this issue only for few tables.

Kindly let me know how to resolve this issue.

Regards,
Balaji
error report.JPG

balaji_chimmani (BOB member since 2007-11-22)

2

Hi ,

Pls check your source file data.
DI looking data in some other location in the columns.

i think it is expecting more data at the end of line .
Take single record then try to process,

Check data is proper data or not.

Regards
Siva

Siva.dwh (BOB member since 2008-11-13)

3

Also, if your SAP system is a unicode, don’t forget to edit the datastore and select utf-8 as codepage.

Werner Daehn :de: (BOB member since 2004-12-17)

4

Hi,

i Changed the code page to UTF-8,even then am getting the same error.

Regards,
Balaji

balaji_chimmani (BOB member since 2007-11-22)

5

w.r.t Siva.dwh reply,

 I have checked the data in the .dat file that got generated i did not find any flaw in that file.It has loaded almost 95% of records into the table.

Regards,
Balaji

balaji_chimmani (BOB member since 2007-11-22)

6

hi

guess a column delimiter is appearing at the end of the 102 column, just see that record in particular, i have had similar peobs when i did it with flat files, after i manually editied it the prob got solved.

this is a prob in the data only…

vigi

vigneshwar (BOB member since 2009-04-15)

7

thanks vigneshwar,

but these are not flat files, the SAP table data dump file(.dat xtension), which is very large in size(approx… 500MB). I checked the data in SAP, the data is good. Also checked by exporting the data to a csv file, that too failed.

Regards,
Balaji

balaji_chimmani (BOB member since 2007-11-22)

8

what i had done was for a csv only.
if u can post a snippet of the row that is not getting loaded. lets c what the prob is

vigneshwar (BOB member since 2009-04-15)

9

I didn’t pay close attention, as the others pointed out it happens at row number 1 million. So it cannot be a general setting, it has to be related to the row’s data.

What you could try for a second is to go to the object library, fiel formats, edit the transport file format and change the column delimiter to something else. If that makes a difference, then we know for sure this character we use as a column delimiter is contained in the data inside the SAP table you are reading.

Werner Daehn :de: (BOB member since 2004-12-17)

10

Hi,

I tried all other delimiter but the data is not getting splitted into columns.Column delimiter should be “”, we can not keep anyother. I tried row delimiter as windows new line and unix new line also , its failing tooo. :hb:

Help me in this regard,

Thanks
Balaji.

balaji_chimmani (BOB member since 2007-11-22)

11

Is your datastore in generate_and_execute mode?

Werner Daehn :de: (BOB member since 2004-12-17)

12

Hi,

Yes it is in generate and execute mode…

Thanks,
Balaji

balaji_chimmani (BOB member since 2007-11-22)

13

Please send me an email - I’d like to look at it. Are you in contact with support on that problem?

Werner Daehn :de: (BOB member since 2004-12-17)

14

Hi,

I am not in touch with support on this problem…

Can you give your mail id? or else my email id is balaji.softpro@gmail.com.

What should i send u as email?

The dat file is 26 MB after compression (actual size is 455 MB).

Regards,
Balaji

balaji_chimmani (BOB member since 2007-11-22)

15

Hi Werner,

The problem was with a column SGTXT which was having an invalid charater. I did not select that column in my query, But i should increase the column size of some columns to make the job run with out any errors(with out SGTXT column). I am not getting why i should increase the column size to run the job with out errors.

Once again thanks for your support to solve this issue.

Regards,
Balaji

balaji_chimmani (BOB member since 2007-11-22)