Load Data Warehouse - Incremental Job Failed

Document ID : KB000103954
Last Modified Date : 02/07/2018
Show Technical Document Details
Question:
Load Data Warehouse - Incremental Job Failed.
How do we fix it? 

Error Logs: 
ClarityDB - isOracle? - An error occurred executing this job entry : 
Couldn't execute SQL: BEGIN 
DWH_RES_PERIOD_FACTS_LOAD ( 
P_DBLINK => 'SC99999pDWH_SC99999p', 
P_ARRAY_SIZE => 50000, 
P_FULL_RELOAD => 'N' 

); 
END; 

[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_RES_PERIOD_FACTS. SQLERRM : ORA-00001: unique constraint (SC99999PDWH.DWH_RES_PER_FACTS_U1) violated 
ORA-06512: at "SC99999PDWH.DWH_RES_PERIOD_FACTS_LOAD", line 75 
ORA-06512: at line 2 
Answer:
Sometimes a Full run fixes the Incremental failure. If this case a Full run resolved the issue.