Upgrade Driver Is Failing On File ibecore.odf
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.
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.
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
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(*)
GROUP BY ORIGIN_OBJECT_TYPE, DEST_OBJECT_TYPE, ORIGIN_OBJECT_ID, DEST_OBJECT_ID, RELATION_TYPE_CODE
AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above
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
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