E1: UPGTC: Table Conversions Failing - ODB0000181 - JDBODBC_SpecData failed / JDB9900184 / JDB3100050 / TCE9000 Errors (Doc ID 789909.1)

Last updated on MAY 30, 2017

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.
Checked for Relevance on 25-07-2011
Checked for relevance on December 26, 2012


Symptoms

Scenario 1

Performing upgrade from EnterpriseOne XE to EnterpriseOne 9.0 application release level on the first environment, most of the tables were converted successfully, except for these tables:
F0101
F0006
F04572
F00092
F4072

When running the Installation Workbench for the Upgrade plan, the following error occurs:

JDE.log:

2900/6200 WRK:Starting jdeCallObject Mon Mar 09 12:52:35.334001 Odbc_p3.c1839
ODB0000181 - JDBODBC_SpecData failed. Index name length is greater than maximum length supported by spec Table F0101, index ix_F0101_RSa3fd344c-9e25-4fd0-89d4-975b5aa9b178.
2900/6200 WRK:Starting jdeCallObject Mon Mar 09 12:52:35.334003 Jdbodbc.c5661
ODB0000054 - Unable to get table spec. data.
2900/6200 WRK:Starting jdeCallObject Mon Mar 09 12:52:35.334005 Jdb_drvm.c1576
JDB9900184 - Failed to get table specs from db
2900/6200 WRK:Starting jdeCallObject Mon Mar 09 12:52:35.334007 Jdb_rq1.c8164
JDB9900275 - Failed to get foreign table specs
2900/6200 WRK:Starting jdeCallObject Mon Mar 09 12:52:35.334010 Jdb_rq1.c7827
JDB3100050 - Failed to load table information
2900/6200 WRK:Starting jdeCallObject Mon Mar 09 12:52:35.334013 tcapi.c2461
TCE9000 - ITCEAlterTable - JDB_OpenForeignTable failed on input table F0101..


TC log:

TCEngine Level 1 \builds\8.98.00.04.05\Rels\common\TCEngine\tcapi.c : Starting ITCEAlterTable
TCEngine Level 1 \builds\8.98.00.04.05\Rels\common\TCEngine\tcapi.c : Call JDB_OpenForeignTable for input table F0101.
TCEngine Level 0 \builds\8.98.00.04.05\Rels\common\TCEngine\tcapi.c : TCE9000 - ITCEAlterTable - JDB_OpenForeignTable failed on input table F0101..
TCEngine Level 1 \builds\8.98.00.04.05\Rels\common\TCEngine\tcapi.c : Table F0101 converted unsuccessfully. Elapsed time - 1.856000 Seconds.

 

Scenario 2

Another known issue found with same JDB_OpenForeignTable error, but in this case, it was caused by custom indexes with "non-standard" names:

F0116 failed on OpenForeignTable.
TC Log shows the following error:

TCEngine Level 1 /E910SYS/tcengine/tcapi.c : Starting ITCEAlterTable
TCEngine Level 1 /E910SYS/tcengine/tcapi.c : Call JDB_OpenForeignTable for input table F0116.
TCEngine Level 0 /E910SYS/tcengine/tcapi.c : TCE9000 - ITCEAlterTable - JDB_OpenForeignTable failed on input table F0116..
TCEngine Level 1 /E910SYS/tcengine/tcapi.c : Table F0116 converted unsuccessfully. Elapsed time - 0.001000 Seconds.


 

Changes

Customer performing an EnterpriseOne software upgrade and running Table Conversion Workbench.

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