Jaspersoft scheduled report fails - setReportParameterValues

Products

• Clarity PPM On Premise
• Clarity PPM SaaS

Issue/Introduction

• Adhoc View is created
• Adhoc Report is created using the Adhoc View mentioned above
• The Adhoc Report is then scheduled to execute at pre-defined intervals
• After quite a while of successful executions, the report starts failing
• Error in the jasperserver.log is as follows:
  com.jaspersoft.jasperserver.api.JSException: Exception getting data strategyexception getting dataset from cache
Arguments: 
 at com.jaspersoft.ji.adhoc.datasource.AdhocDataSourceService.setReportParameterValues(AdhocDataSourceService.java:149)
 at com.jaspersoft.ji.adhoc.datasource.AdhocDataSourceService.setReportParameterValues(AdhocDataSourceService.java:163)
 at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1875)
 ...
 Suppressed: com.jaspersoft.jasperserver.api.CacheDatasetException: exception getting dataset from cache
 ... 
 Caused by: com.jaspersoft.commons.dataset.DataSetException: Failed fetching dataset
 ...
 Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching data
 ...
 Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() 

Resolution

• Reselect the report parameters
• Resubmit the report schedule.