Error RPT-0020 in Project Status Summary Report

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When running the Project Status Summary report from Report and Jobs, users receive the error code RPT-0020. 

The app-ca.log shows the errors below - 

• Error while downloading report.

• com.ca.jasper.restAdapter.JasperException: Resource /ca_ppm_reports_output/CSK_PRJ_ProjectStatusSummary_...xlsx not found.

• Error Message: Error filling report, Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: bigint = character varying. Hint: No operator matches the given name and argument types. You might need to add explicit type casts.

• CIRCULAR REFERENCE: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: CSK_PRJ_ProjectStatusSummary.

Environment

All supported releases

Cause

The report's SQL query fails when the Project Status parameter is left unselected/blank.

• When the parameter is empty, the report attempts to execute a SQL comparison (e.g., WHERE status_id = ' ') where a database field of type bigint (a number/ID) is being compared to an empty character varying (a string), leading to the operator does not exist: bigint = character varying error.

• This SQL execution failure prevents the report from generating, leading to the "Resource not found" error for the output file and the user-facing RPT-0020 error.

Resolution

The user should select at least one value for the Project Status parameter when running the report.