E1: OS: DB: "SQLGetData Failed" ODB0000096 Error Causes Failure on SQL Lookup in Tables Containing BLOB Columns - iSeries AS400 Platform (Doc ID 1087273.1)

Last updated on AUGUST 01, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
IBM i on POWER Systems

Symptoms

With Tools Release 8.98.3.x onwards, JD Edwards EnterpriseOne supports release IBM i database v7.1 (DB2/400 V7R1). The base release of IBM i Access for Windows v7.1 has a bug which prevents a SQL lookup for tables that contain BLOB (binary large objects) columns.

Excerpt from the JDE.LOG:

140/2660 MAIN_THREAD Tue Dec 29 10:09:58.214001 Odbc_p1.c2038
ODB0000096 - SQLGetData failed. Table F986180, column NCNDNM, ODBC DSN System - 900.

140/2660 MAIN_THREAD Tue Dec 29 10:09:58.214003 Jdb_drvm.c1176
JDB9900172 - Failed to execute db fetch

140/2660 MAIN_THREAD Tue Dec 29 10:09:58.385001 Odbc_p1.c2038
ODB0000096 - SQLGetData failed. Table F986180, column NCNDNM, ODBC DSN System - 900.

140/2660 MAIN_THREAD Tue Dec 29 10:09:58.385003 Jdb_drvm.c1176
JDB9900172 - Failed to execute db fetch

140/2660 MAIN_THREAD Tue Dec 29 10:16:57.076001 Odbc_p1.c2038
ODB0000096 - SQLGetData failed. Table F983051, column VRPID, ODBC DSN Versions - DV900.

140/2660 MAIN_THREAD Tue Dec 29 10:16:57.076003 Jdb_drvm.c1176
JDB9900172 - Failed to execute db fetch

140/4056 FOREIGN_THREAD Tue Dec 29 10:18:08.998001 Odbc_p1.c2038
ODB0000096 - SQLGetData failed. Table F98OWPU, column PUSECUSR, ODBC DSN System - 900.

140/4056 FOREIGN_THREAD Tue Dec 29 10:18:08.998003 Jdb_drvm.c1176
JDB9900172 - Failed to execute db fetch
...

 

Changes

 

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