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
Post CA PPM Upgrade all Ad-hoc Views started failing with:
Server Error - exception getting dataset from cache

CA PPM SaaS and CA PPM On Premise
When upgrading Jaspersoft and advanced reporting content, the domain data that is imported can get corrupted sometimes.
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 patch or patch respectively to use the Restore Domains Job.