Domain error: The Domain schema has an invalid resource

book

Article ID: 200915

calendar_today

Updated On:

Products

Clarity PPM On Premise Clarity PPM SaaS

Issue/Introduction

We encounter the following error when doing one of the below steps trying to create a new custom Jaspersoft domain copying and renaming the existing CA PPM "Investment Management" domain.

The Domain schema is invalid. Review the schema.
The Domain schema has an invalid resource.
Filter condition DWH_INV_INVESTMENT.ZZ_MILESTONE references one or more fields, ID DWH_INV_INVESTMENT.ZZ_MILESTONE

Cause

This can happen if one or more attributes were inactivated on the Clarity side, but are still showing on the DWH side.

Environment

Release : All Supported Releases

Component : Clarity Jaspersoft Reporting

Resolution

  1. Open the investment domain (or domain with the issue) and Edit the Domain Designer.
  2. Navigate to the DISPLAY tab.
  3. Without making any changes, click on OK and it will pop up with an error.
  4. Close the error pop up and under Sets and Items, you will see fields highlighted in RED.
  5. Remove those fields and click OK

Additional Information