Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-5636

Planning error. Could not find symbol disiz__1.DischargeTime

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Critical
    • 12.0.1, 12.1, 11.2.3
    • 10.3.4
    • Query Engine
    • None

    Description

      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)

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            gadeynebram Bram Gadeyne (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: