Load DWH failing with error Language_id does not exist

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Load Data Warehouse job is failing on a specific Lookup attribute. An error seen like:

ERROR: ENCOUNTERED EXCEPTION WHILE INSERTING IN DWH_LOOKUP_LOAD DWH_LKP_LOOKUPNAME_00. column src.language_id does not exist

 

Environment

Any supported clarity version 

Resolution

This error is caused by a Lookup using a Query that doesn't include the Language_id information.

Based on the documentation, In this section: "Rules for Including Language Translations in the Data Warehouse" LANGUAGE_CODE and LANGUAGE_ID are required to be included in the query:" Always include a select column named LANGUAGE_CODE, Always include a select column named LANGUAGE_ID"