ASSERTION FAILED: expected reference to be not null --------------------------------------------------- Key: TEIID-4431 URL: https://issues.jboss.org/browse/TEIID-4431 Project: Teiid Issue Type: Bug Components: Query Engine Affects Versions: 8.12.x Reporter: Chenna Krishna Assignee: Steven Hawkins We are using TEIID 8.12 driver for Jasper. Getting the below query when tried to trigger the query. Caused by: java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null select "DOX_JB_EAM_FOLDER_SP"."EAM_CODE" as "DOX_JB_EAM_FOLDER_SP_EAM_CODE", "DOX_JB_EAM_FOLDER_SP"."OBJECT_NAME" as "DOX_JB_EAM_FOLDER_SP_OBJECT_NAME", "DT_DOX_JB_EAM_DOC_SP_CA"."R_CREATION_DATE" as "DT_DOX_JB_EAM_DOC_SP_CA_R_CREATION_DATE", "DT_DOX_JB_EAM_DOC_SP_EAM"."R_CREATION_DATE" as "DT_DOX_JB_EAM_DOC_SP_EAM_R_CREATION_DATE", "DT_ODS_AGENT_PROFILES"."AGENT_CODE" as "DT_ODS_AGENT_PROFILES_AGENT_CODE", "DT_ODS_AGENT_PROFILES"."AGENT_NAME" as "DT_ODS_AGENT_PROFILES_AGENT_NAME", "DT_ODS_AGENT_PROFILES"."MODIFICATION_DATE" as "DT_ODS_AGENT_PROFILES_MODIFICATION_DATE", "DT_ODS_AGENT_PROFILES"."OPEN_DATE" as "DT_ODS_AGENT_PROFILES_OPEN_DATE", "DT_ODS_AGENT_PROFILES"."STATUS" as "DT_ODS_AGENT_PROFILES_STATUS" from "DOX_JASPER_DXTR_USER"."JB_EAM_FOLDER_SP_SG" "DOX_JB_EAM_FOLDER_SP" left outer join (SELECT AGENT_CODE, AGENT_NAME, MODIFICATION_DATE, OPEN_DATE, CASE WHEN STATUS = 'A' THEN 'Inactive' WHEN STATUS = '' THEN 'Active' ELSE STATUS END AS STATUS FROM ODS.AGENT_PROFILES WHERE FLG_ACTIVE = 'Y') "DT_ODS_AGENT_PROFILES" on ("DOX_JB_EAM_FOLDER_SP"."EAM_CODE" = "DT_ODS_AGENT_PROFILES"."AGENT_CODE") left outer join (SELECT D.DOC_CODE, D.EAM_CODE, D.OBJECT_NAME, D.R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG D INNER JOIN (SELECT EAM_CODE, DOC_CODE, MAX(R_CREATION_DATE) R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG WHERE DOC_CODE = 'E115' GROUP BY EAM_CODE, DOC_CODE) T ON D.EAM_CODE = T.EAM_CODE AND D.DOC_CODE = T.DOC_CODE AND D.R_CREATION_DATE = T.R_CREATION_DATE) "DT_DOX_JB_EAM_DOC_SP_CA" on ("DOX_JB_EAM_FOLDER_SP"."EAM_CODE" = "DT_DOX_JB_EAM_DOC_SP_CA"."EAM_CODE") left outer join (SELECT D.DOC_CODE, D.EAM_CODE, D.OBJECT_NAME, D.R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG D INNER JOIN (SELECT EAM_CODE, DOC_CODE, MAX(R_CREATION_DATE) R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG WHERE DOC_CODE = 'E109' GROUP BY EAM_CODE, DOC_CODE) T ON D.EAM_CODE = T.EAM_CODE AND D.DOC_CODE = T.DOC_CODE AND D.R_CREATION_DATE = T.R_CREATION_DATE) "DT_DOX_JB_EAM_DOC_SP_EAM" on ("DOX_JB_EAM_FOLDER_SP"."EAM_CODE" = "DT_DOX_JB_EAM_DOC_SP_EAM"."EAM_CODE") order by "DT_ODS_AGENT_PROFILES_AGENT_CODE" limit 200001 Error Log: Caused by: com.jaspersoft.commons.dataset.DataSetException: Exception calling JRDataSource.next() for query select "DOX_JB_EAM_FOLDER_SP"."EAM_CODE" as "DOX_JB_EAM_FOLDER_SP_EAM_CODE", "DOX_JB_EAM_FOLDER_SP"."OBJECT_NAME" as "DOX_JB_EAM_FOLDER_SP_OBJECT_NAME", "DT_DOX_JB_EAM_DOC_SP_CA"."R_CREATION_DATE" as "DT_DOX_JB_EAM_DOC_SP_CA_R_CREATION_DATE", "DT_DOX_JB_EAM_DOC_SP_EAM"."R_CREATION_DATE" as "DT_DOX_JB_EAM_DOC_SP_EAM_R_CREATION_DATE", "DT_ODS_AGENT_PROFILES"."AGENT_CODE" as "DT_ODS_AGENT_PROFILES_AGENT_CODE", "DT_ODS_AGENT_PROFILES"."AGENT_NAME" as "DT_ODS_AGENT_PROFILES_AGENT_NAME", "DT_ODS_AGENT_PROFILES"."MODIFICATION_DATE" as "DT_ODS_AGENT_PROFILES_MODIFICATION_DATE", "DT_ODS_AGENT_PROFILES"."OPEN_DATE" as "DT_ODS_AGENT_PROFILES_OPEN_DATE", "DT_ODS_AGENT_PROFILES"."STATUS" as "DT_ODS_AGENT_PROFILES_STATUS" from "DOX_JASPER_DXTR_USER"."JB_EAM_FOLDER_SP_SG" "DOX_JB_EAM_FOLDER_SP" left outer join (SELECT AGENT_CODE, AGENT_NAME, MODIFICATION_DATE, OPEN_DATE, CASE WHEN STATUS = 'A' THEN 'Inactive' WHEN STATUS = '' THEN 'Active' ELSE STATUS END AS STATUS FROM ODS.AGENT_PROFILES WHERE FLG_ACTIVE = 'Y') "DT_ODS_AGENT_PROFILES" on ("DOX_JB_EAM_FOLDER_SP"."EAM_CODE" = "DT_ODS_AGENT_PROFILES"."AGENT_CODE") left outer join (SELECT D.DOC_CODE, D.EAM_CODE, D.OBJECT_NAME, D.R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG D INNER JOIN (SELECT EAM_CODE, DOC_CODE, MAX(R_CREATION_DATE) R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG WHERE DOC_CODE = 'E115' GROUP BY EAM_CODE, DOC_CODE) T ON D.EAM_CODE = T.EAM_CODE AND D.DOC_CODE = T.DOC_CODE AND D.R_CREATION_DATE = T.R_CREATION_DATE) "DT_DOX_JB_EAM_DOC_SP_CA" on ("DOX_JB_EAM_FOLDER_SP"."EAM_CODE" = "DT_DOX_JB_EAM_DOC_SP_CA"."EAM_CODE") left outer join (SELECT D.DOC_CODE, D.EAM_CODE, D.OBJECT_NAME, D.R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG D INNER JOIN (SELECT EAM_CODE, DOC_CODE, MAX(R_CREATION_DATE) R_CREATION_DATE FROM DOX_JASPER_DXTR_USER.JB_EAM_DOC_SP_SG WHERE DOC_CODE = 'E109' GROUP BY EAM_CODE, DOC_CODE) T ON D.EAM_CODE = T.EAM_CODE AND D.DOC_CODE = T.DOC_CODE AND D.R_CREATION_DATE = T.R_CREATION_DATE) "DT_DOX_JB_EAM_DOC_SP_EAM" on ("DOX_JB_EAM_FOLDER_SP"."EAM_CODE" = "DT_DOX_JB_EAM_DOC_SP_EAM"."EAM_CODE") order by "DT_ODS_AGENT_PROFILES_AGENT_CODE" limit 200001 at com.jaspersoft.commons.semantic.dsimpl.JRQueryDataSet$JRDataSetIterator.next(JRQueryDataSet.java:456) at com.jaspersoft.commons.datarator.CachedData.fetchData(CachedData.java:217) ... 138 more Caused by: net.sf.jasperreports.engine.JRException: Error executing SQL statement for: null. at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:344) at com.jaspersoft.jasperserver.api.engine.jasperreports.util.JRTimezoneJdbcQueryExecuter.createDatasource(JRTimezoneJdbcQueryExecuter.java:169) at com.jaspersoft.commons.util.JSControlledJdbcQueryExecuter.run(JSControlledJdbcQueryExecuter.java:157) ... 1 more Caused by: org.teiid.jdbc.TeiidSQLException: ASSERTION FAILED: expected reference to be not null 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:703) at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:64) at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:542) at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:148) at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:538) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:260) at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) at net.sf.jasperreports.engine.query.JRJdbcQueryExecuter.createDatasource(JRJdbcQueryExecuter.java:310) ... 3 more Regards, Chenna