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 

Environment

Release : All Supported Releases

Component : CA PPM SAAS JASPERSOFT

Cause

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

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