search cancel

Load Data Warehouse job fails with error in domain update


Article ID: 5058


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


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

Note: This can happen on any out of box domain 


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


All Supported Version 


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.