'ORA-00955: name is already used by an existing object' for indexes on initial data load

Article Id: 84969
Status: Published
Updated On: 15-04-2018 08:06
Legacy Id: 000008678
Products:
CA Automic Workload Automation - Automation Engine AUTOMIC WORKLOAD AUTOMATION
Issue/Introduction:

Error Message :
'ORA-00955: name is already used by an existing object'

There are 'ORA-00955: name is already used by an existing object' for Indexes during the load initial data step of upgrades to the Automation Engine System.

 

Cause:

Root Cause: This is due to implicit indexes becoming explicit indexes due to DB Operations (e.g. IMP/EXP, cloning of the DB etc.) but we are still handling them like implicit indexes.

Environment:

Release: AUTWAB99000-11.0-Automic Workload Automation-Base Edition
Component:

Resolution:

Fix Version(s):
Automation.Engine 10.0.7, Automation.Engine 11.1.3, Automation.Engine 11.2.1

Additional Information:

Workaround :
- restore the DB Backup- drop indexes manually- run the DB Load again