ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

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


Article ID: 144976


Updated On:


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



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


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: '


The column is most likely indexed with non-Automic index


Release : 12.0, 12.1, 12.2, 12.3

Component : Automation Engine


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.