Load Data Warehouse job fails with error in domain update

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

Problem Statement: Load Data warehouse fails while performing the dynamic domain update. Below are the logs which can be seen in bg dwh logs.

Error occurred while processing domain attributes. 
SQL error code: 0
Error message: ERROR: column "z_2026" does not exist
  Position: 8
Executed:

Note: This can happen on any out of box domain 

Environment

All Supported Version 

Cause

As the Job Load Dataware house Job runs it dynamically updated the attributes included in DWH for out of box domains and these errors are likely if object/attributes are excluded while the Job Load Dataware house was running

Resolution

This is a schema synchronization issue between PPM and DWH where the Job Load Dataware house completes, and the Jaspersoft part fails on domain update. To resolve the issue please do the following:

1. Run the Job Restore domains followed by Load Dataware jobs full load 

  

Note: Before applying the solution please ensure you do not have any customizations applied to the domains or custom domains  and kept under CA PPM folder as it will overwrite to out of box status.