SAP Knowledge Base Article - Preview

3129138 - ORA-01406:fetched column value was truncated

Symptom

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


Read more...

Environment

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

Product

SAP HANA, platform edition 2.0

Keywords

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

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.