Errors While Installing MDM SP2 (Doc ID 1667253.1)

Last updated on SEPTEMBER 25, 2022

Applies to:

Symptoms

Errors encountered when applying SP2 for MDM v2.1. Customer is running oradbi.exe as first step of upgrade. This is encountering error.

Errors seen in log:
CREATE UNIQUE INDEX XT071P0 ON CI_BATCH_INST(BATCH_CD,BATCH_NBR,BATCH_RERUN_NBR,BATCH_THREAD_NBR,SCHEDULER_ID) Tablespace CISTS_01 ;

ERROR: ORA-00955: name is already used by an existing object (DBD ERROR: error possibly near indicator at char 20 in 'CREATE UNIQUE INDEX XT071P0 ON CI_BATCH_INST(BATCH_CD,BATCH_NBR,BATCH_RERUN_NBR,BATCH_THREAD_NBR,SCHEDULER_ID) Tablespace CISTS_01 ') occured while executing CREATE UNIQUE INDEX XT071P0 ON CI_BATCH_INST(BATCH_CD,BATCH_NBR,BATCH_RERUN_NBR,BATCH_THREAD_NBR,SCHEDULER_ID) Tablespace CISTS_01


CREATE UNIQUE INDEX F1C036P0 ON F1_MAP_OVRD(MAP_CD,OWNER_FLG) Tablespace CISTS_01 ;

ERROR: ORA-00955: name is already used by an existing object (DBD ERROR: error possibly near indicator at char 20 in 'CREATE UNIQUE INDEX F1C036P0 ON F1_MAP_OVRD(MAP_CD,OWNER_FLG) Tablespace CISTS_01 ') occured while executing CREATE UNIQUE INDEX F1C036P0 ON F1_MAP_OVRD(MAP_CD,OWNER_FLG) Tablespace CISTS_01

Changes

 Error occurs when upgrading to v2.1 SP2

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.