Spectrum Reporting Error while running Ad Hoc Jasperserver Report
search cancel

Spectrum Reporting Error while running Ad Hoc Jasperserver Report

book

Article ID: 138939

calendar_today

Updated On:

Products

CA eHealth CA Spectrum

Issue/Introduction

The Jasper report fails when running an Ad Hoc View from the repository:

 

OUTPUT - JASPER REPORT ERROR MESSAGE

Server Error

Error Message

There was an error on the server. Try again or contact site administrators. (Error UID: a5c6fra-6144-466d-1223-2g93ecceb674)

 



Environment

Release : 10.3.2

Component : Spectrum Core / SpectroSERVER

Cause

  • Jasperserver.log (Apache-tomcat/webapps/jasperserver-pro/WEB-INF/logs) shows there is a timeout (with the default timeout value being 360 seconds):

Caused by: com.jaspersoft.commons.util.QueryExecutionTimeoutException: jsexception.QueryExecutionTimeoutException

Arguments: 360,

Resolution

1. Shorten the range for the data being queried.


or 


2. Increase the timeout within Jaspersoft for Adhoc reports:



Additional Information

  • For Jasper Ad hoc reports there is no specific code/logic that Spectrum is handling. 
  • It recommended to follow the Jasper documentation to create Ad hoc reports:

           Working with the Ad Hoc Editor