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 14, 2020
Applies to:Oracle Mobile Field Service - Version 12.2.6 and later
Information in this document applies to any platform.
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
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
AD Worker error:
The index cannot be created as the table has duplicate keys.
Upgrade to Release 12.2.x.
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