Advanced Reporting slow performance known KBs

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

Known articles related to slow running reports in Clarity including:

• Jaspersoft Studio
• Advanced Reporting
• Reports and Jobs

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
• Financial Reports
• 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 / running reports - general troubleshooting steps
• Some Jaspersoft Reports are slow to load Filters - due to a slow running query

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
• 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 when the query needs to be updated

Reports and Jobs

• Reports slowness under Reports and Jobs compared to Advanced Reporting

Health Report

• Health Report - slow performance and timeout with error "ORA-12154" due to DBLINK setup

Additional Information

See also: Jaspersoft / Reports frequently reported issues with Clarity