AWA: DB Load Fails with ' U00003592 UCUDB - Status: '' Native error: '1408' Msg: 'ORA-01408: such column list already indexed''

Products

• CA Automic Workload Automation - Automation Engine
• CA Automic Workload Automation - Automation Engine

Issue/Introduction

Scenario:

During an upgrade of the Automic Database, DB Load fails with the following errors (can be related to any index):

CREATE INDEX NK_MQSRV_Type ON MQSRV(MQSRV_Type)

20200210/164634.384 - U00029108 UCUDB: SQL_ERROR    Database handles  DB-HENV: 1d904d0  DB-HDBC: 1e565f0

20200210/164634.384 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR'

20200210/164634.384 - U00003592 UCUDB - Status: '' Native error: '1408' Msg: 'ORA-01408: such column list already indexed'

20200210/164634.385 - U00003594 UCUDB Ret: '3590' opcode: 'EXEC' SQL Stmnt: '

Cause

The column is most likely indexed with non-Automic index

Environment

Release : 12.0, 12.1, 12.2, 12.3

Component : Automation Engine

Resolution

1. Verify what index is present on the column that is already indexed with your DBA (in the example provided above, you need to verify the name of the index MQSRV is indexed with).
2. If the index is not Automic index, delete it. You can verify if it is Automic index or not by checking if the index name is present in one of the SQL statements of DBLoad utility in db folder (e.x. C:\Automic\Utility\db\oracle\12.2). For example, if your index called MQSRV_INDEX, it will not be present in any of the SQL statements in C:\Automic\Utility\db\oracle\12.2. Thus, it is non-Automic index, and needs to be deleted.
3. Once the index is deleted, restart the DBLoad Utility and proceed with the Database upgrade.