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.
Release : 21.x
Component : AUTOMATION ENGINE
N/A
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