Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Antony_05
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.

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
Pedro_Lopez
Support
Support

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