Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
We are having a replication from ODBC to Oracle as a full load daily, But today some tables got failed due to the following error.
ERROR:
"RetCode: SQL_ERROR SqlState: HY000 NativeError: -210012 Message: [DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Column context_help_text at rowid 153866 in table has value exceeding its max length or precision."
Can anyone help me to overcome with this error.?
Thanks and Regards,
Antony S
Hi Antony,
From the looks of the error, it seems that the value exceeded the data type length. It might be that it is a LOB Column and the task settings are limited to a smaller LOB size? Or maybe the Source table really received a value higher than expected.
I suggest you open a case in our support portal and attach the diagnostic package of the task so we can have a better view on the issue and provide you a working solution.
Kind regards,
Pedro