My Oracle Support Banner

12.2.10 Upgrade Patch Worker Fails For GMSBUDG.odf - ORA-01452: CANNOT CREATE UNIQUE INDEX; DUPLICATE KEYS FOUND (Doc ID 2802960.1)

Last updated on AUGUST 27, 2021

Applies to:

Oracle Grants Accounting - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

When upgrading to 12.2.10 and after merging patches a worker fails with the following error located in the adoworker log

adoworker log: shows the following error
*******************************************************
The table is missing the index GMS_BUDGET_LINES_U1
or index GMS_BUDGET_LINES_U1 exists on another table.

The following ORACLE error:

ORA-12801: error signaled in parallel query server P003
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found

occurred while executing the SQL statement:

CREATE UNIQUE INDEX GMS."GMS_BUDGET_LINES_U1" ON GMS.GMS_BUDGET_LINES
 (RESOURCE_ASSIGNMENT_ID, START_DATE) LOGGING STORAGE (FREELIST GROUPS 4
 FREELISTS 4 ) PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
 PARALLEL TABLESPACE APPS_TS_TX_IDX

Changes

Upgrading from 12.1.3 to 12.2.10

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
References


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