Dwh_inv_investment.risk_score does not exist

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

After upgrading Clarity to 15.9.3 or newer versions, the DWH jobs may fail with an error:

Process Meta Tables - ERROR: ENCOUNTERED EXCEPTION WHILE CREATING VIEW DWH_TRD_INV_INVESTMENT. column dwh_inv_investment.risk_score does not exist

 

 

Environment

Release : 15.9.3, 16.0.0

Cause

risk_score is a new column introduced to the Investment object beginning in 15.9.3.

Resolution

If this error occurs, the Data Warehouse job should be run, using the Full load options.