If a baseline is updated in OWB where OWB time zone is ahead of clarity time zone, so the baseline updated date shows in the future compared to Clarity, Load Data Warehouse job - Full Load will create orphan record in DWH_INV_PROJECT_LN table. After that, the subsequent run of Load Data Warehouse job will fail for a long hours with below error messages.
Couldn't execute SQL: ALTER TABLE DWH_INV_PROJECT_LN ENABLE VALIDATE CONSTRAINT DWH_INV_PROJECT_LN_FK1
[CA Clarity][Oracle JDBC Driver][Oracle]ORA-02298: cannot validate (XXXXXXX.DWH_INV_PROJECT_LN_FK1) - parent keys not found ...
Steps to Reproduce:
where object_type ='PROJECT'
and object_id =XXXXXXXX
Expected result: The project to be brought in Data Warehouse investments successfully
Actual result: Load Data Warehouse job fails, with error:
ORA-02298: cannot validate (XXXXXXX.DWH_INV_PROJECT_LN_FK1) - parent keys not found.
Any subsequent runs will fail too, until the future date from step 9 is reached.
Fixed in 15.4.