[#5556] - Error when I add date column with some null values to report from virtual data source

I am using AWS edition of Jaspersoft.

I get the following error (details below) when I run a report that has a date column added and some of the values in the column are null. I created the report in ad hoc view with no data and saved it as a report. If I try running with data in ad hoc view I get an error there, too (but less info in the error report). If I remove the date column with nulls from the ad hoc view, it runs fine. If I add a different date column that has no null values, the report runs fine.

The report is based on a virtual data source that combines two different AWS RDS MySQL instance-based data sources. The driver is org.mariadb.jdbc.Driver. The time zone is set use UTC. They are combined in a domain with a full outer join between one view from each data source. When I create different ad hoc views with the same date columns based on domains from the individual data sources (not yet combined into a virtual data source), the reports run fine. The date columns with null values only cause errors when I use them from the virtual data source/combined domain.

Here are the error details:
Error Details
The server has encountered an error. Please excuse the inconvenience.
Error Message

exception getting data strategy
Error Trace

com.jaspersoft.jasperserver.api.JSException: exception getting data strategy at com.jaspersoft.ji.adhoc.datasource.AdhocDataSourceService.setReportParameterValues(AdhocDataSourceService.java:168) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1729) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.RuntimeException: exception getting dataset from cache at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:143) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:71) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1240) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getRuntimeDataSet(CommonDomainDataStrategy.java:1538) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getRuntimeDataSet(DomainDataStrategy.java:259) at com.jaspersoft.ji.adhoc.strategy.FlattenedWorkingDataSetStrategy.getRuntimeDataSet(FlattenedWorkingDataSetStrategy.java:86) at com.jaspersoft.ji.adhoc.datasource.AdhocDataSourceService.setReportParameterValues(AdhocDataSourceService.java:141) ... 8 more Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching from cache at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:277) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:106) ... 14 more Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching data at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:255) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:273) ... 15 more Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select "DanyQA_dph_active_videos_dish"."network_name" as "DanyQA_dph_active_videos_dish_network_name", "DanyQA_dph_active_videos_dish"."video_title" as "DanyQA_dph_active_videos_dish_video_title", "MediaViewQA_active_video"."aw_date_dead" as "MediaViewQA_active_video_aw_date_dead", "MediaViewQA_active_video"."network_name" as "MediaViewQA_active_video_network_name", "MediaViewQA_active_video"."video_title" as "MediaViewQA_active_video_video_title" from "MediaViewQA"."active_video" "MediaViewQA_active_video" full outer join "DanyQA"."dph_active_videos_dish" "DanyQA_dph_active_videos_dish" on ("MediaViewQA_active_video"."video_guid" = "DanyQA_dph_active_videos_dish"."video_guid") where "MediaViewQA_active_video"."network_name" in ('FOX') order by "MediaViewQA_active_video_network_name" limit 200001 at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:432) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:219) ... 16 more Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156) ... 1 more Caused by: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:694) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:533) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:529) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257) ... 3 more Caused by: org.teiid.core.TeiidException at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1054) at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:563) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:363) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:297) at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171) at com.sun.proxy.$Proxy177.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:661) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:527) ... 6 more Caused by: java.lang.NullPointerException
Error Message

java.lang.RuntimeException: exception getting dataset from cache
Error Trace

java.lang.RuntimeException: exception getting dataset from cache at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:143) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:71) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1240) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getRuntimeDataSet(CommonDomainDataStrategy.java:1538) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getRuntimeDataSet(DomainDataStrategy.java:259) at com.jaspersoft.ji.adhoc.strategy.FlattenedWorkingDataSetStrategy.getRuntimeDataSet(FlattenedWorkingDataSetStrategy.java:86) at com.jaspersoft.ji.adhoc.datasource.AdhocDataSourceService.setReportParameterValues(AdhocDataSourceService.java:141) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1729) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching from cache at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:277) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:106) ... 14 more Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching data at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:255) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:273) ... 15 more Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select "DanyQA_dph_active_videos_dish"."network_name" as "DanyQA_dph_active_videos_dish_network_name", "DanyQA_dph_active_videos_dish"."video_title" as "DanyQA_dph_active_videos_dish_video_title", "MediaViewQA_active_video"."aw_date_dead" as "MediaViewQA_active_video_aw_date_dead", "MediaViewQA_active_video"."network_name" as "MediaViewQA_active_video_network_name", "MediaViewQA_active_video"."video_title" as "MediaViewQA_active_video_video_title" from "MediaViewQA"."active_video" "MediaViewQA_active_video" full outer join "DanyQA"."dph_active_videos_dish" "DanyQA_dph_active_videos_dish" on ("MediaViewQA_active_video"."video_guid" = "DanyQA_dph_active_videos_dish"."video_guid") where "MediaViewQA_active_video"."network_name" in ('FOX') order by "MediaViewQA_active_video_network_name" limit 200001 at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:432) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:219) ... 16 more Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156) ... 1 more Caused by: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:694) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:533) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:529) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257) ... 3 more Caused by: org.teiid.core.TeiidException at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1054) at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:563) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:363) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:297) at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171) at com.sun.proxy.$Proxy177.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:661) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:527) ... 6 more Caused by: java.lang.NullPointerException
Error Message

com.jaspersoft.commons.dataset.DataSetException: exception fetching from cache
Error Trace

com.jaspersoft.commons.dataset.DataSetException: exception fetching from cache at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:277) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:106) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:71) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1240) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getRuntimeDataSet(CommonDomainDataStrategy.java:1538) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getRuntimeDataSet(DomainDataStrategy.java:259) at com.jaspersoft.ji.adhoc.strategy.FlattenedWorkingDataSetStrategy.getRuntimeDataSet(FlattenedWorkingDataSetStrategy.java:86) at com.jaspersoft.ji.adhoc.datasource.AdhocDataSourceService.setReportParameterValues(AdhocDataSourceService.java:141) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1729) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: com.jaspersoft.commons.dataset.DataSetException: exception fetching data at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:255) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:273) ... 15 more Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select "DanyQA_dph_active_videos_dish"."network_name" as "DanyQA_dph_active_videos_dish_network_name", "DanyQA_dph_active_videos_dish"."video_title" as "DanyQA_dph_active_videos_dish_video_title", "MediaViewQA_active_video"."aw_date_dead" as "MediaViewQA_active_video_aw_date_dead", "MediaViewQA_active_video"."network_name" as "MediaViewQA_active_video_network_name", "MediaViewQA_active_video"."video_title" as "MediaViewQA_active_video_video_title" from "MediaViewQA"."active_video" "MediaViewQA_active_video" full outer join "DanyQA"."dph_active_videos_dish" "DanyQA_dph_active_videos_dish" on ("MediaViewQA_active_video"."video_guid" = "DanyQA_dph_active_videos_dish"."video_guid") where "MediaViewQA_active_video"."network_name" in ('FOX') order by "MediaViewQA_active_video_network_name" limit 200001 at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:432) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:219) ... 16 more Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156) ... 1 more Caused by: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:694) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:533) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:529) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257) ... 3 more Caused by: org.teiid.core.TeiidException at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1054) at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:563) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:363) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:297) at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171) at com.sun.proxy.$Proxy177.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:661) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:527) ... 6 more Caused by: java.lang.NullPointerException
Error Message

com.jaspersoft.commons.dataset.DataSetException: exception fetching data
Error Trace

com.jaspersoft.commons.dataset.DataSetException: exception fetching data at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:255) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:273) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:106) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:71) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1240) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getRuntimeDataSet(CommonDomainDataStrategy.java:1538) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getRuntimeDataSet(DomainDataStrategy.java:259) at com.jaspersoft.ji.adhoc.strategy.FlattenedWorkingDataSetStrategy.getRuntimeDataSet(FlattenedWorkingDataSetStrategy.java:86) at com.jaspersoft.ji.adhoc.datasource.AdhocDataSourceService.setReportParameterValues(AdhocDataSourceService.java:141) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1729) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select "DanyQA_dph_active_videos_dish"."network_name" as "DanyQA_dph_active_videos_dish_network_name", "DanyQA_dph_active_videos_dish"."video_title" as "DanyQA_dph_active_videos_dish_video_title", "MediaViewQA_active_video"."aw_date_dead" as "MediaViewQA_active_video_aw_date_dead", "MediaViewQA_active_video"."network_name" as "MediaViewQA_active_video_network_name", "MediaViewQA_active_video"."video_title" as "MediaViewQA_active_video_video_title" from "MediaViewQA"."active_video" "MediaViewQA_active_video" full outer join "DanyQA"."dph_active_videos_dish" "DanyQA_dph_active_videos_dish" on ("MediaViewQA_active_video"."video_guid" = "DanyQA_dph_active_videos_dish"."video_guid") where "MediaViewQA_active_video"."network_name" in ('FOX') order by "MediaViewQA_active_video_network_name" limit 200001 at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:432) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:219) ... 16 more Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156) ... 1 more Caused by: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:694) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:533) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:529) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257) ... 3 more Caused by: org.teiid.core.TeiidException at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1054) at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:563) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:363) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:297) at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171) at com.sun.proxy.$Proxy177.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:661) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:527) ... 6 more Caused by: java.lang.NullPointerException
Error Message

com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select "DanyQA_dph_active_videos_dish"."network_name" as "DanyQA_dph_active_videos_dish_network_name", "DanyQA_dph_active_videos_dish"."video_title" as "DanyQA_dph_active_videos_dish_video_title", "MediaViewQA_active_video"."aw_date_dead" as "MediaViewQA_active_video_aw_date_dead", "MediaViewQA_active_video"."network_name" as "MediaViewQA_active_video_network_name", "MediaViewQA_active_video"."video_title" as "MediaViewQA_active_video_video_title" from "MediaViewQA"."active_video" "MediaViewQA_active_video" full outer join "DanyQA"."dph_active_videos_dish" "DanyQA_dph_active_videos_dish" on ("MediaViewQA_active_video"."video_guid" = "DanyQA_dph_active_videos_dish"."video_guid") where "MediaViewQA_active_video"."network_name" in ('FOX') order by "MediaViewQA_active_video_network_name" limit 200001
Error Trace

com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select "DanyQA_dph_active_videos_dish"."network_name" as "DanyQA_dph_active_videos_dish_network_name", "DanyQA_dph_active_videos_dish"."video_title" as "DanyQA_dph_active_videos_dish_video_title", "MediaViewQA_active_video"."aw_date_dead" as "MediaViewQA_active_video_aw_date_dead", "MediaViewQA_active_video"."network_name" as "MediaViewQA_active_video_network_name", "MediaViewQA_active_video"."video_title" as "MediaViewQA_active_video_video_title" from "MediaViewQA"."active_video" "MediaViewQA_active_video" full outer join "DanyQA"."dph_active_videos_dish" "DanyQA_dph_active_videos_dish" on ("MediaViewQA_active_video"."video_guid" = "DanyQA_dph_active_videos_dish"."video_guid") where "MediaViewQA_active_video"."network_name" in ('FOX') order by "MediaViewQA_active_video_network_name" limit 200001 at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:432) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:219) at com.jaspersoft.commons.datarator.BaseDataSetCacheImpl.getWorkingDataSet(BaseDataSetCacheImpl.java:273) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:106) at com.jaspersoft.commons.semantic.dsimpl.memory.MemoryDataSet.getWorkingDataSet(MemoryDataSet.java:71) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getWorkingDataSet(CommonDomainDataStrategy.java:1240) at com.jaspersoft.ji.adhoc.strategy.CommonDomainDataStrategy.getRuntimeDataSet(CommonDomainDataStrategy.java:1538) at com.jaspersoft.ji.adhoc.strategy.DomainDataStrategy.getRuntimeDataSet(DomainDataStrategy.java:259) at com.jaspersoft.ji.adhoc.strategy.FlattenedWorkingDataSetStrategy.getRuntimeDataSet(FlattenedWorkingDataSetStrategy.java:86) at com.jaspersoft.ji.adhoc.datasource.AdhocDataSourceService.setReportParameterValues(AdhocDataSourceService.java:141) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl.fillReport(EngineServiceImpl.java:1729) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runWithDataSource(EngineServiceImpl.java:1090) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportFill.runReport(EngineServiceImpl.java:1019) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.EngineServiceImpl$ReportRunnable.run(EngineServiceImpl.java:912) at com.jaspersoft.jasperserver.api.engine.jasperreports.service.impl.Log4jMdcCompatibleThreadPoolExecutor$1.run(Log4jMdcCompatibleThreadPoolExecutor.java:60) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) at java.lang.Thread.run(Thread.java:745) Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156) ... 1 more Caused by: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:694) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:533) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:529) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257) ... 3 more Caused by: org.teiid.core.TeiidException at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1054) at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:563) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:363) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:297) at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171) at com.sun.proxy.$Proxy177.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:661) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:527) ... 6 more Caused by: java.lang.NullPointerException
Error Message

net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null.
Error Trace

net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:267) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156) at java.lang.Thread.run(Thread.java:745) Caused by: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:694) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:533) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:529) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257) ... 3 more Caused by: org.teiid.core.TeiidException at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1054) at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:563) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:363) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:297) at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171) at com.sun.proxy.$Proxy177.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:661) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:527) ... 6 more Caused by: java.lang.NullPointerException
Error Message

org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
Error Trace

org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:694) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:533) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:529) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156) at java.lang.Thread.run(Thread.java:745) Caused by: org.teiid.core.TeiidException at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1054) at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:563) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:363) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:297) at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171) at com.sun.proxy.$Proxy177.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:661) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:527) ... 6 more Caused by: java.lang.NullPointerException
Error Message

org.teiid.core.TeiidException
Error Trace

org.teiid.core.TeiidException at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:196) at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:1054) at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:563) at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:363) at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:265) at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:297) at sun.reflect.GeneratedMethodAccessor806.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:606) at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173) at java.util.concurrent.FutureTask.run(FutureTask.java:262) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:260) at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171) at com.sun.proxy.$Proxy177.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:661) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:527) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:257) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:156) at java.lang.Thread.run(Thread.java:745) Caused by: java.lang.NullPointerException
Error Message

java.lang.NullPointerException
Error Trace

java.lang.NullPointerException