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.

 

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.