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

Products

• CA Automic Workload Automation - Automation Engine

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.

 

Environment

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

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