Could not update agl_accepted_stay_points of object to domain CSK_PRJ_Management

Products

• Clarity PPM On Premise

Issue/Introduction

Load Data Warehouse job with (Full Load) option fails with:

Error occurred while processing domain attributes. Could not update agl_accepted_stay_points of object to domain CSK_PRJ_Management 

NJS-0401: Execution of job failed. 

Cause

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

Environment

CA PPM SaaS & CA PPM On Premise

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.

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