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
Release : ANY
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"