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

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