Upgrade Driver Is Failing On File ibecore.odf (Doc ID 2227366.1)

Last updated on JANUARY 29, 2017

Applies to:

Oracle iStore - Version 12.2.6 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When attempting to upgrade from 12.1.3 to R12.2 the 12.2 upgrade driver $AU_TOP/patch/115/driver/u_merged.drv is failing on file ibecore.odf.,
the following error occurs.

ERROR
-----------------------
The table is missing the index IBE_CT_RELATION_RULES_U2
or index IBE_CT_RELATION_RULES_U2 exists on another table.
Create it with the statement:

Start time for statement below is: Wed Oct 19 2016 22:48:24

CREATE UNIQUE INDEX IBE."IBE_CT_RELATION_RULES_U2" ON
 IBE.IBE_CT_RELATION_RULES (ORIGIN_OBJECT_TYPE, DEST_OBJECT_TYPE,
 ORIGIN_OBJECT_ID, DEST_OBJECT_ID, RELATION_TYPE_CODE) LOGGING STORAGE
 (FREELIST GROUPS 4 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255
 COMPUTE STATISTICS TABLESPACE APPS_TS_TX_IDX

Statement executed.

AD Worker error:
The index cannot be created as the table has duplicate keys.

Use the following SQL statement to identify the duplicate keys:

SELECT ORIGIN_OBJECT_TYPE, DEST_OBJECT_TYPE, ORIGIN_OBJECT_ID, DEST_OBJECT_ID, RELATION_TYPE_CODE, count(*)
  FROM IBE.IBE_CT_RELATION_RULES
GROUP BY ORIGIN_OBJECT_TYPE, DEST_OBJECT_TYPE, ORIGIN_OBJECT_ID, DEST_OBJECT_ID, RELATION_TYPE_CODE
  HAVING count(*)>1

AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrading from R12.1.3 to R12.2
2. Running the upgrade driver $AU_TOP/patch/115/driver/u_merged.drv
3. Error noticed on file ibecore.odf


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