Load Data Warehouse Job Fails with - Error occurred while processing domain attributes

Document ID : KB000098893
Last Modified Date : 12/09/2018
Show Technical Document Details
Issue:
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



 
Environment:
CA PPM SaaS & CA PPM On Premise
Cause:
When upgrading Jaspersoft and advanced reporting content, the domain data that is imported can get corrupted sometimes.
Resolution:
As administrator,
- 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.
Additional Information:
Important!  CA PPM SaaS customers on versions 14.4 and 15.1 must apply either 14.4.0.6 patch or 15.1.0.4 patch respectively to use the Restore Domains Job.

List of Jaspersoft Commands in accordance with CA PPM Version