When running the full load, one of the following errors appears in the BG DWH log:
Error for table 'DWH_X_RES_AVAIL_PER_FACTS' - Error Number 1505
'The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'ppm_dwh.DWH_X_RES_AVAIL_PER_FACTS' and the index name
'DWH_X_RES_AVAIL_PER_FACTS_U1'. The duplicate key value is (xxxxxx, xxxxxxx).'
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-20100: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_X_RES_AVAIL_PER_FACTS. SQLERRM : ORA-00001: unique constraint (PPM_DWH.DWH_X_RES_AVAIL_PER_FACTS_U1) violated
ORA-06512: at "PPM_DWH.DWH_X_RES_AVAIL_PER_FACTS_LOAD", line 110
ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_CMN_PERIOD. duplicate key value violates unique constraint "dwh_cmn_period_u1"
Where: PL/pgSQL function inline_code_block line 23 at RAISE
Any
select * from prcalendar
where PRRESOURCEID in
( select PRRESOURCEID from prcalendar
group by PRRESOURCEID
having count(PRRESOURCEID) > 1 )
select prcalendarid from prj_resources where prid ='<resource id from step 1>
delete from prcalendar where prid = <id of the one which should be removed>