CA PPM: Load Data Warehouse job fails with _FK errors

Document ID : KB000035711
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:
Issue:
Load Data Warehouse job - Full load fails with FK errors after another Full Load Data Warehouse job (DWH) was Cancelled or Failed on any table

Steps to Reproduce:

1. Connect to CA PPM with Data Warehouse set up
2. Ensure the Load Data Warehouse job completes successfully
3. Go to Home, 'Reports and Jobs' or 'Jobs' menu link
4. Run a new Load Data Warehouse job with Full Load option selected
5. Wait for a minute, then Cancel the job
6. Now go and schedule another instance of Load Data Warehouse Job
7. Note that it's now in Waiting mode, until you delete the Cancelled instance
8. After the deletion, it's Processing, wait for the results

Expected Result:  Load Data Warehouse 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.)
Environment:

 
Environment:
CA PPM 14.2+

 
Cause:
Caused by CLRT-79090





 
Resolution:

This can be due to several synchronization with the data between the 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.

So to resolve the issue, either run the full Load Data Warehouse job to completion.