ERROR [org.teiid.PROCESSOR] (Worker3_QueryProcessorQueue1969) GRr4LpJgSV/2 TEIID30019 Unexpected exception for request GRr4LpJgSV/2.1: org.teiid.core.TeiidRuntimeException: Planning error. Could not find symbol: PRDTCLASSPYS."_CODEPAYS" 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:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) ------------------------------------------- SELECT "PRODUIT"."_ISIN" AS "PRODUIT__ISIN", "PRODUIT"."_CODEDUTYPE" AS "PRODUIT__CODEDUTYPE", "PRODUIT"."_DEVISEACTIF" AS "PRODUIT__DEVISEACTIF", "PRODUIT"."_CODEEXTERNE10" AS "PRODUIT__CODEEXTERNE10", "PRDTCLASSPYS"."_CODEPAYS" AS "PRDTCLASSPYS__CODEPAYS", "PRDTCLASSPYS"."_CODESOUSSECTEUR" AS "PRDTCLASSPYS__CODESOUSSECTEU", "PRDTCLASSPYS"."_CLASSIFICATION" AS "PRDTCLASSPYS__CLASSIFICATION", "BAAKREP"."AKBDTX" AS "BAAKREP_AKBDTX", "BAAKREP"."AKBBTX" AS "BAAKREP_AKBBTX" FROM "OmegaModel_PlZX"."Omega"."Com"."PRODUIT" "PRODUIT" LEFT JOIN (SELECT "__LATEST_sub_t"."BaseCode" AS "__LATEST_RATE", "__LATEST_sub_t"."CloseRate" AS "__LATEST_RATE1" FROM "BInvModel_fFHk"."Omega"."dbo"."__LATEST_RATE" "__LATEST_sub_t" WHERE (("__LATEST_sub_t"."QuoteCode" = 'USD'))) "__LATEST_R_Sub" ON ("PRODUIT"."_DEVISEACTIF" = "__LATEST_R_Sub"."__LATEST_RATE") LEFT JOIN (SELECT "_SECU_HISTORY_sub_t"."CloseRate" AS "_SECU_HISTORY_CloseRa", "_SECU_HISTORY_sub_t"."VolatilityBefCutoff" AS "_SECU_HISTORY_Volatil", "_SECU_HISTORY_sub_t"."VolatilityAfterCutoff" AS "_SECU_HISTORY_Volatil1", "_SECU_HISTORY_sub_t"."Volatility200Days" AS "_SECU_HISTORY_Volatil2", "_SECU_HISTORY1_SUB"."ProductCode" AS "_SECU_HISTORY_Product", MAX("_SECU_HISTORY1_SUB"."Date") AS "_SECU_HISTORY_Date" FROM "BInvModel_fFHk"."Omega"."dbo"."_SECU_HISTORY" "_SECU_HISTORY_sub_t" LEFT JOIN "BInvModel_fFHk"."Omega"."dbo"."_SECU_HISTORY" "_SECU_HISTORY1_SUB" ON ("_SECU_HISTORY_sub_t"."ProductCode" = "_SECU_HISTORY1_SUB"."ProductCode") GROUP BY "_SECU_HISTORY_sub_t"."Date", "_SECU_HISTORY_sub_t"."CloseRate", "_SECU_HISTORY_sub_t"."VolatilityBefCutoff", "_SECU_HISTORY_sub_t"."VolatilityAfterCutoff", "_SECU_HISTORY_sub_t"."Volatility200Days", "_SECU_HISTORY1_SUB"."ProductCode" HAVING("_SECU_HISTORY_sub_t"."Date" = MAX("_SECU_HISTORY1_SUB"."Date"))) "_SECU_HISTORYEkqxr_Sub" ON ("PRODUIT"."_CODEPRODUI" = "_SECU_HISTORYEkqxr_Sub"."_SECU_HISTORY_Product") LEFT JOIN "OmegaModel_PlZX"."Omega"."Com"."PRDTCLASSPYS" "PRDTCLASSPYS" ON ("PRODUIT"."_CODEPRODUI" = "PRDTCLASSPYS"."_CODEPRODUI") LEFT JOIN "SAMPLEModel_B8z7"."DB2ADMIN"."BAAKREP" "BAAKREP" ON ((TRIM("PRDTCLASSPYS"."_CODEPAYS") = TRIM("BAAKREP"."AKAICD"))) LEFT JOIN "OmegaModel_PlZX"."Omega"."Com"."PERIODI" "PERIODIRateType" ON ("PRODUIT"."_PERIODICITE" = "PERIODIRateType"."_CODE") LIMIT 0, 10 -------------------------------------------------- 1 PRODUIT__ISIN (string) PRODUIT__CODEDUTYPE (string) PRODUIT__DEVISEACTIF (string) PRODUIT__CODEEXTERNE10 (string) PRDTCLASSPYS__CODEPAYS (string) PRDTCLASSPYS__CODESOUSSECTEU (string) PRDTCLASSPYS__CLASSIFICATION (integer) BAAKREP_AKBDTX (string) BAAKREP_AKBBTX (string) Node Output Rows: 0 Node Next Batch Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Cumulative Process Time: 0 Node Next Batch Calls: 0 Node Blocks: 0 Estimated Node Cardinality: 10.0 2 _ISIN (string) _CODEDUTYPE (string) _DEVISEACTIF (string) _CODEEXTERNE10 (string) _CODEPAYS (string) _CODESOUSSECTEUR (string) _CLASSIFICATION (integer) AKBDTX (string) AKBBTX (string) Node Output Rows: 0 Node Next Batch Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Cumulative Process Time: 0 Node Next Batch Calls: 0 Node Blocks: 0 Estimated Node Cardinality: 10.0 3 _ISIN (string) _CODEDUTYPE (string) _DEVISEACTIF (string) _CODEEXTERNE10 (string) _CODEPAYS (string) _CODESOUSSECTEUR (string) _CLASSIFICATION (integer) AKBDTX (string) AKBBTX (string) Node Output Rows: 0 Node Next Batch Process Time: 0 Node Cumulative Next Batch Process Time: 0 Node Cumulative Process Time: 0 Node Next Batch Calls: 0 Node Blocks: 0 Estimated Node Cardinality: -1.0 4 _ISIN (string) _CODEDUTYPE (string) _DEVISEACTIF (string) _CODEEXTERNE10 (string) Estimated Node Cardinality: NaN 5 _ISIN (string) _CODEDUTYPE (string) _DEVISEACTIF (string) _CODEEXTERNE10 (string) Estimated Node Cardinality: NaN 6 _CODEPRODUI (string) _ISIN (string) _CODEDUTYPE (string) _DEVISEACTIF (string) _CODEEXTERNE10 (string) Estimated Node Cardinality: NaN 7 _CODEPRODUI (string) _ISIN (string) _CODEDUTYPE (string) _DEVISEACTIF (string) _CODEEXTERNE10 (string) Estimated Node Cardinality: NaN 8 _DEVISEACTIF (string) _CODEPRODUI (string) _ISIN (string) _CODEDUTYPE (string) _CODEEXTERNE10 (string) Estimated Node Cardinality: 0.0 SELECT g_0."_DEVISEACTIF" AS c_0, g_0."_CODEPRODUI" AS c_1, g_0."_ISIN" AS c_2, g_0."_CODEDUTYPE" AS c_3, g_0."_CODEEXTERNE10" AS c_4 FROM (OmegaModel_PlZX.Omega.Com.PRODUIT AS g_0 LEFT OUTER JOIN OmegaModel_PlZX.Omega.Com.PRDTCLASSPYS AS g_1 ON g_0."_CODEPRODUI" = g_1."_CODEPRODUI") LEFT OUTER JOIN OmegaModel_PlZX.Omega.Com.PERIODI AS g_2 ON g_0."_PERIODICITE" = g_2."_CODE" LIMIT 10 OmegaModel_PlZX 9 BaseCode (string) Estimated Node Cardinality: NaN SELECT g_0.BaseCode FROM BInvModel_fFHk.Omega.dbo.__LATEST_RATE AS g_0 WHERE g_0.QuoteCode = 'USD' BInvModel_fFHk ENHANCED SORT JOIN (SORT/SORT) LEFT OUTER JOIN PRODUIT."_DEVISEACTIF"=__LATEST_sub_t.BaseCode null 10 10 _SECU_HISTORY_Product (string) Estimated Node Cardinality: 1.0 SELECT g_1.ProductCode FROM BInvModel_fFHk.Omega.dbo._SECU_HISTORY AS g_0, BInvModel_fFHk.Omega.dbo._SECU_HISTORY AS g_1 WHERE g_0.ProductCode = g_1.ProductCode GROUP BY g_0."Date", g_0.CloseRate, g_0.VolatilityBefCutoff, g_0.VolatilityAfterCutoff, g_0.Volatility200Days, g_1.ProductCode HAVING g_0."Date" = MAX(g_1."Date") BInvModel_fFHk ENHANCED SORT JOIN (SORT/SORT) LEFT OUTER JOIN PRODUIT."_CODEPRODUI"=_SECU_HISTORYEkqxr_Sub._SECU_HISTORY_Product null 10 11 AKAICD (string) AKBDTX (string) AKBBTX (string) Estimated Node Cardinality: -1.0 SELECT g_0.AKAICD, g_0.AKBDTX, g_0.AKBBTX FROM SAMPLEModel_B8z7.DB2ADMIN.BAAKREP AS g_0 SAMPLEModel_B8z7 NESTED LOOP JOIN LEFT OUTER JOIN rtrim(ltrim(PRDTCLASSPYS."_CODEPAYS")) = rtrim(ltrim(BAAKREP.AKAICD)) null 10 PRODUIT."_ISIN" AS PRODUIT__ISIN PRODUIT."_CODEDUTYPE" AS PRODUIT__CODEDUTYPE PRODUIT."_DEVISEACTIF" AS PRODUIT__DEVISEACTIF PRODUIT."_CODEEXTERNE10" AS PRODUIT__CODEEXTERNE10 PRDTCLASSPYS."_CODEPAYS" AS PRDTCLASSPYS__CODEPAYS PRDTCLASSPYS."_CODESOUSSECTEUR" AS PRDTCLASSPYS__CODESOUSSECTEU PRDTCLASSPYS."_CLASSIFICATION" AS PRDTCLASSPYS__CLASSIFICATION BAAKREP.AKBDTX AS BAAKREP_AKBDTX BAAKREP.AKBBTX AS BAAKREP_AKBBTX 0 7