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

Document ID : KB000084969
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
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.
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