Load Data Warehouse job with (Full Load) option fails with:
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
CA PPM SaaS & CA PPM On Premise
When upgrading Jaspersoft and advanced reporting content, the domain data that is imported can get corrupted sometimes.
- Run the Restore Domains job with Content Pack 'CSK' to restore the domains to their original state and dynamically update these domains with the appropriate custom objects and attributes.
- Or execute the following admin command on the App Server: admin content-jaspersoft csk restoreDomains -userName superuser –password superuser
- Once this Job completes successfully rerun Load Data Warehouse job with (Full Load) option.
NOTE: The Restore Domains Job does not complete if you do not have the right Jaspersoft Server configured.