E1: PKG: SQLPrepare Failed for Central Object Tables During Client Package Build (Doc ID 1412213.1)

Last updated on JULY 17, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version 8.98 and later
Information in this document applies to any platform.
Checked for relevance on August 21, 2013

Symptoms

Unable to complete Client Package Build (R9621) due to failure to access spec tables in Central Objects data source.   

Errors in ClientPkgBuild.log:

PKGTAM0030 ERROR: Failed to build specs for N75I015. Error JDESPECRESULT_JDBFAILED.
PKGXML0043 ERROR: There are errors in fetching records from F987xx (SPEC NAME) in Central Objects for ....


Errors in JDE.LOG:

999/4444 WRK:Starting jdeCallObject Sun Jan 1 12:00:00.000000 Odbc_u1.c880
ODB0000154 - SQLPrepare failed. Table F98762, ODBC DSN Central Objects - PY900.

999/4444 WRK:Starting jdeCallObject Sun Jan 1 12:00:00.000001 Jdbodbc.c3297
ODB0000027 - JDBODBC_DescribeTable failed. Table F98762.

999/4444 WRK:Starting jdeCallObject Sun Jan 1 12:00:00.000002 Jdb_drvm.c1038
JDB9900168 - Failed to initialize db request

999/4444 WRK:Starting jdeCallObject Sun Jan 1 12:00:00.000003 Jtp_cm.c1015
JDB9909007 - Unable to obtain driver request handle

999/4444 WRK:Starting jdeCallObject Sun Jan 1 12:00:00.000004 Jdb_exef.c4505
JDB3300020 - Fetch not allowed. Prior successful Select operation required for this request.

999/4444 WRK:Starting jdeCallObject Sun Jan 1 12:00:00.000005 spkgutil.c527
[PKGBLD] - Sun Jan 1 12:00:00 - PkgTam.cpp:962 PKGTAM0030 ERROR: Failed to build specs for N75I015. Error JDESPECRESULT_JDBFAILED.

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