Clarity PPM - Load Data Warehouse fail -ORA-02298
Article ID: 132035
Updated On:
Products
CLARITY PPM FOR ITG
CLARITY PPM FEDERAL
Clarity PPM SaaS
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
* 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
Feedback
Yes
No
Powered by
