Ora-28528 Data Truncated With DG4ODBC And Informix ODBC Driver (Doc ID 1400946.1)

Last updated on JANUARY 18, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.

Symptoms


Using DG4ODBC 11.2 with IBM ODBC driver for Informix on Windows, the following errors occurs:

SQL> select * from va4expans@va_egg_echt;
ERROR:
ORA-28528: Heterogeneous Services datatype conversion error
[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr =
-11003}
ORA-02063: preceding line from DG4ODBC




===>Gateway trace file shows

SQL text from hgodtab, id=0, len=25 ...
   00: 73656C65 6374202A 2066726F 6D202056  [select * from  V]
   10: 41344558 50414E53 20                 [A4EXPANS ]
...
Entered hgopoer at 2012/01/23-10:42:43
hgopoer, line 231: got native error -11003 and sqlstate 01004; message follows...
[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}[Informix][Informix ODBC Driver]Data truncated. {01004,NativeErr = -11003}
Exiting hgopoer, rc=0 at 2012/01/23-10:42:43
hgoftch, line 740: calling SQLFetch got sqlstate 01004



===>ODBC driver  trace file shows:

dg4odbcVA_EGG_E 1a98-23f8 ENTER SQLFetch
HSTMT               0x00000000043ECC60

dg4odbcVA_EGG_E 1a98-23f8 EXIT  SQLFetch  with return code 1 (SQL_SUCCESS_WITH_INFO)
HSTMT               0x00000000043ECC60

DIAG [01004] [Informix][Informix ODBC Driver]Data truncated. (-11003)

DIAG [01004] [Informix][Informix ODBC Driver]Data truncated. (-11003)

DIAG [01004] [Informix][Informix ODBC Driver]Data truncated. (-11003)



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms