Skip to main content
Applications are open for the 2024 Qlik Luminary Program. Apply by December 15 here.
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Tables failed while loading from ODBC to Oracle

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.


"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

Labels (1)
1 Reply

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,