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:
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: '
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.
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.
Feedback
Yes
No
Powered by
