My Oracle Support Banner

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 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

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.