E1: UPGTC: Table Conversion Workbench Errors - jdeSpecOpenLocal Completed In Error - JDB9900299 / JDB3100007 / TCE009101 Errors (Doc ID 632014.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.

Symptoms

Customer has successfully performed a Pristine upgrade to a higher E1 application release level coming from EnterpriseOne Xe. In this scenario here they are upgrading from E1 Xe to 8.9, but note that this solution is also valid for upgrading to JD Edwards EnterpriseOne 9.x (9.0, 9.1 and 9.2) application release levels. They are now upgrading the PY prototype environment from PY7333 environment, but during Table Conversion Workbench, all of the tables conversions (TCs) are in failed status.

Several error messages were found in the jde.log.
1) These error messages found below customer would like to confirm if they could be considered normal:

2036/2016 Fri Dec 05 06:24:16.631 SpecOpen.c812 jdeSpecOpenLocal completed in error - Operation failed!.
2036/2016 Fri Dec 05 06:24:16.631 jdb_rst.c365 JDB9900299 - Failed to find global table specs.
2036/2016 Fri Dec 05 06:24:16.641 jdb_rst.c1120 JDB9900307 - Failed to find table specifications
2036/2016 Fri Dec 05 06:24:16.651 jdb_rq1.c1535 JDB3100007 - Failed to get valid table specifications:
2036/2016 Fri Dec 05 06:24:18.794 JDETAMIO.C1321 TAMInitX (c:\peoplesoft\b9\py7333\spec\jdeblc.xdb): Error opening index file "c:\peoplesoft\b9\py7333\spec\jdeblc.xdb" : The system cannot find the path specified. WinErrNum=3.
:
2036/2016 Fri Dec 05 06:24:19.585 dbcolind.c133 OCI0000017 - Unable to execute statement for describe - SELECT * FROM CRPDTA.F00926 WHERE ( AUUSER = :KEY1 AND AULNGP = :KEY2 )
2036/2016 Fri Dec 05 06:24:19.605 dbcolind.c140 OCI0000018 - Error - ORA-00942: table or view does not exist
2036/2016 Fri Dec 05 06:24:19.625 dbinitrq.c928 OCI0000143 - Failed to determine column order - SELECT * FROM CRPDTA.F00926 WHERE ( AUUSER = :KEY1 AND AULNGP = :KEY2 )
2036/2016 Fri Dec 05 06:24:19.635 dbinitrq.c935 OCI0000144 - Error - ORA-00942: table or view does not exist
2036/2016 Fri Dec 05 06:24:19.655 jdb_drvm.c832 JDB9900168 - Failed to initialize db request
2036/2016 Fri Dec 05 06:24:19.665 JTP_CM.C942 JDB9909007 - Unable to obtain driver request handle


2) The following is abnormal and probably indicates that the conversion for F00921 failed:

2036/2016 Fri Dec 05 06:24:18.564 dbcolind.c172 OCI0000042 - Unable to find column (10) in - SELECT * FROM SYS7333.F00921 WHERE ( ULUSER = :KEY1 )
2036/2016 Fri Dec 05 06:24:18.604 dbcolind.c179 OCI0000043 - Error - ORA-24334: no descriptor for this position
2036/2016 Fri Dec 05 06:24:18.634 dbinitrq.c928 OCI0000143 - Failed to determine column order - SELECT * FROM SYS7333.F00921 WHERE ( ULUSER = :KEY1 )
2036/2016 Fri Dec 05 06:24:18.644 dbinitrq.c935 OCI0000144 - Error - ORA-24334: no descriptor for this position
2036/2016 Fri Dec 05 06:24:18.664 jdb_drvm.c832 JDB9900168 - Failed to initialize db request
2036/2016 Fri Dec 05 06:24:18.694 JTP_CM.C942 JDB9909007 - Unable to obtain driver request handle

 

3) The following was also found in the logs and customer would like to confirm if those messages indicate that the ddtabl ddpkeyh ddpkeyd glbltbl specs were not copied properly:

2036/2016 Fri Dec 05 06:24:24.372 SpecOpen.c812 jdeSpecOpenLocal completed in error - Operation failed!.
2036/2016 Fri Dec 05 06:24:24.382 jdb_rst.c365 JDB9900299 - Failed to find global table specs.
2036/2016 Fri Dec 05 06:24:24.402 jdb_rst.c1120 JDB9900307 - Failed to find table specifications
2036/2016 Fri Dec 05 06:24:24.412 jdb_rq1.c1535 JDB3100007 - Failed to get valid table specifications
2036/2016 Fri Dec 05 06:24:24.432 tcinit.c1101 TCE009101 - Couldn't open F41021A.

Changes

Upgrading to a EnterpriseOne software higher application release level from EnterpriseOne Xe.

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