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.

 

Environment

Release : 15.8

Component : CA PPM SAAS APPLICATION

Cause

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

Resolution

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