-
1. Re: what about the error means
rareddy Jul 20, 2017 7:46 AM (in response to uuliver)Please post the full message or attach the log.
-
2. Re: what about the error means
uuliver Jul 23, 2017 10:29 PM (in response to rareddy)select * from MM.A1_DSB_LOG
org.teiid.runtime.client.TeiidClientException: java.lang.RuntimeException: Remote org.teiid.core.TeiidProcessingException: TEIID30504 MM: 942 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."LOG_ID", g_0."TASK_ID", g_0."COLLECT_NAME", g_0."FLAG", g_0."START_DATE", g_0."RECIEVE_DATE", g_0."REMARK1", g_0."NODE_NAME", g_0."COUNTSIZE", g_0."DATESOURCE", g_0."TARGETSOURCE", g_0."REMARK2", g_0."REMARK3", g_0."LABEL", g_0."COUNTSIZE_UPDATE", g_0."TASK_TYPE" FROM "A1_DSB_LOG" g_0]
this is the logs
2017-07-24 10:22:24,122 WARN [org.teiid.CONNECTOR] (Worker12_QueryProcessorQueue102) obYRbZkK17Lo Connector worker process failed for atomic-request=obYRbZkK17Lo.6.0.10: org.teiid.translator.jdbc.JDBCExecutionException: 942 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT c_0, c_1, c_2, c_3 FROM (SELECT g_0."KEY_ID" AS c_0, g_0."CURVENAME" AS c_1, g_0."TABLENAME" AS c_2, g_0."ISDEPTHFIELD" AS c_3 FROM "A1_CURVEANDTABLERELATION" g_0) WHERE ROWNUM <= 500]
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131)
at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:367)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:483)
at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220)
at com.sun.proxy.$Proxy29.execute(Unknown Source)
at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112)
at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65)
at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119)
at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210)
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)
Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist;
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504)
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123)
... 18 more
2017-07-24 10:22:24,129 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue103) obYRbZkK17Lo obYRbZkK17Lo.6.0.10 Remove State
2017-07-24 10:22:24,129 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue103) obYRbZkK17Lo obYRbZkK17Lo.6.0.10 Processing Close : SELECT g_0.KEY_ID AS c_0, g_0.CURVENAME AS c_1, g_0.TABLENAME AS c_2, g_0.ISDEPTHFIELD AS c_3 FROM MM.A1_CURVEANDTABLERELATION AS g_0 LIMIT 500
2017-07-24 10:22:24,129 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue103) obYRbZkK17Lo obYRbZkK17Lo.6.0.10 Closed execution
2017-07-24 10:22:24,129 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue103) obYRbZkK17Lo obYRbZkK17Lo.6.0.10 Closed connection
2017-07-24 10:22:24,129 WARN [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue103) obYRbZkK17Lo TEIID30020 Processing exception for request obYRbZkK17Lo.6 'TEIID30504 MM: 942 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT c_0, c_1, c_2, c_3 FROM (SELECT g_0."KEY_ID" AS c_0, g_0."CURVENAME" AS c_1, g_0."TABLENAME" AS c_2, g_0."ISDEPTHFIELD" AS c_3 FROM "A1_CURVEANDTABLERELATION" g_0) WHERE ROWNUM <= 500]'. Originally TeiidProcessingException 'ORA-00942:table or view does not exist;
' T4CTTIoer.java:439. Enable more detailed logging to see the entire stacktrace.
-
3. Re: what about the error means
van.halbert Jul 24, 2017 7:42 AM (in response to uuliver)The oracle exception: Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist;
indicates the table A1_CURVEANDTABLERELATION in the query doesn't exist in your oracle database.
My guess is either the table doesn't exist in this specific oracle instance or you don't have the correct permissions to access the table.
Van
-
4. Re: what about the error means
uuliver Jul 24, 2017 8:43 AM (in response to van.halbert)but my sql is select * from MM.A1_DSB_LOG
why is A1_CURVEANDTABLERELATION
-
5. Re: what about the error means
van.halbert Jul 24, 2017 8:57 AM (in response to uuliver)It would appear that MM.A1_DSB_LOG is a view based on the underlying source table of A1_CURVEANDTABLERELATION. This would be a good reason to look at the query plan to see where its deriving the source queries.
Van
-
6. Re: what about the error means
uuliver Jul 24, 2017 9:10 PM (in response to van.halbert)logs is below
at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:131) at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:367) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:483) at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:220) at com.sun.proxy.$Proxy29.execute(Unknown Source) at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:306) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:112) at org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108) at java.util.concurrent.FutureTask.run(FutureTask.java:266) at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:65) at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:282) at org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:119) at org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:210) 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) Caused by: java.sql.SQLSyntaxErrorException: ORA-00942: table or view is not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:504) at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:123) ... 18 more 2017-07-25 09:03:31,529 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue45) 3d3tXym5VLAD 3d3tXym5VLAD.0.0.0 Remove State
2017-07-25 09:03:31,530 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue45) 3d3tXym5VLAD 3d3tXym5VLAD.0.0.0 Processing Close : SELECT g_0.LOG_ID, g_0.TASK_ID, g_0.COLLECT_NAME, g_0.FLAG, g_0.START_DATE, g_0.RECIEVE_DATE, g_0.REMARK1, g_0.NODE_NAME, g_0.COUNTSIZE, g_0.DATESOURCE, g_0.TARGETSOURCE, g_0.REMARK2, g_0.REMARK3, g_0.LABEL, g_0.COUNTSIZE_UPDATE, g_0.TASK_TYPE FROM MM.A1_DSB_LOG AS g_0
2017-07-25 09:03:31,531 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue45) 3d3tXym5VLAD 3d3tXym5VLAD.0.0.0 Closed execution
2017-07-25 09:03:31,531 DEBUG [org.teiid.CONNECTOR] (Worker11_QueryProcessorQueue45) 3d3tXym5VLAD 3d3tXym5VLAD.0.0.0 Closed connection
2017-07-25 09:03:31,533 WARN [org.teiid.PROCESSOR] (Worker11_QueryProcessorQueue45) 3d3tXym5VLAD TEIID30020 Processing exception for request 3d3tXym5VLAD.0 'TEIID30504 MM: 942 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."LOG_ID", g_0."TASK_ID", g_0."COLLECT_NAME", g_0."FLAG", g_0."START_DATE", g_0."RECIEVE_DATE", g_0."REMARK1", g_0."NODE_NAME", g_0."COUNTSIZE", g_0."DATESOURCE", g_0."TARGETSOURCE", g_0."REMARK2", g_0."REMARK3", g_0."LABEL", g_0."COUNTSIZE_UPDATE", g_0."TASK_TYPE" FROM "A1_DSB_LOG" g_0]'. Originally TeiidProcessingException 'ORA-00942: table or view is not exist
' T4CTTIoer.java:439. Enable more detailed logging to see the entire stacktrace.
-
7. Re: what about the error means
van.halbert Jul 24, 2017 9:41 PM (in response to uuliver)Let me ask about the metadata that's being displayed:
- was that metadata imported using Teiid Designer or is that being derived from a xml formatted vdb (dynamic vdb)? If its a xml vdb, can you post the DDL defined in the vdb xml file?
- is the oracle instance that your accessing the same instance the metadata was imported from?
Van
-
8. Re: what about the error means
uuliver Jul 24, 2017 9:48 PM (in response to van.halbert)i use dynamic vdb,the content of vdb is below
<?xml version="1.0" ?><vdb name="ln711" version="1">
<description>VDB for: ln711, Version: 1</description>
<connection-type>BY_VERSION</connection-type>
<property name="UseConnectorMetadata" value="true"></property>
<model name="MM" type="PHYSICAL" visible="true">
<property name="importer.useQualifiedName" value="false"></property>
<property name="importer.useFullSchemaName" value="false"></property>
<property name="importer.importKeys" value="false"></property>
<property name="importer.schemaPattern" value="EPDM"></property>
<property name="importer.excludeTables" value="(?!(A1|CD)).*"></property>
<property name="importer.importIndexes" value="false"></property>
<property name="importer.tableTypes" value="TABLE"></property>
<property name="importer.importApproximateIndexes" value="false"></property>
<property name="importer.autoCreateUniqueConstraints" value="false"></property>
<source name="MM" translator-name="oracle" connection-jndi-name="java:/Epbank"></source>
</model></vdb>
-
9. Re: what about the error means
van.halbert Jul 24, 2017 10:08 PM (in response to uuliver)I believe you need to change useFullSchemaName to true so that the fully qualified name is used in the source query.
-
-
-
12. Re: what about the error means
uuliver Jul 24, 2017 10:48 PM (in response to van.halbert)change useQualifiedName to true. deploy vdb has error
TEIID31070 Empty model;There are no tables, procedures or functions defined in this model MM
-
13. Re: what about the error means
van.halbert Jul 24, 2017 11:14 PM (in response to uuliver)I wouldn't have thought changing useQualifiedName would have changed the filtering. Can you change it back and redeploy vdb to see if the vdb metadata returns.
-
14. Re: what about the error means
uuliver Jul 25, 2017 2:42 AM (in response to van.halbert)I don't understand what you are meaning