DB Load is failing when upgrading to v21:ORA-00955: name is already used by an existing object

Products

• CA Automic Workload Automation - Automation Engine

Issue/Introduction

The DB Load is failing when creating the table UC_Test_Table

20220517/151752.545 - U00038042 Changing DB Schema ...
20220517/151752.545 - U00038042 ../db/oracle/12.3/check_privileges.sql
20220517/151752.545 - U00038042 CREATE TABLE UC_Test_Table
(
        Test_Idnr INTEGER NOT NULL,
        Test_Name VARCHAR2 (8 CHAR) NULL,

        CONSTRAINT PK_Test PRIMARY KEY
        (
                Test_Idnr
        ) USING INDEX  TABLESPACE UC4_INDEX
) TABLESPACE UC4_DATA
20220517/151752.548 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 7f9a34b63fe0  DB-HDBC: 7f9a345556c8
20220517/151752.548 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'
20220517/151752.548 - U00003592 UCUDB - Status: '' Native error: '955' Msg: 'ORA-00955: name is already used by an existing object'
20220517/151752.548 - U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: 'CREATE TABLE UC_Test_Table
(
        Test_Idnr INTEGER NOT NULL,
        Test_Name VARCHAR2 (8 CHAR) NULL,

        CONSTRAINT PK_Test PRIMARY KEY
        (
                Test_Idnr
        ) USING INDEX  TABLESPACE UC4_INDEX
) TABLESPACE UC4_DATA'
20220517/151752.548 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00955: name is already used by an existing object'
20220517/151752.549 - U00038089 Error: Problem during execution of SQL command:
'CREATE TABLE UC_Test_Table
(
        Test_Idnr INTEGER NOT NULL,
        Test_Name VARCHAR2 (8 CHAR) NULL,

        CONSTRAINT PK_Test PRIMARY KEY
        (
                Test_Idnr
        ) USING INDEX  TABLESPACE UC4_INDEX
) TABLESPACE UC4_DATA'
20220517/151752.549 - U00003590 UCUDB - DB error: 'OCIStmtExecute', 'ERROR   ', '', 'ORA-00955: name is already used by an existing object'
20220517/151752.549 - U00038068 ABORTING due to error.

The loading process was terminated abnormally. The Database might be in an inconsistent condition. Please contact Automic Support.
20220517/151752.550 - U00038068 ABORTING due to error.

 

Environment

Release : 21.x

Component : AUTOMATION ENGINE

Cause

N/A

Resolution

If the UC_Test_Table still exists from the previous installation , then please ask your DBA to drop it using the steps below.

 

DROP PROCEDURE UC_TEST_Proc;
DROP FUNCTION  UC_Test_Function;
DROP INDEX NK_TEST;
DROP TABLE UC_Test_Table;
DROP TABLE UC_Xml_Test;
commit;

-Restore the DB backup from the previous AE version

-Update the Utility to v21.x

-Update the DB schema using the db to  v21