Load Data Warehouse is failing with column does not exist

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Load Data Warehouse is failing with error below

ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING INTO DWH_CMN_HIERARCHY. column a.language_code does not exist Where: PL/pgSQL function inline_code_block line 24 at RAISE

Cause

The dwh_odf_cmn_hierarchy_ln table was missing

Resolution

There were bad attributes in the Hierarchy object.  Removed them from the data warehouse and ran full load successfully