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

Document ID : KB000098893
Last Modified Date : 31/05/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.
- 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.