Value exceeding its max length Error

[AXK0121B]

We are trying to connect openEdge ProgressDB using ODBC Connection, While Loading the data for  dataset we are getting below error.

Error :

SQL_ERROR  SqlState: HY000 NativeError: -210012 Message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column code_value in table PUB.code_mstr has value exceeding its max length or precision. Line: 151 Column: -1

We tried increasing the length of the destination fileds in Qlik, even after that we are getting the same error.

[SachinB]

Hello @AXK0121B ,

Thanks for contacting Qlik community link.

The error message "value exceeding its max length or precision" typically indicates that there is a mismatch between the data you're trying to insert or modify and the defined data type or length of the column in the table.

This error can occur for various reasons, such as:

1. Trying to insert a value that is longer than the maximum allowed length for a column.
2. Trying to insert a value with more precision or scale than what the column allows.
3. Attempting to insert a value that doesn't fit the defined data type of the column.

We would request you to create support case and attach DP along source and Target DDL of the table, We will work with you on this accordingly.

Hope above information is helpful for you.

Regards,

Sachin B

[Heinvandenheuvel]

Why would you think this is a Replicate issue? Seems to me Replicate is just the messenger.

The error message comes from the source, not from Replicate. It indicates "NativeError". Replicate is just the messenger. Now of course it could be that Replicate asked an invalid question, or provided too small a buffer, but that does not appear to be the case here.

I strongly suggestion you use an alternative ODBC or JDBC tool to query the same data and see if that works, or also fails with the seems native error exonerating Repicate.

Hein.