"Error Filling Report" received on Custom Report

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

A user receives an error when trying to run a Custom Report.

Below is the error in the jasperserver.log

ERROR-AsyncJasperPrintAccessor,pool-7-thread-890:321 [] - Error during report execution net.sf.jasperreports.engine.JRException: Error executing SQL statement for: Project Financial Report V4

Caused by: org.postgresql.util.PSQLException: ERROR: invalid input syntax for integer: ""

Cause

The custom query used for the report is invalid

Resolution

Troubleshooting custom reports are out of the scope for our support group.  The user should contact the person who originally wrote the report

Clarity PPM Modification/Customization Policy