Hello, I am also experiencing this issue while using Ad Hoc Reports. This seems to be an issue with large datasets as I can run the report for 1 or 2 weeks but as soon as I set the input control to 1 month I get the below errors: Your help with this issue would be appreciated as the tool is more or less useless at this time. java.lang.IllegalArgumentException: error getting datarator at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport(AdhocEngineServiceImpl.java:1883) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.execute(AdhocEngineServiceImpl.java:1815) at com.jaspersoft.ji.report.options.engine.ReportOptionsExecutionJob.executeReport(ReportOptionsExecutionJob.java:113) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.executeAndSendReport(ReportExecutionJob.java:422) at com.jaspersoft.jasperserver.api.engine.scheduling.quartz.ReportExecutionJob.execute(ReportExecutionJob.java:231) at org.quartz.core.JobRunShell.run(JobRunShell.java:195) at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:520) Caused by: java.lang.RuntimeException: exception getting dataset from cache at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:154) at com.jaspersoft.ji.adhoc.strategy.NewClassicDataStrategy.getWorkingDataSet(NewClassicDataStrategy.java:113) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:897) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getRuntimeDataSet(CommonDomainDataStrategy.java:1036) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.getDatarator(AdhocEngineServiceImpl.java:405) at com.jaspersoft.ji.adhoc.service.AdhocEngineServiceImpl.fillReport(AdhocEngineServiceImpl.java:1881) ... 6 more Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching from cache at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getFromCache(CommonDomainDataStrategy.java:982) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getFromCache(CommonDomainDataStrategy.java:962) at com.jaspersoft.ji.adhoc.strategy.NewClassicDataStrategy$1.getFromCache(NewClassicDataStrategy.java:107) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:72) ... 11 more Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching data at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:150) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getFromCache(CommonDomainDataStrategy.java:979) ... 14 more Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:282) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:117) ... 15 more Caused by: com.jaspersoft.commons.util.QueryExecutionTimeoutException: jsexception.QueryExecutionTimeoutException at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:139) at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet.getJRDataSource(JRQueryDataSet.java:178) at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet.access$100(JRQueryDataSet.java:49) at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:280) ... 16 more
