[teiid-issues] [JBoss JIRA] (TEIID-4325) ASSERTION FAILED: expected reference to be not null

[Tom Chen (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4325?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13348275#comment-13348275 ] 

Tom Chen commented on TEIID-4325:
---------------------------------

Thank you for the clarification. I will discuss this issue with our developers to see how to proceed. We planed to use teiid 9.1 in our next product release but our user cannot wait until then. Have a good weekend!

> ASSERTION FAILED: expected reference to be not null
> ---------------------------------------------------
>
>                 Key: TEIID-4325
>                 URL: https://issues.jboss.org/browse/TEIID-4325
>             Project: Teiid
>          Issue Type: Bug
>          Components: Query Engine
>    Affects Versions: 8.12
>            Reporter: Mark Tawk
>            Assignee: Steven Hawkins
>             Fix For: 9.1, 9.0.2, 8.13.7, 8.12.6.6_3
>
>         Attachments: show_plan_debug.txt
>
>
> I'm using teiid 9.0.0 over h2 :
>  
> I'm getting ASSERTION_FAILED over the following query and can not find what is causing this exception:
>  
> select "Sheet1"."AvgAmoutRange" as "Sheet1_EBt_211215_AvgAmoutRa1",COUNT( distinct IFNULL("CEGlobalView"."Customer_CustomerID",-2147483648)) as "CEGlobalView_Customer_Custom2","CEGlobalView"."Customer_GenderID" as "CEGlobalView_Customer_Gender1","Gender"."Gender" as "Gender_Gender","Sheet1"."Sheet1_EBt_211215ID" as "Sheet1_EBt_211215_Sheet1_EBt11" from  "CEBanksBusinessModel"."CEGlobalView" "CEGlobalView" LEFT JOIN "h2dbimplify_data_cebankModel_ST"."implify_data_cebank"."Sheet1_EBt_211215" "Sheet1" ON   ( ("CEGlobalView"."StreamCardsvt3r_StreamCards_1" BETWEEN  "Sheet1"."Min" and "Sheet1"."Max") )
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."Gender" "Gender" ON "CEGlobalView"."Customer_GenderID" = "Gender"."GenderID"
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."CustomerTag" "CustomerTag" ON "CEGlobalView"."Customer_CustomerID" = "CustomerTag"."Customer_CustomerID" AND ( ( ("CustomerTag"."EndDateTime" >  CURDATE()) OR ( ("CustomerTag"."EndDateTime" IS  null ) ) ) )
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagValue" "TagValue" ON "CustomerTag"."TagValue_TagValueID" = "TagValue"."TagValueID"
> LEFT JOIN "h2dbimplify_data_cebankModel_fR"."implify_data_cebank"."TagName" "TagName" ON "TagValue"."TagName_TagNameID" = "TagName"."TagNameID" AND ( ( ("TagName"."TagType_TagTypeID" IN  (1.0) ) ) AND ( ("TagName"."TagScope_TagScopeID" IN  (1.0) ) ) )
> where  ( ( ( ("TagName"."TagName" IN  ('Behavior') ) ) ) AND ( ("Sheet1"."AvgAmoutRange" IS NOT  null ) ) AND ( ("CEGlobalView"."Customer_GenderID" IS NOT  null ) ) AND ( ("Gender"."Gender" IS NOT  null ) ) )  group by "Sheet1"."AvgAmoutRange","CEGlobalView"."Customer_GenderID","Gender"."Gender","Sheet1"."Sheet1_EBt_211215ID" order by "Sheet1"."Sheet1_EBt_211215ID" ASC,"Sheet1"."AvgAmoutRange" ASC,"Gender"."Gender" DESC,"CEGlobalView"."Customer_GenderID" DESC
>  
> The exception stack:
>  
> ERROR TEIID_DQP_LOGGER:90 (http-bio-8080-exec-14) -  - [TEIID30019 Unexpected exception for request rBDBCRYcUyyM.0]
> java.lang.AssertionError: ASSERTION FAILED: expected reference to be not null
>   at org.teiid.core.util.Assertion.failed(Assertion.java:73)
>   at org.teiid.core.util.Assertion.isNotNull(Assertion.java:100)
>   at org.teiid.core.util.Assertion.isNotNull(Assertion.java:92)
>   at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:367)
>   at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:133)
>   at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:96)
>   at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
>   at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
>   at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:102)
>   at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:91)
>   at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:226)
>   at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:138)
>   at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:114)
>   at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:164)
>   at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146)
>   at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472)
>   at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348)
>   at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)
>   at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274)
>   at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:313)
>   at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:245)
>   at sun.reflect.GeneratedMethodAccessor423.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:177)
>   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:175)
>   at com.sun.proxy.$Proxy34.executeRequest(Unknown Source)
>   at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:673)
>   at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:539)
>   at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:1060)
>   at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:323)
> you find attached the show plan debug



--
This message was sent by Atlassian JIRA
(v7.2.3#72005)