Data Conversion errror in SAP Reader

[former_member202087]

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

[Former Member · Accepted solution]

Hi,

Which version of BODS are you on ?

We have this issue on SAP BODS 4.2 SP3 P2

Thank you.

Regards,
Raghavender.

[former_member202087 · Accepted solution]

We are on 4.2, SP1, patch 4.

My understanding is that SP3, patch 3 has been released but we have not looked at that yet.  We just upgraded to 4.2 about 3 months ago.

[Former Member · Accepted solution]

Hi - has this been resolved? We are facing similar error when reading from EBCDIC mainframe file.

[former_member202087 · Accepted solution]

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.

[Former Member]

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...