Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

ORA-01406: la valeur de la colonne extraite a été tronquée

Hello

I have a message when I load a table :

SQL Error:[Oracle][ODBC][Ora]ORA-01406: la valeur de la colonne extraite a été tronquée
SQL Scriptline:
SQL State:S1000
SQL SELECT *
FROM TRVFCTJRN

Do you have a idea to my problem ?

Thanks

1 Reply
Not applicable
Author

Hello,

Your ODBC Driver seems to be inadequate for the type of column you want to load into QlikView. Perhaps you are using an older version...

Tips : Try to determine which column is truncated, by selecting the fields by name instead of *, and commenting the fields