The Load Data Warehouse (DWH) job fails with the following error:
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-02437: cannot validate (PPM_DWH.DWH_INV_TEAM_PK) - primary key violated
ORA-06512: at line 7
Component: Data Warehouse
The duplicate record cannot be deleted via the UI, and must be done via the database. You must ensure that the record that is being left in place (the one NOT being deleted) must point to the proper team_id.
select odf_pk, count(odf_pk) from dwh_team_vThis will show you the ones that have duplicates.
group by odf_pk
having count(odf_pk) > 1
select * from dwh_team_v where odf_pk in (PUT_LIST_OF_ODF_PK_VALUES_HERE )