Skip to Content

"ODBC Data Sotre message error for operation" in SAP DS 4.2 SP09?

Hi

I am trying to execute Look up files Job in Data Services RDS flow getting following error,

I found the following scn link,

https://launchpad.support.sap.com/#/notes/1832800/E

but in above link is shows

Resolution

Change the codepage for the ODBC datastore from <default> to <unicode>

but we have been using SAP DS 4.2 SP09 in Data source not shows unicode option it shows as below,

Which is suitable that option in data store.

Please share valuable inputs.

Thanks,

Chandrasekhar

rds.png (32.0 kB)
data-store.png (15.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 20, 2017 at 07:43 AM

    utf-8

    Add comment
    10|10000 characters needed characters exceeded

    • This exception occurs when your datatype,size does not match with database field attributes. Kindly check the datatype of columns of input schema which donot match the target schema column datatypes

  • Aug 03, 2017 at 04:59 AM

    Use the utf-8 option. Also it looks like you are inserting a date with a timestamp in the lookup table. This can also be the root cause of the error. Check what is the data type of the column in LKP_CUSTOMER_NUMBER. If it is date then try to change it as datetime to include the timestamp

    https://social.msdn.microsoft.com/Forums/sqlserver/en-US/ec184168-ddd1-4df5-b2c7-c6671b602a3d/string-or-binary-data-would-be-truncated-and-field-specifications?forum=transactsql

    Regards

    Arun Sasi

    Add comment
    10|10000 characters needed characters exceeded