Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select sum(CASE WHEN ("DB2_public_employee"."hire_date" = "DB2_public_employee"."end_date")
IS NULL THEN 0 ELSE 1 END) as "DB2_public_employee_DateBool_Count"
from "DB2_public"."employee" "DB2_public_employee"

        at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:300)
        at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:129)
        ... 101 more
Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for : null
        at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:240)
        at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:168)
        at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.createDatasource(JSControlledJdbcQueryExecuter.java:113)
        at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet.getJRDataSource(JRQueryDataSet.java:174)
        at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet.access$100(JRQueryDataSet.java:44)
        at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:291)
        ... 102 more
Caused by: org.teiid.jdbc.TeiidSQLException: TEIID30504 -1965912888: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT SUM(CASE WHEN g_0."hire_date" = g_0."end_dat
e" IS NULL THEN 0 ELSE 1 END) FROM "public"."employee" AS g_0]
        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)
        at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)
        at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:656)
        at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)
        at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:512)
        at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)
        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:508)
        at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:211)
        at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:233)
        ... 107 more
Caused by: org.teiid.core.TeiidProcessingException: TEIID30504 -1965912888: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT SUM(CASE WHEN g_0."hire_date" = g_0."
end_date" IS NULL THEN 0 ELSE 1 END) FROM "public"."employee" AS g_0]
        at org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:534)
        at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:321)
        at org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:279)
        at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:279)
        at org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:149)
        at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:143)
        at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:109)
        at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:153)
        at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:382)
        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:291)
        at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
        at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:219)
        at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:386)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:131)
        at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303)
        at java.util.concurrent.FutureTask.run(FutureTask.java:138)
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:250)
        at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:234)
        at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:129)
        at $Proxy130.executeRequest(Unknown Source)
        at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)
        at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:506)
        ... 109 more
Caused by: org.teiid.translator.jdbc.JDBCExecutionException: 0 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT SUM(CASE WHEN g_0."hire_date" = g_0."end_date" IS NU
LL THEN 0 ELSE 1 END) FROM "public"."employee" AS g_0]
        at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:88)
        at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:255)
        at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:457)
        at org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:302)
        ... 133 more
Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: timestamp without time zone = boolean
  Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
  Position: 38
        at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2102)
        at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1835)
        at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:257)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:500)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:388)
        at org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:273)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
        at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:84)
        ... 136 more