Load DWH failing: 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

Release : ANY

Resolution

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

Based on the documentation: https://techdocs.broadcom.com/us/en/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm-on-premise/16-0-2/administration/configure-lookups.html

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"