Clarity PPM - Load Data Warehouse fail -ORA-02298

book

Article ID: 132035

calendar_today

Updated On:

Products

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 
 

Cause

DE43623

Environment

CLARITY PPM 15.4.1, 15.5

 

Resolution

Resolved in 15.4.1 patch 3 and 15.5.1