Error Message for load utility / ucybdbld upgrading to 12.3.3 :
20200811/150112.864 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR ', '', 'ORA-00955: name is already used by an existing object
ORA-06512: at line 7'
20200811/150112.865 - U00038068 ABORTING due to error.
The loading process was terminated abnormally. The Database might be in an inconsistent condition. Please contact Automic Support.
This error appears when creating the NK_XAO_GetChLog index:
CREATE INDEX NK_XAO_GetChLog ON XAO(XAO_Client, XAO_USR_Idnr, XAO_Type, XAO_OType, XAO_TimeStamp1, XAO_Idnr) local
20200506/120856.359 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: acbcbcd0 DB-HDBC: acac4de8
20200506/120856.359 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20200506/120856.359 - U00003592 UCUDB - Status: '' Native error: '955' Msg: 'ORA-00955: name is already used by an existing object'
Cause: Database inconsistency
Release : 12.3.3
Component : AUTOMATION ENGINE
Please update to 12.3.4 or higher.
Follow below resolution steps:
1. Restore your DB.
2. Drop the index manually.
3. Now run the dbload again.
If you still have issues, please enable the trace with database=4 and then run the dbload again and contact the CA Broadcom Automic Support, sending the load log and trace files.