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 MARCH 02, 2018

Applies to:

Oracle Mobile Field Service - Version 12.2.6 and later
Information 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

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