topic Re: Tables failed while loading from ODBC to Oracle in Qlik Replicate

Tables failed while loading from ODBC to Oracle

Antony_05 — Mon, 25 Apr 2022 07:24:20 GMT

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

Re: Tables failed while loading from ODBC to Oracle

Pedro_Lopez — Mon, 25 Apr 2022 10:22:54 GMT

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