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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

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.