E1: UPGTC: Table Conversion Run Successfully Locally On The Deployment Server, But Error On The Enterprise Server - OCI0000017 / OCI0000141 / JDB9900164 / TCE9000 Errors (Doc ID 1339640.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 7-2-2014***

Symptoms

Customer is upgrading from EnterpriseOne 8.10 to 9.0 application release level. The table conversions for the upgrade plan's Table Conversion Workbench complete successfully on the Deployment Server, but fail if submitted to run on the V6R1 AIX Enterprise Server.

R98405A log:

9830458/1 WRK:Starting jdeCallObject Tue Jul 5 15:42:06.446670 b984054.c197
Running Table Conversion F42199 *ALTER

9830458/1 WRK:Starting jdeCallObject Tue Jul 5 15:42:06.798141 dbcolind.c141
OCI0000017 - Unable to execute statement for describe - SELECT * FROM DV900.F98710DV900F001 WHERE ( THOBNM = :KEY1 )

9830458/1 WRK:Starting jdeCallObject Tue Jul 5 15:42:06.798282 dbcolind.c148
OCI0000018 - Error - ORA-00942: table or view does not exist


TC log:

TCEngine Level 1 tcapi.c : Starting ITCEAlterTable
TCEngine Level 1 tcapi.c : Call JDB_OpenForeignTable for input table F42199.
TCEngine Level 0 tcapi.c : TCE9000 - ITCEAlterTable - JDB_OpenForeignTable failed on input table F42199..
TCEngine Level 1 tcapi.c : Table F42199 converted unsuccessfully. Elapsed time - 0.008137 Seconds.


jde_5816_070511.log:

5816/2828 WRK:Starting jdeCallObject Tue Jul 05 15:50:57.573001 dbinitcn.c899
OCI0000065 - Unable to create user session to database server

5816/2828 WRK:Starting jdeCallObject Tue Jul 05 15:50:57.573003 dbinitcn.c904
OCI0000141 - Error - ORA-01017: invalid username/password; logon denied

5816/2828 WRK:Starting jdeCallObject Tue Jul 05 15:56:58.015001 Jdb_drvm.c921
JDB9900164 - Failed to connect to JDEPROD



jdedebug_5816_070511.log:

Jul 05 15:50:57.479122 - 5816/2828 WRK:Starting jdeCallObject Entering JDB_OpenTable(Table = F98613)
Jul 05 15:50:57.479123 - 5816/2828 WRK:Starting jdeCallObject Try to fetch proxy info from cache
Jul 05 15:50:57.573000 - 5816/2828 WRK:Starting jdeCallObject OCI0000065 - Unable to create user session to database server
Jul 05 15:50:57.573002 - 5816/2828 WRK:Starting jdeCallObject OCI0000141 - Error - ORA-01017: invalid username/password; logon denied
Jul 05 15:50:57.573004 - 5816/2828 WRK:Starting jdeCallObject ORACLE DBInitCon envr=05C6C198 conn=0CD6C610 aixprd06 A (DV900@JDEPROD) V0 Unicode=Y (srvrusers=1) 3
Jul 05 15:56:58.015000 - 5816/2828 WRK:Starting jdeCallObject JDB9900164 - Failed to connect to JDEPROD
Jul 05 15:56:59.124000 - 5816/2828 WRK:Starting jdeCallObject JDB9909003 - Could not init connect.

Changes

Performing an EnterpriseOne Software Upgrade to E1 9.0 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