Long running queries triggered from Clarity Native Reporting Data Providers

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• There is a functionality called Data Providers in Clarity Native Reporting capability
• Within that there is a functionality to Preview data
• When that option is used, it is noticed that data does not get returned. No errors are seen
• In the backend, it is noticed that the query that is sent to the DB to fetch data keeps processing even after an hour, and does not return results.

Cause

Inefficient Data Provider configuration.

Resolution

The Data Provider has to be fine-tuned.

• Review the Objects and Columns that have been selected. Select only those that are needed
• Review the Joins and operators used for those joins
• Use Pre-filters to reduce data.