Load Data Warehouse (DWH) job - Full load fails with FK errors after another Full Load DWH was Cancelled or Failed on any table
Error referenced: ORA-02298: cannot validate (***************_FK1) - parent keys not found (It can be on any FK.)
Steps to Reproduce:
Expected Result: Load DWH job to complete successfully as it truncates the tables before inserting new data.
Actual Result: The job fails with ORA-02298: cannot validate (***************_FK1) - parent keys not found (It can be on any FK.)
This can be due to synchronization issues with the data between the Clarity PPM and DWH databases. When making particular changes to the PPM database, the views have not been made to the DWH database by making sure to run the full Load DWH job daily.