AnsweredAssumed Answered

Load Data Warehouse job fails with ORA-06512: cannot CREATE UNIQUE INDEX; duplicate keys found on DWH_INV_SUMMARY_FACTS

Question asked by magechintu on Jun 8, 2016
Latest reply on Jun 14, 2016 by Chris_Hackett

ClarityDB - isOracle? - An error occurred executing this job entry :
Couldn't execute SQL: BEGIN
DWH_INV_SUM_FACTS_LOAD(
P_DBLINK => 'CLARITYDBLINK',
P_ARRAY_SIZE => 50000
);
END;

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INV_SUM_FACTS_LOAD. SQLERRM : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
ORA-06512: at "PPM_DWH.DWH_INV_SUM_FACTS_LOAD", line 70
ORA-06512: at line 2

Outcomes