SQL:

select count("FoodmartDataSource_public_department"."department_description") as "FoodmartDa
taSource_public_department_department_description_Count",
count("FoodmartDataSourceJNDI_public_employee"."education_level") as "FoodmartDataSourceJNDI_public_employee_education_level_Count"
from "FoodmartDataSourceJNDI_public"."employee" "FoodmartDataSourceJNDI_public_employee"
inner join "FoodmartDataSource_public"."department" "FoodmartDataSource_public_department" on ("FoodmartDataSourceJNDI_public_employee"."department_id" = "FoodmartDataSource_public_department"."depart
ment_id")

        at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:300)


Caused by: org.teiid.jdbc.TeiidSQLException: org.teiid.core.TeiidException
        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.TeiidException
        at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172)
        at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:787)
        at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:483)
        at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:318)
        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: java.lang.NullPointerException
        at org.teiid.query.processor.relational.GroupingNode.initialize(GroupingNode.java:185)
        at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:108)
        at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:113)
        at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:103)
        at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:194)
        at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:130)
        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)
        ... 125 more