For some out of the box domains it's not possible to create a Jaspersoft Ad Hoc View.

Article Id: 16955
Status: Published
Updated On: 14-02-2018 07:47
Legacy Id: TEC1506507
Products:
CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM
Issue/Introduction:

Jaspersoft Ad Hoc Views



When trying to create a new Jaspersoft Ad Hoc View, not all out of the box Domains can be selected, for some Domains an onscreen error shows up:

"An error occurred while performing the previous request"

Environment:

Release: 451-101-15.3-Clarity-Creator User License
Component:

Resolution:

This is due to a corruption of the Domains, this can occur for example after an upgrade or migration of the environment.

In order to restore the Domains, following command is to be used:

admin content-jaspersoft csk restoreDomains -userName superuser -password <superuser-password>

1.  Replaces all the OOTB domains which are under ca ppm/domains folder

2.  It updates the schema name of all the OOTB domains to map to the correct schema name

3.  It runs the dynamic domain updates to add DWH enabled custom attribute to the domains.

 

Additional Information:

This can only be used by On Premise customers; the On Demand customers will have to open a Support case.

For a detailed list of Jaspersoft Commands, see:

TEC1027861