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 NOVEMBER 16, 2022
Applies to:
Oracle Grants Accounting - Version 12.2.10 and laterInformation 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 |