[teiid-issues] [JBoss JIRA] (TEIID-5636) Planning error. Could not find symbol disiz__1.DischargeTime

[Steven Hawkins (Jira)]

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

Steven Hawkins commented on TEIID-5636:
---------------------------------------

> I unfortunitaly have no smaller example. We use this table all the time without any previous errors.

It shouldn't be related to the individual table.  Are you able to provide the entire query structure?

Are you able to reproduce this on a later version, such as 11.2.1?

> Planning error. Could not find symbol disiz__1.DischargeTime
> ------------------------------------------------------------
>
>                 Key: TEIID-5636
>                 URL: https://issues.jboss.org/browse/TEIID-5636
>             Project: Teiid
>          Issue Type: Bug
>    Affects Versions: 10.3.4
>            Reporter: Bram Gadeyne
>            Assignee: Steven Hawkins
>            Priority: Critical
>
> Hi,
> We're running into this exception. It happens when adding "LEFT OUTER JOIN izisprod.P_DischargeData". I unfortunitaly have no smaller example. We use this table all the time without any previous errors.
> 2019-01-31 15:32:36,438 ERROR [org.teiid.PROCESSOR] (Worker172_QueryProcessorQueue57002) JesgvCmnKfP5 TEIID30019 Unexpected exception for request JesgvCmnKfP5.187: org.teiid.core.TeiidRuntimeException: Planning error. Could not find symbol: disiz__1.DischargeTime
>         at org.teiid.query.processor.relational.RelationalNode.getProjectionIndexes(RelationalNode.java:363)
>         at org.teiid.query.processor.relational.JoinNode.initialize(JoinNode.java:129)
>         at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:92)
>         at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:98)
>         at org.teiid.query.processor.relational.RelationalPlan.connectExternal(RelationalPlan.java:98)
>         at org.teiid.query.processor.relational.RelationalPlan.initialize(RelationalPlan.java:87)
>         at org.teiid.query.processor.QueryProcessor.init(QueryProcessor.java:223)
>         at org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:135)
>         at org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)
>         at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)
>         at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)
>         at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:480)
>         at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350)
>         at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)
>         at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)
>         at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:277)
>         at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)
>         at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)
>         at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
>         at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
>         at java.lang.Thread.run(Thread.java:748)



--
This message was sent by Atlassian Jira
(v7.12.1#712002)