Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Antony_05
Contributor III
Contributor III
‎2022-04-25 03:24 AM

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)
Labels
471 Views
0 Likes
1 Reply
Pedro_Lopez
Support
Support
‎2022-04-25 06:22 AM

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

444 Views