1 2 Previous Next 16 Replies Latest reply on Jul 25, 2017 9:12 AM by uuliver

    what about the error means

    uuliver

      the vdb is active   i run the select * from table ,than

      Exception in thread "main" org.teiid.jdbc.TeiidSQLException: TEIID30504 Remote org.teiid.core.TeiidProcessingException: TEIID30504 Epbank: 942 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."w", g_0."id" FROM "testvdb" g_0]

       

      what about this means

        • 1. Re: what about the error means
          rareddy

          Please post the full message or attach the log.

          • 2. Re: what about the error means
            uuliver

            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

              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

                but my sql is select * from MM.A1_DSB_LOG

                why is A1_CURVEANDTABLERELATION

                • 5. Re: what about the error means
                  van.halbert

                  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

                    NO it just a table,not view

                    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

                      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

                        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

                          I believe you need to change useFullSchemaName to true so that the fully qualified name is used in the source query.

                          • 10. Re: what about the error means
                            uuliver

                            i change the useFullSchemaName to true ,but the vdb is not change

                             

                            and There's still this mistake,

                            • 11. Re: what about the error means
                              van.halbert

                              Also change useQualifiedName to true.

                               

                              Referring to the jdbc importer properties on the docs.

                              • 12. Re: what about the error means
                                uuliver

                                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

                                  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

                                    I don't understand what you are meaning

                                    1 2 Previous Next