11:20 a.m.
[
https://issues.jboss.org/browse/TEIID-5636?page=com.atlassian.jira.plugin...
]
Steven Hawkins commented on TEIID-5636:
---------------------------------------
The issue is with RulePlanOuterJoins.planLeftOuterJoinAssociativityBeforePlanning. A
workaround is to use the preserve hint:
{code}
SELECT "BAAQREP"."AQANCD" AS "BAAQREP_AQBUTX"
FROM /*+ preserve */
("SAMPLEModel_fb4V"."DB2ADMIN"."BAAFREP"
"BAAFREP"
LEFT JOIN
"BInvModel_4eGO"."Omega"."dbo"."ClientTypeL_cpF_240119"
"ClientTypeL_cpF_240119"
ON ("BAAFREP"."AFAJST" =
"ClientTypeL_cpF_240119"."ClientTypeIndicator")
LEFT JOIN "SAMPLEModel_fb4V"."DB2ADMIN"."BAAGREP"
"BAAGREP"
ON ("BAAFREP"."AFAINB" = "BAAGREP"."AGAINB")
LEFT JOIN "SAMPLEModel_fb4V"."DB2ADMIN"."BAAIREP"
"BAAIREP"
ON ("BAAGREP"."AGAVNB" = "BAAIREP"."AIAVNB")
LEFT JOIN "SAMPLEModel_fb4V"."DB2ADMIN"."BAAOREP"
"BAAOREP"
ON ("BAAIREP"."AIAKCD" = "BAAOREP"."AOAKCD")
) LEFT JOIN "SAMPLEModel_fb4V"."DB2ADMIN"."BAAQREP"
"BAAQREP"
ON ("BAAIREP"."AIANCD" = "BAAQREP"."AQANCD")
LEFT JOIN "SAMPLEModel_fb4V"."DB2ADMIN"."BAAPREP"
"BAAPREP"
ON ("BAAIREP"."AIALCD" = "BAAPREP"."APALCD")
LEFT JOIN
"BInvModel_4eGO"."Omega"."dbo"."Identificat_joa_170119"
"Identificat_joa_170119"
ON ("BAAIREP"."AIAKST" =
"Identificat_joa_170119"."RNMIdenTypeValue")
LEFT JOIN
"OmegaModel_qgWs"."Omega"."Cpte"."CPARTFCP"
"CPARTFCP"
ON (("BAAFREP"."AFAINB" =
Convert("CPARTFCP"."_COMPTE", FLOAT)))
LIMIT 0, 10
{code}
I'll provide a fix today.
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
Attachments: planning_error.txt
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)