Upgrade To Release 12.2.x Fails On asgasg.odf: "The index cannot be created as the table has duplicate keys." (ASG_ITEM_INDEX)
(Doc ID 2367604.1)
Last updated on JULY 22, 2024
Applies to:
Oracle Mobile Field Service - Version 12.2.6 and laterInformation in this document applies to any platform.
Symptoms
The following patches fail with error:
. Patch 21900901: ORACLE E-BUSINESS SUITE 12.2.6 RELEASE UPDATE PACK
. Patch 24690690: ORACLE E-BUSINESS SUITE 12.2.7 RELEASE UPDATE PACK
Error:
CREATE UNIQUE INDEX ASG."ASG~ITEM~INDEX~U1" ON ASG.ASG_ITEM_INDEX (INDEX_ID) LOGGING STORAGE (FREELIST GROUPS 4 FREELISTS 4 )
PCTFREE 10 INITRANS 11 MAXTRANS 255
COMPUTE STATISTICS ONLINE
TABLESPACE APPS_TS_ARCHIVE
Statement executed.
AD Worker error:
The index cannot be created as the table has duplicate keys.
Steps:
Upgrade to Release 12.2.x.
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Changes |
Cause |
Solution |