Custom Jaspersoft Report Not Completing in PostgreSQL

Products

• Clarity PPM SaaS
• Clarity PPM On Premise

Issue/Introduction

When running a custom report and/or ad hoc view, it never completes.

 

Cause

Upon review of the SQL, the casting in the filter section was incorrectly case.

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Resolution

Engineering team found that using bigint instead of varchar allowed the report to complete.