Advanced Reporting slow performance known KBs

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

This knowledge article provides a list of known articles related to slow running reports in Clarity which includes Jaspersoft Studio, Advanced Reporting, and Reports and Jobs

Environment

Release : All Supported Releases

Component : CLARITY JASPERSOFT

Resolution

Note: The list of articles may not be a complete list of KBs for Report performance issues, so if a match for your issue isn’t found below, please also search using the Broadcom support search portal. See Known Clarity issues: Tips in using self service.

Table of Contents

• General Performance
  • Post Upgrade
• Custom Reports
• Advanced Reporting page
• Adhoc Reports/Views 
• Jaspersoft Studio
• Create and Update Jaspersoft Users job
• Reports and Jobs
• Health Report

General Performance

• Advanced Reporting slow performance navigating and running reports in Clarity - due to caching issues at workstation level
• Some Jaspersoft Reports are slow to load Filters - due to a slow running query
• 15.4 Jaspersoft Environment really slow - caching issue at multiple levels

Post Upgrade

• Jaspersoft 7.8 Slow after upgrade from 7.13
• JasperSoft reports performing slow after upgrade - JDBC Driver issue

Financial Reports

• Financial reports slower/timing out after upgrade due to DE56072 - (Impacts 15.8, 15.8.1, 15.9, 15.9.1 - Fixed in 15.9.2)

Custom Reports

• Custom report slow performance in Clarity due to issue with SQL Queries - SQL Queries design issues
• Clarity: Performance of Jaspersoft report using High Charts

Advanced Reporting page

• Clarity: Advance Reporting Page slows down while trying to access fonts.googleapis.com when there is no internet on the server where Jaspersoft is installed

Adhoc Reports/Views 

• Adhoc Reports/Views in Advanced Reporting are slow - see for tips on how to optimize performance with Adhoc views. 

Jaspersoft Studio

• Slowness in Jaspersoft Studio -  resource contention, CPU utilization, memory utilization and disc access.

Create and Update Jaspersoft Users job

• Create and Update Jaspersoft Users slow (performance degradation over time) - This is caused by Jaspersoft server performance degradation
• Create and Update Jaspersoft Users job is slow intermittently - due to issue execution plan

Reports and Jobs

• Slowness With Reports Generating under Reports and Jobs

Health Report

• CA PPM Health Report - slow performance and timeout due to DBLINK setup

Additional Information

See also: Jaspersoft / Reports frequently reported issues with Clarity