Planning ODS Load Worker Fails With Ora-01452: Cannot Create Unique Index on SYSTEM_ITEMS_U1_xxx
(Doc ID 559998.1)
Last updated on FEBRUARY 04, 2022
Applies to:
Oracle Advanced Supply Chain Planning - Version 12.0 and laterInformation in this document applies to any platform.
Symptoms
While trying to run Data Collections, the Planning ODS Load Worker fails with:
28-MAR 11:16:54 : ERROR
28-MAR 11:16:54 : Unique index violated - SYSTEM_ITEMS_U1_TST
28-MAR 11:16:54 : ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
28-MAR 11:16:54 : ======= Below records violate the unique constraint =======
28-MAR 11:16:55 : PLAN_ID -1 / SR_INSTANCE_ID 2023 / ORGANIZATION_ID 84 / INVENTORY_ITEM_ID 26361
28-MAR 11:16:55 : ===========================================================
28-MAR 11:16:55 : <>
28-MAR 11:16:55 : <> CREATE UNIQUE INDEX SYSTEM_ITEMS_U1_TST ON
SYSTEM_ITEMS_TST(PLAN_ID,SR_INSTANCE_ID,ORGANIZATION_ID,INVENTORY_ITEM_ID) PARALLEL TABLESPACE
APPS_TS_TX_IDX STORAGE( INITIAL 1048576 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE
0) INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
28-MAR 11:16:55 : ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
28-MAR 11:16:55 : UNIQUE index creation on temporary table SYSTEM_ITEMS_TST has completed with
ERROR.
28-MAR 11:16:55 : User-Defined Exception
28-MAR 11:16:55 : User-Defined Exception
28-MAR 11:16:55 : User-Defined Exception
28-MAR 11:16:55 : Sending message :-9999999 to monitor.
28-MAR 11:16:54 : Unique index violated - SYSTEM_ITEMS_U1_TST
28-MAR 11:16:54 : ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
28-MAR 11:16:54 : ======= Below records violate the unique constraint =======
28-MAR 11:16:55 : PLAN_ID -1 / SR_INSTANCE_ID 2023 / ORGANIZATION_ID 84 / INVENTORY_ITEM_ID 26361
28-MAR 11:16:55 : ===========================================================
28-MAR 11:16:55 : <>
28-MAR 11:16:55 : <> CREATE UNIQUE INDEX SYSTEM_ITEMS_U1_TST ON
SYSTEM_ITEMS_TST(PLAN_ID,SR_INSTANCE_ID,ORGANIZATION_ID,INVENTORY_ITEM_ID) PARALLEL TABLESPACE
APPS_TS_TX_IDX STORAGE( INITIAL 1048576 NEXT 131072 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE
0) INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS
28-MAR 11:16:55 : ORA-12801: error signaled in parallel query server P000
ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
28-MAR 11:16:55 : UNIQUE index creation on temporary table SYSTEM_ITEMS_TST has completed with
ERROR.
28-MAR 11:16:55 : User-Defined Exception
28-MAR 11:16:55 : User-Defined Exception
28-MAR 11:16:55 : User-Defined Exception
28-MAR 11:16:55 : Sending message :-9999999 to monitor.
Steps:
Run collections, and note that one of the Planning ODS Load Workers completes with a status of Error.
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 |
| Cause |
| Solution |
| References |