ODS Load worker
Hi,We are implementing ASCP for centerlized installation. I ran standard collection and request 'Planning ODS Load Worker' completes with error. Log file shows following error message.
''
18-SEP 10:34:43 : Unique index violated - ITEM_CATEGORIES_U1_ABL 18-SEP 10:34:43 : ORA-12801: error signaled in parallel query server P000 ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found 18-SEP 10:34:43 : ======= Below records violate the unique constraint ======= 18-SEP 10:34:43 : ORGANIZATION_ID 101 / SR_INSTANCE_ID 2022 / INVENTORY_ITEM_ID 1391 / CATEGORY_SET_ID 8 / SR_CATEGORY_ID 1238 18-SEP 10:34:43 : ORGANIZATION_ID 101 / SR_INSTANCE_ID 2022 / INVENTORY_ITEM_ID 1391 / CATEGORY_SET_ID 11 / SR_CATEGORY_ID 3130 18-SEP 10:34:43 : =========================================================== 18-SEP 10:34:43 : <<create_temp_table_index>> 18-SEP 10:34:43 : <<SQL>> CREATE UNIQUE INDEX ITEM_CATEGORIES_U1_ABL ON ITEM_CATEGORIES_ABL(ORGANIZATION_ID,SR_INSTANCE_ID,INVENTORY_ITEM_ID,CATEGORY_SET_ID,SR_CATEGORY_ID) PARALLEL TABLESPACE APPS_TS_TX_IDX PCTFREE 10 INITRANS 11 MAXTRANS 255 COMPUTE STATISTICS 18-SEP 10:34:43 : ORA-12801: error signaled in
0