TEIID_DQP_LOGGER:92 (http-nio-8081-exec-10) -  - [TEIID30019 Unexpected exception for request 92mYgFdwS+hB.0] - implify@implify.it
org.teiid.core.TeiidRuntimeException: Planning error. Could not find symbol: OPERAT."_NUMEROINT"
	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.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.DQPCore.executeRequest(DQPCore.java:340)
	at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:255)
	at sun.reflect.GeneratedMethodAccessor84.invoke(Unknown Source)
	
	
----------------------------
SELECT "OPERAT"."_NUMEROINT" AS "OPERAT__NUMEROINT"
  FROM "OmegaModel_qgWs"."Omega"."Cpte"."ORDRES" "ORDRES"
  LEFT JOIN "OmegaModel_OKi7"."Omega"."Com"."FIXORDERTYPE" "FIXORDERTYPE"
    ON "ORDRES"."_PRICETYPORDRE" = "FIXORDERTYPE"."_CODE"
  LEFT JOIN "OmegaModel_OKi7"."Omega"."Com"."OPERATER" "OPERATER"
    ON "ORDRES"."_CODEOPERATEUR" = LCASE("OPERATER"."_CODEOPERAT")
  LEFT JOIN "OmegaModel_qgWs"."Omega"."Cpte"."OPERAT" "OPERAT"
    ON "ORDRES"."_CODEOPERATION" = "OPERAT"."_CODEOPERATION" 
---------------


<node name="ProjectNode">
	<property name="Relational Node ID">
		<value>0</value>
	</property>
	<property name="Output Columns">
		<value>OPERAT__NUMEROINT (integer)</value>
	</property>
	<property name="Statistics">
		<value>Node Output Rows: 0</value>
		<value>Node Next Batch Process Time: 0</value>
		<value>Node Cumulative Next Batch Process Time: 0</value>
		<value>Node Cumulative Process Time: 0</value>
		<value>Node Next Batch Calls: 0</value>
		<value>Node Blocks: 0</value>
	</property>
	<property name="Cost Estimates">
		<value>Estimated Node Cardinality: 0.0</value>
	</property>
	<property name="Child 0">
		<node name="JoinNode">
			<property name="Relational Node ID">
				<value>1</value>
			</property>
			<property name="Output Columns">
				<value>_NUMEROINT (integer)</value>
			</property>
			<property name="Statistics">
				<value>Node Output Rows: 0</value>
				<value>Node Next Batch Process Time: 0</value>
				<value>Node Cumulative Next Batch Process Time: 0</value>
				<value>Node Cumulative Process Time: 0</value>
				<value>Node Next Batch Calls: 0</value>
				<value>Node Blocks: 0</value>
			</property>
			<property name="Cost Estimates">
				<value>Estimated Node Cardinality: 0.0</value>
			</property>
			<property name="Child 0">
				<node name="JoinNode">
					<property name="Relational Node ID">
						<value>2</value>
					</property>
					<property name="Output Columns">
						<value>_CODEOPERATEUR (string)</value>
					</property>
					<property name="Cost Estimates">
						<value>Estimated Node Cardinality: 0.0</value>
					</property>
					<property name="Child 0">
						<node name="AccessNode">
							<property name="Relational Node ID">
								<value>3</value>
							</property>
							<property name="Output Columns">
								<value>_PRICETYPORDRE (string)</value>
								<value>_CODEOPERATEUR (string)</value>
							</property>
							<property name="Cost Estimates">
								<value>Estimated Node Cardinality: 0.0</value>
							</property>
							<property name="Query">
								<value>SELECT g_0."_PRICETYPORDRE", g_0."_CODEOPERATEUR" FROM OmegaModel_qgWs.Omega.Cpte.ORDRES AS g_0 LEFT OUTER JOIN OmegaModel_qgWs.Omega.Cpte.OPERAT AS g_1 ON g_0."_CODEOPERATION" = g_1."_CODEOPERATION"</value>
							</property>
							<property name="Model Name">
								<value>OmegaModel_qgWs</value>
							</property>
						</node>
					</property>
					<property name="Child 1">
						<node name="ProjectNode">
							<property name="Relational Node ID">
								<value>4</value>
							</property>
							<property name="Output Columns">
								<value>_CODE (short)</value>
								<value>expr (string)</value>
							</property>
							<property name="Child 0">
								<node name="AccessNode">
									<property name="Relational Node ID">
										<value>5</value>
									</property>
									<property name="Output Columns">
										<value>_CODE (short)</value>
									</property>
									<property name="Cost Estimates">
										<value>Estimated Node Cardinality: 0.0</value>
									</property>
									<property name="Query">
										<value>SELECT g_0."_CODE" FROM OmegaModel_OKi7.Omega.Com.FIXORDERTYPE AS g_0</value>
									</property>
									<property name="Model Name">
										<value>OmegaModel_OKi7</value>
									</property>
								</node>
							</property>
							<property name="Select Columns">
								<value>FIXORDERTYPE."_CODE"</value>
								<value>convert(FIXORDERTYPE."_CODE", string)</value>
							</property>
						</node>
					</property>
					<property name="Join Strategy">
						<value>ENHANCED SORT JOIN (SORT/SORT)</value>
					</property>
					<property name="Join Type">
						<value>LEFT OUTER JOIN</value>
					</property>
					<property name="Join Criteria">
						<value>ORDRES."_PRICETYPORDRE"=convert(FIXORDERTYPE."_CODE", string)</value>
					</property>
				</node>
			</property>
			<property name="Child 1">
				<node name="ProjectNode">
					<property name="Relational Node ID">
						<value>6</value>
					</property>
					<property name="Output Columns">
						<value>_CODEOPERAT (string)</value>
						<value>expr (string)</value>
					</property>
					<property name="Child 0">
						<node name="AccessNode">
							<property name="Relational Node ID">
								<value>7</value>
							</property>
							<property name="Output Columns">
								<value>_CODEOPERAT (string)</value>
							</property>
							<property name="Cost Estimates">
								<value>Estimated Node Cardinality: 0.0</value>
							</property>
							<property name="Query">
								<value>SELECT g_0."_CODEOPERAT" FROM OmegaModel_OKi7.Omega.Com.OPERATER AS g_0</value>
							</property>
							<property name="Model Name">
								<value>OmegaModel_OKi7</value>
							</property>
						</node>
					</property>
					<property name="Select Columns">
						<value>OPERATER."_CODEOPERAT"</value>
						<value>LCASE(OPERATER."_CODEOPERAT")</value>
					</property>
				</node>
			</property>
			<property name="Join Strategy">
				<value>ENHANCED SORT JOIN (SORT/SORT)</value>
			</property>
			<property name="Join Type">
				<value>LEFT OUTER JOIN</value>
			</property>
			<property name="Join Criteria">
				<value>ORDRES."_CODEOPERATEUR"=LCASE(OPERATER."_CODEOPERAT")</value>
			</property>
		</node>
	</property>
	<property name="Select Columns">
		<value>OPERAT."_NUMEROINT" AS OPERAT__NUMEROINT</value>
	</property>
	<property name="Data Bytes Sent">
		<value>0</value>
	</property>
	<property name="Planning Time">
		<value>6</value>
	</property>
</node>