Load Data Warehouse job failing-Relation does not exist

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

You are running Full and Incremental Load Data Warehouse jobs and they are failing with below error - 

ERROR: relation "dwh_lkp_broadcom_programs_v" does not exist.  

(broadcom_programs can be another name)

Environment

Release : 16.0.0

Component : CLARITY DATA WAREHOUSE

Cause

Custom lookup was updated and is not recognized by the DWH

Resolution

Follow the steps on the below knowledge article to find the attributes that are using that lookup and uncheck from the Data Warehouse

Load DWH failing on custom lookup - finding the attribute to disable