Upgrade To Release 12.2.x Fails On asgasg.odf: "The index cannot be created as the table has duplicate keys." (ASG_ITEM_INDEX)
Last updated on MARCH 02, 2018
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms