UIM Upgrade To 7.3.1.1; Rundb Error On Create Index IDX_SRV_EOID_ED (Doc ID 2122210.1)

Last updated on MAY 18, 2017

Applies to:

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

Symptoms

Upon  upgrade to UIM, from 7.3.0.2.1 to 7.3.1.1 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

 

Cause

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