ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Incremental Load DWH Fails on DWH_INV_IDEA_LN

book

Article ID: 215956

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

Updates performed while the Load Data Warehouse (DWH) job is running will cause the error indicated.
In the example error, the DWH_INV_IDEA load is not picking those up which language table DWH_INV_IDEA_LN, has picked.

ORA-02298: cannot validate (PPM_DWH_OWNER.DWH_INV_IDEA_LN_FK1) - parent keys not found 

If the issue happens, immediately pause the job and run the following query:

select * from dwh_inv_idea_ln where investment_key not in (select investment_key from DWH_INV_IDEA);

Environment

Release : 15.8

Component : CA PPM DATA WAREHOUSE

Resolution

This is reported as DE61075, under Engineering review.

Additional Information

Reference: Load DWH job frequently reported issues