Upgrade Fails with 'parent keys not found' Error

book

Article ID: 197897

calendar_today

Updated On:

Products

Clarity PPM On Premise

Issue/Introduction

The upgrade script has failed with the error below in the install.log:

...(ExecTask) Caused by: java.sql.SQLException: [CA Clarity][Oracle JDBC Driver][Oracle]ORA-20000: Error: ORA-02298: cannot validate (PPM_DWH.DWH_FIN_TRANSACTION_FACTS_FK1) - parent keys not found

Cause

This can occur if the latest run of the Load Data Warehouse job was not successful prior to the upgrade. 

Environment

Release : 15.x

Component : CA PPM INTEGRATIONS & INSTALLATIONS

Resolution

Rollback and perform a successful run of the Data Warehouse job (Full Load) prior to re-attempting the upgrade. Alternatively, rollback and apply a blank Data Warehouse schema.