ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Load DWH Job Fails - "Error occurred while processing domain attributes"


Article ID: 98893


Updated On:


Clarity PPM On Premise Clarity PPM SaaS


Load Data Warehouse job (DWH) with (Full Load) option fails with error similar to:
Error occurred while processing domain attributes. Could not update attribute sr_cost_effort_status_key of object cop_prj_statusrpt to domain CSK_PRJ_Management


When upgrading Jaspersoft and advanced reporting content, the domain data that is imported can get corrupted sometimes.


Clarity Load Data Warehouse


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

Step 1: Restore Domains using one of the options below

Option 1: Run the Restore Domains job with Content Pack 'CSK' to restore the domains

This will restore domains to their original state and dynamically update these domains with the appropriate custom objects and attributes.


Option 2: Execute the following admin command on the Clarity Application Server

admin content-jaspersoft csk restoreDomains -userName superuser -password superuser

NOTE: The Restore Domains Job will not complete if you do not have Jaspersoft correctly configured.

Step 2:  Run Load Data Warehouse job - Full Load

Once the above step completes successfully re-run the Load DWH job in Full mode

Additional Information

Important!  Clarity SaaS customers on versions 14.4 and 15.1 must apply either patch or patch respectively to use the Restore Domains Job.

See also: