UIM Upgrade To; Rundb Error On Create Index IDX_SRV_EOID_ED

(Doc ID 2122210.1)

Last updated on DECEMBER 20, 2017

Applies to:

Oracle Communications Unified Inventory Management - Version and later
Information in this document applies to any platform.


Upon  upgrade to UIM, from to when you run rundb.sh script, here the console log:

./runDB.sh 'pwd' $JAVA_HOME/bin upgrade
***************************************** UIM DB TOOLS ******************************************************************
Enter Database SID: xxxxxx
Enter Database User Id: xxxxxx
DbVersionController Invocation Parameters: Friday, March 11, 2016 1:58:48 PM EST
apply update = true
version Id = 1
database config file = /opt/oracle/OSM/UIM73110/temp_dir_schema/config/databases.xml
update config file = null
output folder = /opt/oracle/OSM/UIM73110/temp_dir_schema/logs
database name = xxxxxx
user name = xxxxx
database run type =
log file = /opt/oracle/OSM/UIM73110/temp_dir_schema/logs/DbVersionController.log

B20889638 - Start
B20889638 - Failed
ORA-20999: --Area: 20
--Addl Info: -- -1452, ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found - CREATE UNIQUE INDEX IDX_SRV_EOID_ED ON Service(externalObjectId,externalManagementDoma
ORA-06512: at line 217



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms