E1: UPGTC: R8900921 Table conversion Fails During EnterpriseOne Xe to 9.0 Upgrade - TCE009140 - JDB_SelectKeyed Failed Error (Doc ID 1102319.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 December 26, 2012

Symptoms

Customer doing an Upgrade from EnterpriseOne Xe to 9.0 application release level.
Running the Table Conversion Workbench, TC R8900921 is failing.

In jde.log, we found the following errors:

488/6844 WRK:Starting jdeCallObject Sat May 15 08:32:36.593001 dbcolind.c141
OCI0000017 - Unable to execute statement for describe - SELECT * FROM SYS7333.F00921 WHERE ( ULUSER = :KEY1 )

488/6844 WRK:Starting jdeCallObject Sat May 15 08:32:36.593002 dbcolind.c148
OCI0000018 - Error - ORA-00942: table or view does not exist

488/6844 WRK:Starting jdeCallObject Sat May 15 08:32:36.593003 dbinitrq.c981
OCI0000143 - Failed to determine column order - SELECT * FROM SYS7333.F00921 WHERE ( ULUSER = :KEY1 )

488/6844 WRK:Starting jdeCallObject Sat May 15 08:32:36.593004 dbinitrq.c988
OCI0000144 - Error - ORA-00942: table or view does not exist

488/6844 WRK:Starting jdeCallObject Sat May 15 08:32:36.593005 Jdb_drvm.c1026
JDB9900168 - Failed to initialize db request



In the R8900921TC.log, we found the following:

TCEngine Level 1 \builds\8.98.02.04.03\Rels\common\TCEngine\tcinit.c : Input F00921 is using data source System - B7333.
TCEngine Level 1 \builds\8.98.02.04.03\Rels\common\TCEngine\tcinit.c : Buffered insert turned on for output table F00921.
TCEngine Level 1 \builds\8.98.02.04.03\Rels\common\TCEngine\tcinit.c : Output F00921 is using data source System - 900.
TCEngine Level 1 \builds\8.98.02.04.03\Rels\common\TCEngine\tcinit.c : Conversion method is Row by Row.
TCEngine Level 1 \builds\8.98.02.04.03\Rels\common\TCEngine\tcinit.c : Output table F00921 will use manual commit.
TCEngine Level 1 \builds\8.98.02.04.03\Rels\common\TCEngine\tcdump.c :
TCEngine Level 0 \builds\8.98.02.04.03\Rels\common\TCEngine\tcrun.c : TCE009140 - JDB_SelectKeyed failed.
TCEngine Level 1 \builds\8.98.02.04.03\Rels\common\TCEngine\tcrun.c : Conversion R8900921 XJDE0001 done unsuccessfully. Elapsed time - 0.764000 Seconds.

Changes

Customer doing an Upgrade from EnterpriseOne Xe to 9.0 application release level.

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