Error During Upgrep - Cannot Create Unique Index; Duplicate Keys Found (Doc ID 1360199.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Siebel eCommunications - Version 7.7.2.6 SIA [18372] to 8.2.2 SIA[22320] [Release V7 to V8]
Information in this document applies to any platform.
***Checked for relevance on 6-Mar-2013***

Symptoms




When attempting to run upgrep to upgrade from 7.7 to 8.1.1, process stops with the following

ERROR
-----------------------

2011-09-14 17:41:52 S1000: [Oracle][ODBC][Ora]ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
2011-09-14 17:41:52
2011-09-14 17:41:52 Dropping index with the same column signature and retrying...
2011-09-14 17:41:52 create unique index S_ASSET_XA_U1 on S_ASSET_XA
2011-09-14 17:41:52 ("ASSET_ID", "ATTR_NAME", "CONFLICT_ID")
2011-09-14 17:41:52 tablespace SIEB_INDEX

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