Skip to Content
avatar image
Former Member

Special Character is not loading after upgraded from Data Service 3.1 to 4.2 SP6

when we are using data service 3.1, our data load of KNA1 table from SAP to SQL server 2005 version are able to display special character such as "é" itself as "?" in sql table for NAME1 attribute.

currently we upgraded data service to 4.2 SP6, our data load of KNA1 table keeps having error message as below, and data contains special character never get loaded in sql table (SQL server 2014).

both 3.1 and 4.2 config for R3_DS are the same except that 4.2 version is using execute preloaded as ABAP execution option but 3.1 is using generate and execute. both locale setting are English, utf-8. Regarding to RM_DS setting of locale for both 3.1 and 4.2 , the language is set as <default>, code page set as utf-8, and server code page set as utf-8.

For the SQL server, the only changes we made is Server Collation from

SQL_Latin1_General_CP1_CS_AS to SQL_Latin1_General_CP1_CI_AS.


Error Message:

8996 10776 FIL-080105 2/23/2017 2:15:13 PM |Data flow DF_KNA1|Reader KNA1
8996 10776 FIL-080105 2/23/2017 2:15:13 PM A row delimiter was seen for row number <169290> while processing column number <218> in file <E:/DSData/ZKNA1.dat>. The row
8996 10776 FIL-080105 2/23/2017 2:15:13 PM delimiter should be seen after <219> columns. Check the file for bad data, or redefine the input schema for the file by editing
8996 10776 FIL-080105 2/23/2017 2:15:13 PM the file format in the UI.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Feb 24, 2017 at 01:49 PM

    Hi

    Did it previously work fine in 3.1 before the upgrade. The ABAP Data flows output is a transport file which is nothing but a .DAT file. It should be generated under the Generated ABAP Directory .

    Try opening the DAT file in Notepad++ and check for the Latin Characters in issue.

    Refer SAP Note

    2002275 - Error running ABAP dataflow with carriage returns in fields similar to: "A row delimiter was seen for row number <x> while processing column number <y> in file <z>. The row delimiter should be seen after <x> columns. Check the file for bad data, or redefine the input schema for the file by editing the file"

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ling,

      I found out a solution for this. The DAT file should store latin or special characters correctly. You can check it from SAP for the settings.

      I loaded a CSV file with latin Characters in to a Oracle staging table and it was successfully loaded.

      1) Right Click the SQL Server Datastore

      2) Click Advanced

      3) Check the option Import unsupported data type as VARCHAR of size

      4) Check the Data @ database level and Data Services in the Target table. Hope you have set the correct collation level in SQL Server Db

      Hope this is useful for you and all others who are facing this issue.

      Regards

      Arun Sasi

      mw79x.png (2.2 kB)
      3uxf5.png (2.6 kB)
  • avatar image
    Former Member
    Feb 28, 2017 at 04:46 AM

    Check the Property of .DAT file. The page code .dat file should be UTF-8.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 17, 2017 at 09:01 PM

    found the issue located at the SAP abap side, must be careful if the setting in abap code like this if using

    execute preloaded:

    this DEFAULT shall be as UTF-8:

    Add comment
    10|10000 characters needed characters exceeded