Skip to Content

Data Conversion errror in SAP Reader

I have a dataflow reading from the KNA1 table in SAP.  After processing some records I get the following error:

Cannot convert data <X> into type <DECIMAL> in file <SapDB::srcDB_table_query_stream>, row number <0>, column number <104>.

I am not using this data in column 103 or 104 in my dataflow but I suspect it is on the initial read where it is doing some codepage coercion that it runs into this issue.

I did find a workaround.  I set the overflow file on for the KNA1 source table in my dataflow.  When I rerun it worked fine but wrote no data to the overflow file.  Even stranger was when I turned off the overflow file on KNA1 and ran it again it ran without issue.

Has anyone ever run into this before or can explain how the overflow file should be working in this case?

Thanks,

Ken

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 12, 2015 at 09:35 PM

    Hi,

    Which version of BODS are you on ?

    We have this issue on SAP BODS 4.2 SP3 P2

    Thank you.

    Regards,
    Raghavender.

    Add comment
    10|10000 characters needed characters exceeded

    • I checked the release notes for SP3, patch 3 and SP4 and do not see any referencce to this issue.  I never raised an incident because I seem to have found a workaround.  We are working on a plan now to upgrade to SP4 but it will be a few months.

  • avatar image
    Former Member
    Jun 28, 2016 at 01:39 PM

    We are on DS 4.2.5 and I am experiencing bad data in dates, turned on the SAP reader overflow file.  The file is opened in the location specified on the DataStore (and I verified the creation date time) and it is also empty.  However my job error log indicated multiple data errors coming in from SAP.

    I really need to see the data since I need the keys to have the business fix them.  Anyone got any ideas?  I'm going to check the release notes for SP7 since it's out now and see if this is a fixed problem.  And search the notes.

    Thanks for any help...

    Add comment
    10|10000 characters needed characters exceeded