search cancel

Custom Jaspersoft Report Not Completing in PostgreSQL

book

Article ID: 201930

calendar_today

Updated On:

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.