E1: UPGTC: TC Workbench Fails on TC R89811B And Others TCs - Error OCI0000179 - ORA-00955 "Name is Already Used by an Existing Object" Causing TCE009067 / TCE9000 Errors (Doc ID 661463.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.
Check for relevance on 1/2/2015

Symptoms

Customer is upgrading from EnterpriseOne Xe to latest JD EnterpriseOne 9.x (9.0 or 9.1) application release levels. Upgrade Table Conversion Workbench fails on TC R89811B (Convert Workflow Specs Stored in F98811 from Xe to B9)  and others TCs.

ERROR:
EventRule : Business Function ConvertF98811SpecXe2B9 at line 7 for Event 13 in Section Spec Conversion has caused a memory violation.


In table conversion merge driver, not only F98811 failed. F03012 and F00142 failed as well.
Errors found in the jde.log:

9532/7744 WRK:Starting jdeCallObject Wed Apr 30 07:59:07.937000 dbperfrq.c449      OCI0000178 - Unable to execute - CREATE TABLE CRPDTA.F03012TCTEMP
9532/7744 WRK:Starting jdeCallObject Wed Apr 30 07:59:07.937001 dbperfrq.c455      OCI0000179 - Error - ORA-00955: ce nom d'objet existe
9532/7744 WRK:Starting jdeCallObject Wed Apr 30 07:59:07.953000 Jdb_rq1.c7964     JDB2700007 - Failed to create non JDE table  (...)..........
====
8552/736 WRK:Starting jdeCallObject Wed Apr 30 07:59:19.687000 dbperfrq.c449        OCI0000178 - Unable to execute - CREATE TABLE CRPDTA.F00142TCTEMP
8552/736 WRK:Starting jdeCallObject Wed Apr 30 07:59:19.687001 dbperfrq.c455        OCI0000179 - Error - ORA-00955: ce nom d'objet existe
8552/736 WRK:Starting jdeCallObject Wed Apr 30 07:59:19.687002 Jdb_rq1.c7964       JDB2700007 - Failed to create non JDE table

TRANSLATION: OCI0000179 - Error - ORA-00955: name is already used by an existing object

If customer drop CRPDTA.F03012TCTEMP and CRPDTA.F00142TCTEMP and restart workbench, they get then the following errors in jde.log:

1376/1300 WRK:Starting jdeCallObject Wed Apr 30 11:21:25.781000 dbperfrq.c449      OCI0000178 - Unable to execute - INSERT INTO CRPDTA.F03012TCTEMP
1376/1300 WRK:Starting jdeCallObject Wed Apr 30 11:21:25.781001 dbperfrq.c455      OCI0000179 - Error - ORA-01843: ce n'est pas un mois valide
956/1408 WRK:Starting jdeCallObject Wed Apr 30 11:21:37.000000 dbperfrq.c449        OCI0000178 - Unable to execute - INSERT INTO CRPDTA.F00142TCTEMP
956/1408 WRK:Starting jdeCallObject Wed Apr 30 11:21:37.000001 dbperfrq.c455        OCI0000179 - Error - ORA-01843: ce n'est pas un mois valide

TRANSLATION: ORA-01843: not a valid month

Changes

Customer doing 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