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

PrestoDB translator - no value available

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Duplicate
    • Icon: Major Major
    • None
    • 8.12.8.6_3
    • None
    • None

      Evaluation of query [1] ends up with exception produced by Teiid [2].

      [1]
      SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
      
      [2]
      Unable to find source-code formatter for language: plain. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      15:56:58,754 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue69) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.19: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
      	at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
      
      Log
      Unable to find source-code formatter for language: plain. Available languages are: actionscript, ada, applescript, bash, c, c#, c++, cpp, css, erlang, go, groovy, haskell, html, java, javascript, js, json, lua, none, nyan, objc, perl, php, python, r, rainbow, ruby, scala, sh, sql, swift, visualbasic, xml, yaml
      15:58:51,125 DEBUG [org.teiid.TRANSPORT] (New I/O worker #2) processing message:MessageHolder: key=400 contents=Invoke interface org.teiid.client.DQP.executeRequest
      15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 with state NEW
      15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Command has no cache hint and result set cache mode is not on.
      15:58:51,126 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 executing  SELECT INTKEY, CHARVALUE FROM BQT1.SMALLA AS A WHERE CHARVALUE <= (SELECT MAX(CHARVALUE) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY
      15:58:51,132 DEBUG [org.teiid.PLANNER] (Worker16_QueryProcessorQueue70) [LOW [Relational Planner] Non-literal comparison not supported by source. Source - SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey) was not pushed, LOW [Relational Planner] Conditions met (hint or cost) - Converting to a semi merge join Select(groups=[Source.SmallA AS SmallA__1], props={SELECT_CRITERIA=SmallA__1.CharValue <= (SELECT MAX(B.CharValue) FROM BQT1.SmallA AS B WHERE B.IntKey = A.IntKey), OUTPUT_COLS=[SmallA__1.IntKey, SmallA__1.CharValue], EST_CARDINALITY=16.666666, EST_COL_STATS={SmallA__1.IntKey=[-1.0, -1.0], SmallA__1.CharValue=[-1.0, -1.0]}}]
      15:58:51,133 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) ProcessTree for DEf6D1zaxo6u.20 SortNode(4) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SORT] [SmallA__1.IntKey]
        ProjectNode(5) output=[SmallA__1.IntKey, SmallA__1.CharValue] [SmallA__1.IntKey, SmallA__1.CharValue]
          JoinNode(6) [MERGE JOIN (ALREADY_SORTED/ALREADY_SORTED)] [SEMI JOIN] criteria=[SmallA__1.IntKey=B.IntKey, SmallA__1.CharValue <= MAX(B.CharValue)] output=[SmallA__1.IntKey, SmallA__1.CharValue]
            AccessNode(7) output=[SmallA__1.CharValue, SmallA__1.IntKey] SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
            PlanExecutionNode(8) output=[MAX(B.CharValue), B.IntKey] 
      
      15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) before getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@65d4dce6(DEf6D1zaxo6u)
      15:58:51,133 DEBUG [org.teiid.TXN_LOG] (Worker16_QueryProcessorQueue70) after getOrCreateTransactionContext : DEf6D1zaxo6u NONE ID:NONE
      15:58:51,134 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 30 [A.IntKey, A.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type FINAL
      15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Create State
      15:58:51,134 DEBUG [org.teiid.PROCESSOR] (Worker15_QueryProcessorQueue71) Running task for parent thread Worker16_QueryProcessorQueue70
      15:58:51,134 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Create State
      15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing NEW request: SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
      15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker17_QueryProcessorQueue72) Running task for parent thread Worker16_QueryProcessorQueue70
      15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 31 [SmallA__1.IntKey, SmallA__1.CharValue] [class java.lang.Integer, class java.lang.Character] batch size 2048 of type PROCESSOR
      15:58:51,135 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Created intermediate sort buffer 31
      15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained execution
      15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing NEW request: SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
      15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.7.22 Blocking on source query DEf6D1zaxo6u.20.7.22
      15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
      15:58:51,135 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) Creating TupleBuffer: 32 [MAX(B.CharValue), B.IntKey] [class java.lang.Character, class java.lang.Integer] batch size 2048 of type PROCESSOR
      15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20.3.23 Blocking on source query DEf6D1zaxo6u.20.3.23
      15:58:51,135 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained execution
      15:58:51,136 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue70) DEf6D1zaxo6u.20 Blocking on source request(s).
      15:58:51,136 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue70) Request Thread DEf6D1zaxo6u.20 - processor blocked
      15:58:51,136 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) Source-specific command: SELECT MAX(g_0.charvalue) AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 GROUP BY g_0.intkey ORDER BY c_1
      15:58:51,138 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) Source-specific command: SELECT g_0.charvalue AS c_0, g_0.intkey AS c_1 FROM smalla AS g_0 ORDER BY c_1
      15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Executed command
      15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Executed command
      15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Processing MORE request
      15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Processing MORE request
      15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Getting results from connector
      15:58:51,634 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Getting results from connector
      15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker15_QueryProcessorQueue71) DEf6D1zaxo6u.20.7.22 Obtained last batch, total row count: 50
      15:58:51,796 DEBUG [org.teiid.CONNECTOR] (Worker17_QueryProcessorQueue72) DEf6D1zaxo6u.20.3.23 Obtained last batch, total row count: 50
      15:58:51,796 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Request Thread DEf6D1zaxo6u.20 with state PROCESSING
      15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Remove State
      15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Processing Close : SELECT g_0.CharValue AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 ORDER BY c_1
      15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed execution
      15:58:51,797 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.7.22 Closed connection
      15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Remove State
      15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Processing Close : SELECT MAX(g_0.CharValue) AS c_0, g_0.IntKey AS c_1 FROM Source.SmallA AS g_0 GROUP BY g_0.IntKey ORDER BY c_1
      15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed execution
      15:58:51,798 DEBUG [org.teiid.CONNECTOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20.3.23 Closed connection
      15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 31
      15:58:51,799 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) QueryProcessor: closing processor
      15:58:51,799 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 32
      15:58:51,800 ERROR [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) TEIID30019 Unexpected exception for request DEf6D1zaxo6u.20: org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available
      	at org.teiid.query.util.CommandContext.getFromContext(CommandContext.java:506) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.internalEvaluate(Evaluator.java:718) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:693) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:362) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.internalEvaluateTVL(Evaluator.java:237) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.evaluateTVL(Evaluator.java:226) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.eval.Evaluator.evaluate(Evaluator.java:220) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.JoinNode.matchesCriteria(JoinNode.java:353) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.MergeJoinStrategy.process(MergeJoinStrategy.java:248) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.JoinNode.nextBatchDirect(JoinNode.java:227) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.ProjectNode.nextBatchDirect(ProjectNode.java:150) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:282) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.BatchIterator.finalRow(BatchIterator.java:69) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.common.buffer.AbstractTupleSource.getCurrentTuple(AbstractTupleSource.java:70) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.BatchIterator.getCurrentTuple(BatchIterator.java:84) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.common.buffer.AbstractTupleSource.nextTuple(AbstractTupleSource.java:48) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.SortUtility.initialSort(SortUtility.java:262) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.SortUtility.sort(SortUtility.java:196) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.SortNode.sortPhase(SortNode.java:112) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.SortNode.getBufferDirect(SortNode.java:206) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.RelationalNode.getBuffer(RelationalNode.java:634) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.relational.RelationalPlan.getBuffer(RelationalPlan.java:285) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.QueryProcessor.getBuffer(QueryProcessor.java:290) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:154) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:146) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:472) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:348) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:274) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:276) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.12.5.redhat-8.jar:8.12.5.redhat-8]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) [rt.jar:1.8.0_92]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) [rt.jar:1.8.0_92]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_92]
      
      15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) Removing tuplesource for the request DEf6D1zaxo6u.20
      15:58:51,802 DEBUG [org.teiid.BUFFER_MGR] (Worker16_QueryProcessorQueue73) Removing TupleBuffer: 30
      15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) DEf6D1zaxo6u.20 Finished Processing
      15:58:51,802 DEBUG [org.teiid.PROCESSOR] (Worker16_QueryProcessorQueue73) org.teiid.core.TeiidComponentException: TEIID30328 Unable to evaluate MAX(B.CharValue): No value was available Sending error to client DEf6D1zaxo6u.20
      15:58:51,802 DEBUG [org.teiid.TRANSPORT] (Worker16_QueryProcessorQueue73) send message: MessageHolder: key=400 contents=ResultsMessage rowCount=0 finalRow=-1
      15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=401 contents=Invoke interface org.teiid.client.security.ILogon.ping
      15:58:52,435 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=401 contents=null
      15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) processing message:MessageHolder: key=402 contents=Invoke interface org.teiid.client.security.ILogon.ping
      15:58:52,436 DEBUG [org.teiid.SECURITY] (New I/O worker #3) Keep-alive ping received for session: DEf6D1zaxo6u
      15:58:52,436 DEBUG [org.teiid.TRANSPORT] (New I/O worker #3) send message: MessageHolder: key=402 contents=null
      

            rhn-engineering-shawkins Steven Hawkins
            jdurani Juraj DurĂ¡ni (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: