RPT-0020 and RPT-0022 - Troubleshooting Guide for these and similar errors

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

This article provides some tips as well as known issues related to various Clarity RPT errors including RPT-0020 and RPT-0022

Environment

Release : All Supported Releases

Component : CA PPM SAAS JASPERSOFT

Resolution

Information to help troubleshoot / narrow down root cause

ID	Troubleshooting step
1	Is it certain reports? (Custom and/or Out of the box)?
2	Where does the issue happen (Reports and Jobs and / or Advanced Reporting)?
3	Does it happen for reports run immediately or scheduled? (or both) (Particularly if issue is happening in reports and jobs)
4	Reviewing the following logs can help uncover root cause: app-ca.logs bg-ca.logs (for Reports and Jobs scheduled reports and Advanced Reporting issues) Check Jasperserver logs from scheduler nodes (For On Premise customers only, SaaS customers, please contact Broadcom support) Tip: Sometimes reproducing the issue in another method (example: scheduled versus immediate, can help uncover an error that wouldn't be found other wise)
5	Check the list of known issues below and self service for known issues based on symptoms/errors found in logs
6	If assistance is needed from Broadcom, providing the above information can help expedite a solution:

Known issues:

• If the below information doesn't help, we also recommend utilizing our self service (See Tips on searching for known Clarity Issues using Self Service) as this may not be an all inclusive list.

KB	Description
122803	Error "RPT-0020" Due to 500 page or 1000 page report limit in Clarity
8283	Unable to run a Jaspersoft Report from Reports and Jobs menu Due to Jaspersoft version issue
109882	RPT error 0022 while executing report from Reports and Jobs Due to missing access rights in either Clarity or on the Advanced Reporting folder.
199278	Report are not working from Reports and Jobs - RPT-0020 error Due to tablespace issue
141270	RPT-0020 is thrown when running Reports from "Reports and Jobs" page Due to incorrect updating of permissions of Out of the Box Jaspersoft Roles.
197533	Report (Trended Project Metrics) throws RPT-0020 error message Due to Trending jobs being pending.
136629	Error RPT-0022 When User Runs Jaspersoft Report due to access / folder permission issues Due to Corruption with the Advanced Reporting folder or Restrictions from the browser
198279	RPT-0022 Error when changing one or more parameters from Reports and Jobs Due to folder permission issue
125267	RPT-0020 or RPT-0015 error when running report from Reports and Jobs Due to the Jaspersoft service is hanging, non-responsive.

Best Practices to avoid these types of errors:

• Manage permissions from within Classic Clarity and not from Advanced Reporting, utilizing out of the box reporting groups in Clarity where possible to manage permissions. 

Additional Information

See also Clarity Master KBs for frequently reported issues