Ad-hoc view fails to load with Server Error - exception getting dataset from cache

Document ID : KB000098896
Last Modified Date : 31/05/2018
Show Technical Document Details
Issue:
Post CA PPM Upgrade all Ad-hoc Views started failing with:
Server Error - exception getting dataset from cache

 
Environment:
CA PPM SaaS and 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.