Issue

• TEIID-3874
• can manifest as

WARN  [org.teiid.CONNECTOR] (Worker2_QueryProcessorQueue2) n/1W7OUsfDt9 Connector worker process failed for atomic-request=n/1W7OUsfDt9.0.2.1: org.teiid.translator.jdbc.JDBCExecutionException: 942 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0.DEPTNO AS c_0 FROM eee g_0 ORDER BY c_0]

    at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)

    at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:330) [teiid-engine-8.7.3.6_2.jar:8.7.3.6_2]

    at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:298) [teiid-engine-8.7.3.6_2.jar:8.7.3.6_2]

    at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:110) [teiid-engine-8.7.3.6_2.jar:8.7.3.6_2]

    at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:107) [teiid-engine-8.7.3.6_2.jar:8.7.3.6_2]

    at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_67]

    at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:58) [teiid-engine-8.7.3.6_2.jar:8.7.3.6_2]

    at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274) [teiid-engine-8.7.3.6_2.jar:8.7.3.6_2]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) [teiid-engine-8.7.3.6_2.jar:8.7.3.6_2]

    at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) [teiid-engine-8.7.3.6_2.jar:8.7.3.6_2]

    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_67]

    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_67]

    at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_67]

Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist



    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:452)

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:400)

    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:884)

    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:471)

    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:199)

    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:535)

    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:238)

    at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:1196)

    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1444)

    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1662)

    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:4364)

    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:4445)

    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:6268)

    at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)

    at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)

    ... 12 more