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
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:
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.