String is too Long Error SQL_ERROR SqlState: 22000 NativeError: 100078

[nm21]

Hi All,

I am getting the below error in Qlik Enterprise manager frequently.

RetCode: SQL_ERROR SqlState: 22000 NativeError: 100078 Message: String '100��B00' is too long and would be truncated [1022502] (ar_odbc_stmt.c:5090)

Could you please help to resolve this error?

Regards,

Nagamanickam K

[sureshkumar]

Hello @nm21 

Go to table settings > transform > in the output section select the column and increase the value [try some higher value, example: if the source datatype is varchar(8) increase it to varchar(20)]. reload the table.

Regards,

Suresh