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

The failure is due to the existence of test database objects (PROCEDURE, FUNCTION, TRIGGER, TABLE..etc.,).

Resolution

Verify if the UC_Test_Table still exists from the previous installation or failure in attempt to upgrade the DB.

In case it does, drop the test objects using the below provided  sql queries -

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

Reattempt the DBLoad. In case it still returns a failure 

- Restore the DB backup from the previous AE version

- Ensure the Automic database user has all the required permissions

https://docs.automic.com/documentation/webhelp/english/ALL/components/DOCU/21.0/Automic%20Automation%20Guides/Content/Installation_Manual/AE/SetUptheAEDatabase.htm?Highlight=%22CREATE%20PROCEDURE%22#link3 

- Execute the DBLoad command with an appropriate syntax