Issue

In Pega Platform™ users observe one or more of the following issues:

• Insights fail to load or display unexpected results.
• Explore Data functionality does not return data.
• Dashboard views appear duplicated.
• Dashboard content is missing or inconsistent.
• Report Definition execution behaves unexpectedly.
• Errors occur when loading dashboard-based data sources.

Symptoms and Impact

Explore Data and/or Dashboard features fail. This includes the ability to create or view insights, create dashboards etc.

Steps to Reproduce

1. Create an Insight in Constellation using App Studio
2. Open an Insight in Work Portal

OR

1. Launch the Work Portal
2. Click Dashboards
3. Create a new Dashboard

Root Cause

• Database structures were altered outside of Pega installation and update procedures.
• Primary key constraints were removed from Pega-related tables.

Therefore, the resulting schema no longer matched the database design expected by the Pega Platform.

Pega relies on the integrity of the delivered database schema, including indexes, keys, and constraints, for correct query generation, data retrieval, reporting, and dashboard processing. Altering these database objects can result in unpredictable application behaviour and data inconsistencies.

Solution

To resolve the issue, restore the database schema to the configuration expected by the Pega Platform, including re-establishing the required primary key definitions and database constraints.

Prevention

• Do not manually modify Pega-managed database schemas.
• Unsupported changes include, but are not limited to:
  • Dropping primary keys.
  • Modifying or removing database constraints.
  • Altering delivered table structures.
  • Renaming database objects used by Pega.
  • Changing indexes without guidance from Pega.

Making such modifications might lead to application instability, reporting failures, dashboard issues, data integrity problems, and update challenges.

Best Practice

• Maintain the database schema as delivered and managed by Pega.
• Follow official Pega update and deployment procedures for any schema-related changes.
• Consult Pega Support before making modifications to Pega-owned database objects.
• Validate database integrity after updates or infrastructure changes.

References

Explore Data feature

 Explore Data applies association-based filters without column selection