U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR 'ORA-00955: name is already used by an existing object'

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Running UCYBDBLD for the initial data trying to do a refresh of the data from a v12 system to a v21 system throws the error

U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00955: name is already used by an existing object'

Environment

Version 21

Cause

Attempting to refresh data in an already upgraded v21 system with data in a v12 system. 

The data from the v12 system was just copied into the existing v21 database, and then the dbload was run to set the initial data:

./ucybdbld -b -x/apps/automic/ae21/Utility/db/general/21.0/UC_UPD.TXT

When it got to the OHC table, to try and create it, this is where the error was thrown. This is because the OHC table is new in version21.

CREATE TABLE OHC(

        OHC_OH_Idnr NUMBER(38,0) NOT NULL,

        OHC_Key BLOB NULL,

        OHC_CERT VARCHAR2 (1024 CHAR) NULL,

        CONSTRAINT PK_OHC PRIMARY KEY (

                OHC_OH_Idnr

        ) using index TABLESPACE UC4_INDEX,

        CONSTRAINT FK_OHC_OH FOREIGN KEY (

                OHC_OH_Idnr

        ) REFERENCES OH (

                OH_Idnr

        )

) LOB(OHC_Key) STORE AS(ENABLE STORAGE IN ROW CACHE)  TABLESPACE UC4_DATA'

20240518/015641.645 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00955: name is already used by an existing object'

20240518/015641.645 - U00038068 ABORTING due to error.

Resolution

To do a refresh of data, delete the current v21 database and do a full restore of the v12 database to the database being used for v21.

At this point, the dbload can be run - ./ucybdbld -b -x/apps/automic/ae21/Utility/db/general/21.0/UC_UPD.TXT - and will complete successfully, and the data will be refreshed as expected.