Jaspersoft Domains do not have the custom DWH fields (How to reset the Jaspersoft domains)

Article Id: 107615

Status: Published

Updated On: 23-07-2018 08:30

Products:

CLARITY PPM FOR ITG , CA Project & Portfolio Management , CLARITY PPM FEDERAL , CA Project & Portfolio Management SAAS , STARTER PACK-CLARITY PPM

Issue/Introduction:

The custom fields checked for DWH are not appearing in the Jaspersoft Advanced Reporting domains for users to create their ad hoc queries.
We executed the DB schema report and the attributes are there in the DWH tables but not in domains. What can we do to fix the issue?

Environment:

Release: CODFSS99000-15.4.1-PPM SAAS FedRAMP-Sandbox-Small Environment
Component:

Resolution:

1. Run the command:

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

This will reset the OOTB Jaspersoft domains to default.
2. Once done, run Load DWH job – Full Load until completion.
This job will create all custom attributes and update all OOTB attributes (when needed) to Jaspersoft domain.