Custom report slow performance in Clarity due to issue with SQL Queries

Article Id: 194701
Status: Published
Updated On: 08-07-2020 20:12
Products:
Clarity PPM SaaS
Issue/Introduction:

  1. Some reports take over 10 minutes to run.
  2. The reports are all custom reports or customized standard reports. 

Examples:

  • Gantt Summary Report 
  • Project Summary Report 
  • Project Status Report
  • Project KPI Report 

Cause:

This type of issue can occur with any poorly formed SQL queries

Environment:

Release : All Supported Releases

Component : CA PPM SAAS JASPERSOFT

Resolution:

For this issue, the report designer would need to be contacted to assist in redesign of the report queries. Some tips:

  1. Evaluate the security used in the queries of the Reports including changing "inner-joins" to different checks. 
  2. Try adding/removing conditions to help determine any improvements that can be made based on improvements noticed with conditions

Additional Information:

See:194700 - Advanced Reporting: Known KBs related to slow performance