Clarity PPM - Load Data Warehouse fail -ORA-02298

Article Id: 132035

Status: Published

Updated On: 10-05-2019 08:02

Products:

CLARITY PPM FOR ITG , Clarity PPM On Premise , CLARITY PPM FEDERAL , Clarity PPM SaaS , Clarity PPM SaaS - Application , Clarity PPM SaaS - Application , Clarity PPM On Premise

Issue/Introduction:

STEPS TO REPRODUCE

* Trigger the Load Data Warehouse job
* Keep creating Roadmap Items, and Roadmaps

or

* Keep changing Roadmap Item positions

Expected Result: Load Data Warehouse job completes without any issues

Actual Result: Receive error ORA-02298: cannot validate (XXXXX.DWH_RDM_ITEM_POSITION_FK3) - parent keys not found

Cause:

DE43623

Environment:

CLARITY PPM 15.4.1, 15.5

Resolution:

Resolved in 15.4.1 patch 3 and 15.5.1