Load Data Warehouse (DWH) Incremental Job fails if it's run after a fiscal rollover happens and a full load is not run.
STEPS TO REPRODUCE:
Expected Results :- Incremental Load should complete successfully.
Actual Results :- Incremental Load fails with error [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_TME_ENTRY_FACTS. SQLERRM : ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_INTERNAL_MD. SQLERRM : ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found
Release : 15.7,15.7.1,15.8
Component : CLARITY SAAS DATA WAREHOUSE
Database: Postgres and Oracle
This is caused by Defect DE55383 (DE54887, DE48982)
Workaround: Run the DWH Full load to resolve this issue.
Upgrade to 15.8.1 to fix the issue for Postgres DB, 15.9.1 for Oracle DB
See also: Load DWH job frequently reported issues