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 APRIL 04, 2025
Applies to:
JD Edwards EnterpriseOne Tools - Version 8.98 and laterIBM 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |