3129138 - ORA-01406:fetched column value was truncated

Trying to access a table on a remote Oracle 12c database. One table have issues, which has column names with more than 30 characters.

When creating the datasource on the table, no fields are retrieved and in SM21 there is the message:

invalid remote object name: [Oracle][ODBC][Ora]ORA-01406:fetched column value was truncated

From Indexserver Trace:

[10488]{-1}[-1/-1] 2021-10-15 09:03:48.004188 e EAPI CallableStatementHandle.cpp(00247) : statement already closed

[10488]{-1}[-1/-1] 2021-10-15 09:03:48.004393 e STATS_WORKER SQLInterfaceEAPI.cpp(00524) : error procedure call (commit) exception 1: no.71000591 (EAPI/impl/SQLException.cpp:75) TID: 10488

statement already closed

NO exception throw location recorded. Stack generation suppressed.

exception type information:

- 0: public EAPI::SQLException@0x7fe29f5896e0 SI

- 0: public ltt_adp::exception@0x7fe29f589698 SI

- 0: public ltt::exception@0x7fe29e23bc70

(1)

[27970]{358841}[151/-1] 2021-10-15 09:04:17.683373 e FedTrace odbcaccess.cpp(03879) : ODBC error: connected: 1 state: HY000 code: 1406 [Oracle][ODBC][Ora]ORA-01406: fetched column value was truncated

• SAP HANA DB Version 2.0
• UnixODBC 2.3.6 driver
• Libsqora.so.12.1

KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem