Error: "JasperReports Server encountered an error..." running Adhoc report using Financial Management domain on PG

Products

• Clarity PPM SaaS

Issue/Introduction

Users getting error "JasperReports Server encountered an error while generating this report.  Please contact your administrator" when running an Adhoc report using Financial Management domain on PG.

Steps to Reproduce:

1. Create user-defined Adhoc views using the stock Financial Management domain.
2. Run stock Financial Reports and run Adhoc Reports.

Expected Results: The reports run successfully.
Actual Results: The reports time out after 6 minutes.

Environment

Release : 15.8.1

Component : CLARITY SAAS JASPERSOFT

Cause

Caused by: com.jaspersoft.commons.util.QueryExecutionTimeoutException: jsexception.QueryExecutionTimeoutException
Arguments: 360,
Query is taking more then 360 seconds so it is timing out

Resolution

Internal defect DE55015, Fixed in 15.9

DE58438 : Ad Hoc Views and Reports Based on the OOTB Financial Management Domain are Failing, Fixed in 15.9.1 and 15.9.0.1