1 2 Previous Next 24 Replies Latest reply on Dec 6, 2018 9:36 AM by Ramesh Reddy

    Teiid Spring Boot with IBMDB2

    ABHILASH ASOKAN Newbie

      Hi All,

       

      I have configured my spring boot application with IBMDB2 to access data using ODATA protocol.

      i am able to get the metadata information using the URL, but unable to access any tables. Furnishing the errors as below, Please assist

       

      Error Log

      org.teiid.translator.jdbc.JDBCExecutionException: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, FROM "TEST" AS g_0 ORDER BY c_0]

      at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127) ~[translator-jdbc-10.1.0.jar:10.1.0]

      at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358) ~[teiid-engine-10.1.0.jar:10.1.0]

      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]

      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]

      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]

      at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

      at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216) ~[teiid-engine-10.1.0.jar:10.1.0]

      at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]

      at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) ~[teiid-engine-10.1.0.jar:10.1.0]

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

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

      at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_162]

       

      Application Properties:

       

      spring.datasource.test.url=

      spring.datasource.test.username=

      spring.datasource.test.password=

      spring.datasource.test.driver-class-name=com.ibm.db2.jcc.DB2Driver

      spring.datasource.test.importer.SchemaPattern=my-schema

        • 1. Re: Teiid Spring Boot with IBMDB2
          Ramesh Reddy Master

          Make sure your tables in the DB2 has primary keys before you can access through the OData. Second, the above snippet does not really show the error what is the error?

          • 2. Re: Teiid Spring Boot with IBMDB2
            ABHILASH ASOKAN Newbie

            Hi Ramesh,

             

            I have verified all the tales and every one has primary key in it. As you told i am providing complete error trace below,

             

            2018-11-27 14:44:40.940  WARN 16076 --- [ProcessorQueue0] org.teiid.CONNECTOR                      : Connector worker process failed for atomic-request=qPHcCiVyEq/5.0.0.0

            org.teiid.translator.jdbc.JDBCExecutionException: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, g_0."NATIONAL_GROUP_ID" AS c_1, g_0."GLOBAL_GROUP_ID" AS c_2, g_0."NATIONAL_GROUP_NAME" AS c_3, g_0."GLOBAL_GROUP_NAME" AS c_4, g_0."NATIONAL_GROUP_COUNTRY_CODE" AS c_5, g_0."GLOBAL_GROUP_COUNTRY_CODE" AS c_6 FROM "TEST" AS g_0 ORDER BY c_0]

            at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127) ~[translator-jdbc-10.1.0.jar:10.1.0]

            at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358) ~[teiid-engine-10.1.0.jar:10.1.0]

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]

            at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

            at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216) ~[teiid-engine-10.1.0.jar:10.1.0]

            at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]

            at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) ~[teiid-engine-10.1.0.jar:10.1.0]

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

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

            at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_162]

            at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61) [teiid-engine-10.1.0.jar:10.1.0]

            at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-10.1.0.jar:10.1.0]

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

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

            at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_162]

            at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_162]

            at java.lang.Thread.run(Thread.java:748) [na:1.8.0_162]

            Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DCDT0.TEST, DRIVER=3.64.106

            at com.ibm.db2.jcc.am.bd.a(bd.java:679) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.bd.a(bd.java:60) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.bd.a(bd.java:127) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.io.c(io.java:2706) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.io.d(io.java:2694) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.io.a(io.java:2143) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.jo.a(jo.java:7353) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.t4.ab.h(ab.java:141) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.t4.ab.b(ab.java:41) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.t4.p.a(p.java:32) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.t4.qb.i(qb.java:135) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.io.gb(io.java:2112) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.jo.rc(jo.java:3526) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.jo.b(jo.java:4322) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.jo.ec(jo.java:735) ~[db2jcc4-10.1.jar:na]

            at com.ibm.db2.jcc.am.jo.executeQuery(jo.java:708) ~[db2jcc4-10.1.jar:na]

            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]

            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]

            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]

            at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

            at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.14.jar:na]

            at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]

            at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) ~[translator-jdbc-10.1.0.jar:10.1.0]

            ... 18 common frames omitted

            • 3. Re: Teiid Spring Boot with IBMDB2
              Ramesh Reddy Master

              Looks like an error from your DB2 JDBC driver since it did not like the SQL query syntax that Teiid sent. It may be due to not selecting the correct translator type during the build of the VDB internally. Can you add the property

               

              logging.level.org.teiid.spring=DEBUG

               

              to application.properties, then run it again and post the VDB generated here, I want to make sure it is selecting the correct translator. If not it may be like this error java - Why do I get SQLCODE=-204, SQLSTATE=42704 with DB2 LUW and WebSphere App Server? - Stack Overflow  where case of the sql not matching up with database?

              • 4. Re: Teiid Spring Boot with IBMDB2
                ABHILASH ASOKAN Newbie

                Hi,

                Mentioned log level is added and attaching the error below,

                Logs:

                 

                2018-11-27 22:38:43.705  INFO 11496 --- [nio-8080-exec-2] org.teiid.COMMAND_LOG                    : START USER COMMAND: startTime=2018-11-27 22:38:43.705 requestID=uUsfLbEbVHbY.0 txID=null sessionID=uUsfLbEbVHbY applicationName=JDBC principal=anonymous vdbName=spring vdbVersion=1.0.0 sql=/*+ cache(ttl:300000 scope:USER) */ SELECT g0.ID, g0.MEASURE, g0.FORBORNE_CUSTOMER_ID, g0.CREATED_BY, g0.CREATED, g0.MODIFIED_BY, g0.MODIFIED, g0.VERSION, g0.FORBORNE_AGREEMENT_ID, g0.START_DATE, g0.END_DATE, g0.COMMENT, g0.NON_STANDARD_FEATURE, g0.SPPI_TEST_RESULT FROM credit.TEST AS g0 ORDER BY g0.ID /* uUsfLbEbVHbY */

                2018-11-27 22:38:43.910  WARN 11496 --- [ProcessorQueue0] org.teiid.CONNECTOR                      : Connector worker process failed for atomic-request=uUsfLbEbVHbY.0.0.0

                 

                 

                org.teiid.translator.jdbc.JDBCExecutionException: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, g_0."MEASURE" AS c_1, g_0."FORBORNE_CUSTOMER_ID" AS c_2, g_0."CREATED_BY" AS c_3, g_0."CREATED" AS c_4, g_0."MODIFIED_BY" AS c_5, g_0."MODIFIED" AS c_6, g_0."VERSION" AS c_7, g_0."FORBORNE_AGREEMENT_ID" AS c_8, g_0."START_DATE" AS c_9, g_0."END_DATE" AS c_10, g_0."COMMENT" AS c_11, g_0."NON_STANDARD_FEATURE" AS c_12, g_0."SPPI_TEST_RESULT" AS c_13 FROM "TEST" AS g_0 ORDER BY c_0]

                at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127) ~[translator-jdbc-10.1.0.jar:10.1.0]

                at org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358) ~[teiid-engine-10.1.0.jar:10.1.0]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]

                at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                at org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216) ~[teiid-engine-10.1.0.jar:10.1.0]

                at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]

                at org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302) ~[teiid-engine-10.1.0.jar:10.1.0]

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

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

                at java.util.concurrent.FutureTask.run(FutureTask.java:266) [na:1.8.0_162]

                at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61) [teiid-engine-10.1.0.jar:10.1.0]

                at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280) [teiid-engine-10.1.0.jar:10.1.0]

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

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

                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [na:1.8.0_162]

                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [na:1.8.0_162]

                at java.lang.Thread.run(Thread.java:748) [na:1.8.0_162]

                Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DCDT0.TEST, DRIVER=3.64.106

                at com.ibm.db2.jcc.am.bd.a(bd.java:679) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.bd.a(bd.java:60) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.bd.a(bd.java:127) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.io.c(io.java:2706) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.io.d(io.java:2694) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.io.a(io.java:2143) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.jo.a(jo.java:7353) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.t4.ab.h(ab.java:141) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.t4.ab.b(ab.java:41) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.t4.p.a(p.java:32) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.t4.qb.i(qb.java:135) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.io.gb(io.java:2112) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.jo.rc(jo.java:3526) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.jo.b(jo.java:4322) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.jo.ec(jo.java:735) ~[db2jcc4-10.1.jar:na]

                at com.ibm.db2.jcc.am.jo.executeQuery(jo.java:708) ~[db2jcc4-10.1.jar:na]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_162]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_162]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_162]

                at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                at org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114) ~[tomcat-jdbc-8.5.14.jar:na]

                at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]

                at org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119) ~[translator-jdbc-10.1.0.jar:10.1.0]

                ... 18 common frames omitted

                 

                 

                2018-11-27 22:38:43.945  INFO 11496 --- [nio-8080-exec-2] org.teiid.COMMAND_LOG                    : ERROR USER COMMAND: endTime=2018-11-27 22:38:43.945 requestID=uUsfLbEbVHbY.0 txID=null sessionID=uUsfLbEbVHbY principal=anonymous vdbName=spring vdbVersion=1.0.0 finalRowCount=null

                2018-11-27 22:38:43.947  WARN 11496 --- [nio-8080-exec-2] org.teiid.PROCESSOR                      : TEIID30020 Processing exception for request uUsfLbEbVHbY.0 'TEIID30504 credit: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, g_0."MEASURE" AS c_1, g_0."FORBORNE_CUSTOMER_ID" AS c_2, g_0."CREATED_BY" AS c_3, g_0."CREATED" AS c_4, g_0."MODIFIED_BY" AS c_5, g_0."MODIFIED" AS c_6, g_0."VERSION" AS c_7, g_0."FORBORNE_AGREEMENT_ID" AS c_8, g_0."START_DATE" AS c_9, g_0."END_DATE" AS c_10, g_0."COMMENT" AS c_11, g_0."NON_STANDARD_FEATURE" AS c_12, g_0."SPPI_TEST_RESULT" AS c_13 FROM "TEST" AS g_0 ORDER BY c_0]'. Originally TeiidProcessingException 'DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DCDT0.TEST, DRIVER=3.64.106' bd.java:679. Enable more detailed logging to see the entire stacktrace.

                2018-11-27 22:38:43.948  INFO 11496 --- [nio-8080-exec-2] org.teiid.COMMAND_LOG                    : END USER COMMAND: endTime=2018-11-27 22:38:43.947 requestID=uUsfLbEbVHbY.0 txID=null sessionID=uUsfLbEbVHbY principal=anonymous vdbName=spring vdbVersion=1.0.0 finalRowCount=0

                2018-11-27 22:38:43.955  WARN 11496 --- [nio-8080-exec-2] org.teiid.PROCESSOR                      : TEIID16053 Unable to process odata request due to: TEIID30504 credit: -204 TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0, g_0."MEASURE" AS c_1, g_0."FORBORNE_CUSTOMER_ID" AS c_2, g_0."CREATED_BY" AS c_3, g_0."CREATED" AS c_4, g_0."MODIFIED_BY" AS c_5, g_0."MODIFIED" AS c_6, g_0."VERSION" AS c_7, g_0."FORBORNE_AGREEMENT_ID" AS c_8, g_0."START_DATE" AS c_9, g_0."END_DATE" AS c_10, g_0."COMMENT" AS c_11, g_0."NON_STANDARD_FEATURE" AS c_12, g_0."SPPI_TEST_RESULT" AS c_13 FROM "TEST" AS g_0 ORDER BY c_0] Increase the log level to see the entire stack trace.

                 

                --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

                 

                Let me know where i can see vdb.xml file in my spring boot application?

                • 5. Re: Teiid Spring Boot with IBMDB2
                  Ramesh Reddy Master

                  That is very similar to what you provided originally. Have you added the property I mentioned? If yes, I do not see any DEBUG level messages

                  • 6. Re: Teiid Spring Boot with IBMDB2
                    ABHILASH ASOKAN Newbie

                    yes i had added the log level to DEBUG , Can you let me know where i can see vdb.xml file in my application?

                     

                    One more update

                    Error stated in my logs-Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704, SQLERRMC=DCDT0.TEST, DRIVER=3.64.106

                     

                    Obervation

                    SQLERRMC=DCDT0.TEST

                    DCDT0 --->username ( which is configured in application property )

                    TEST --->  table name

                    As per the link provided earlier,(java - Why do I get SQLCODE=-204, SQLSTATE=42704 with DB2 LUW and WebSphere App Server? - Stack Overflow  ), There should be a schema name there instead of username

                    application.properties

                    spring.datasource.test.url=

                    spring.datasource.test.username=dcdt0
                    spring.datasource.test.password=
                    spring.datasource.test.driver-class-name=com.ibm.db2.jcc.DB2Driver
                    spring.datasource.test.importer.SchemaPattern=CDTFDT

                    • 7. Re: Teiid Spring Boot with IBMDB2
                      ABHILASH ASOKAN Newbie

                      Also i need to tell you this configuration i have done in teiid designer in eclipse and it worked. But i need this to work in spring boot. I have tried with db2jcc4.jar & db2jcc.jar

                       

                      <dependency>
                        <groupId>com.ibm.db2.jcc</groupId>
                        <artifactId>db2jcc4</artifactId>
                        <version>10.1</version>
                      </dependency>
                      <dependency>
                        <groupId>com.ibm.db2</groupId>cd

                         <artifactId>db2jcc_license_cu</artifactId>
                        <version>10.5</version>
                      </dependency>

                      • 8. Re: Teiid Spring Boot with IBMDB2
                        Ramesh Reddy Master

                        13_abhi  wrote:

                         

                        Can you let me know where i can see vdb.xml file in my application?

                        It will be inlined in the log that spitted out to the console.

                        • 9. Re: Teiid Spring Boot with IBMDB2
                          ABHILASH ASOKAN Newbie

                          Hi Team,

                          I am not able to rely in this post, Please assit

                          • 10. Re: Teiid Spring Boot with IBMDB2
                            Ramesh Reddy Master

                            Abilash,

                             

                            I do not have the same setup with DB2 as you do a testing and tell you exactly what is happening, I am trying to guide where you can give me further information to figure out the issue. Without that I am helpless. The software is designed to log internal VDB constructs when it is run in DEBUG mode. I have changed the logging context to much wide now, see that helps.

                             

                            logging.level.org.teiid=DEBUG

                            • 11. Re: Teiid Spring Boot with IBMDB2
                              ABHILASH ASOKAN Newbie

                              Hi Ramesh,

                               

                              I have set debug level and got more error logs as below when invoking

                              http://localhost:8080/TABLE1

                               

                              Logs:

                               

                               

                              2018-11-29 08:40:32.163 DEBUG 11812 ---

                              org.teiid.AUDIT_LOG                      :  [spring.1.0.0, null anonymous

                              USERPASSWORD null null null true]

                              2018-11-29 08:40:32.163 DEBUG 11812 ---

                              org.teiid.SECURITY                       : authenticateUser anonymous JDBC

                              2018-11-29 08:40:32.164 DEBUG 11812 ---

                              org.teiid.SECURITY                       : Logon successful, created

                              session: sessionid=HUQfb2uepBfb; userName=anonymous; vdbName=spring;

                              vdbVersion=1.0.0; createdTime=Thu Nov 29 08:40:32 CET 2018;

                              applicationName=JDBC; clientHostName=null; clientHardwareAddress=null;

                              IPAddress=null; securityDomain=teiid-security; lastPingTime=Thu Nov 29

                              08:40:32 CET 2018

                              2018-11-29 08:40:32.165 DEBUG 11812 ---

                              org.teiid.AUDIT_LOG                      : 

                               

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : Successfully obtained a session.

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : Connection Url=

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : ApplicationName=JDBC

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : PassthroughAuthentication=true

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : waitForLoad=0

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : batch-size=256

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : VirtualDatabaseName=spring.1.0.0

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : transportName=odata

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : skiptoken-cache-time=300000

                              2018-11-29 08:40:32.165 DEBUG 11812 --- org.teiid.jdbc

                                                     : The JDBC Driver successfully obtained a connection.

                              2018-11-29 08:40:32.166 DEBUG 11812 --- org.teiid.ODATA

                                                      : Teiid-Query: /*+ cache(ttl:300000 scope:USER) */

                              SELECT g1.ID FROM credit.TABLE1 AS g1 ORDER BY g1.ID /* HUQfb2uepBfb */

                              2018-11-29 08:40:32.166  INFO 11812 ---

                              org.teiid.COMMAND_LOG                    : START USER COMMAND:

                              startTime=2018-11-29

                              08:40:32.166 requestID=HUQfb2uepBfb.0 txID=null sessionID=HUQfb2uepBfb

                              applicationName=JDBC principal=anonymous vdbName=spring

                              vdbVersion=1.0.0 sql=/*+

                              cache(ttl:300000 scope:USER) */ SELECT g1.ID FROM credit.TABLE1 AS g1 ORDER

                              BY g1.ID /* HUQfb2uepBfb */

                              2018-11-29 08:40:32.166 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      : Request Thread HUQfb2uepBfb.0

                              with state NEW

                              2018-11-29 08:40:32.166 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      : HUQfb2uepBfb.0 executing

                              prepared /*+ cache(ttl:300000 scope:USER) */ SELECT g1.ID FROM

                              credit.TABLE1 AS g1 ORDER BY g1.ID /* HUQfb2uepBfb */

                              2018-11-29 08:40:32.172 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      : ProcessTree for HUQfb2uepBfb.0

                              AccessNode(0) output=[g1.ID] SELECT g_0.ID AS c_0 FROM credit.TABLE1 AS g_0

                              ORDER BY c_0

                               

                              2018-11-29 08:40:32.173 DEBUG 11812 ---

                              org.teiid.TXN_LOG                        : before

                              getOrCreateTransactionContext:org.teiid.dqp.internal.process.TransactionServerImpl@5c92166b

                              (HUQfb2uepBfb)

                              2018-11-29 08:40:32.173 DEBUG 11812 ---

                              org.teiid.TXN_LOG                        : after

                              getOrCreateTransactionContext : HUQfb2uepBfb NONE ID:NONE

                              2018-11-29 08:40:32.173 DEBUG 11812 ---

                              org.teiid.BUFFER_MGR                     : Creating TupleBuffer: 3

                              batch size 256 of type PROCESSOR

                              2018-11-29 08:40:32.173 DEBUG 11812 ---

                              org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Create State

                              2018-11-29 08:40:32.174 DEBUG 11812 ---

                              org.teiid.BUFFER_MGR                     : HUQfb2uepBfb.0.0.1 Blocking on

                              source query HUQfb2uepBfb.0.0.1

                              2018-11-29 08:40:32.174 DEBUG 11812 ---

                              org.teiid.BUFFER_MGR                     : HUQfb2uepBfb.0 Blocking on

                              source request(s).

                              2018-11-29 08:40:32.174 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      : Request Thread HUQfb2uepBfb.0 -

                              processor blocked

                              2018-11-29 08:40:32.174 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      : Running task for parent thread

                              http-nio-8080-exec-3

                              2018-11-29 08:40:32.175 DEBUG 11812 ---

                              org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Processing

                              NEW request: SELECT g_0.ID AS c_0 FROM credit.TABLE1 AS g_0 ORDER BY c_0

                              2018-11-29 08:40:32.175 DEBUG 11812 ---

                              org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Obtained

                              execution

                              2018-11-29 08:40:32.175 DEBUG 11812 ---

                              org.teiid.COMMAND_LOG                    : START DATA SRC COMMAND:

                              startTime=2018-11-29

                              08:40:32.175 requestID=HUQfb2uepBfb.0 sourceCommandID=0 executionID=1

                              txID=null modelName=credit translatorName=db2 sessionID=HUQfb2uepBfb

                              principal=anonymous sql=SELECT g_0.ID AS c_0 FROM credit.TABLE1 AS g_0

                              ORDER BY c_0

                              2018-11-29 08:40:32.175 DEBUG 11812 ---

                              org.teiid.CONNECTOR                      : Source-specific command: SELECT

                              g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0

                              2018-11-29 08:40:32.176 DEBUG 11812 ---

                              org.teiid.COMMAND_LOG                    : SOURCE SRC COMMAND:

                              endTime=2018-11-29

                              08:40:32.176 requestID=HUQfb2uepBfb.0 sourceCommandID=0 executionID=1

                              txID=null modelName=credit translatorName=db2 sessionID=HUQfb2uepBfb

                              principal=anonymous sourceCommand=[SELECT g_0."ID" AS c_0 FROM "TABLE1" AS

                              g_0 ORDER BY c_0]

                              2018-11-29 08:40:32.179 DEBUG 11812 ---

                              org.teiid.COMMAND_LOG                    : ERROR SRC COMMAND:

                              endTime=2018-11-29

                              08:40:32.179 requestID=HUQfb2uepBfb.0 sourceCommandID=0 executionID=1

                              txID=null modelName=credit translatorName=db2 sessionID=HUQfb2uepBfb

                              principal=anonymous

                              2018-11-29 08:40:32.180  WARN 11812 ---

                              org.teiid.CONNECTOR                      : Connector worker process failed

                              for atomic-request=HUQfb2uepBfb.0.0.1

                               

                              org.teiid.translator.jdbc.JDBCExecutionException: -204

                              TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []

                              SQL: SELECT g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0]

                              at

                              org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127)

                              ~[translator-jdbc-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                              ~[na:1.8.0_162]

                              at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                              at

                              org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)

                              teiid-engine-10.1.0.jar:10.1.0

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104)

                              teiid-engine-10.1.0.jar:10.1.0

                              at java.util.concurrent.FutureTask.run(FutureTask.java:266) na:1.8.0_162

                              at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61)

                              teiid-engine-10.1.0.jar:10.1.0

                              at

                              org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)

                              teiid-engine-10.1.0.jar:10.1.0

                              at

                              org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)

                              teiid-engine-10.1.0.jar:10.1.0

                              at

                              org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)

                              teiid-engine-10.1.0.jar:10.1.0

                              at

                              java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

                              na:1.8.0_162

                              at

                              java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                              na:1.8.0_162

                              at java.lang.Thread.run(Thread.java:748) na:1.8.0_162

                              Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:

                              SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ABCD.TABLE1, DRIVER=4.11.77

                              at com.ibm.db2.jcc.am.gd.a(gd.java:676) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.gd.a(gd.java:60) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.gd.a(gd.java:127) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.c(jn.java:2561) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.d(jn.java:2549) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.a(jn.java:2025) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.a(kn.java:6836) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.cb.g(cb.java:140) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.cb.a(cb.java:40) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.q.a(q.java:32) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.rb.i(rb.java:135) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.ib(jn.java:1996) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.sc(kn.java:3058) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.b(kn.java:3841) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.fc(kn.java:702) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:672) ~[db2jcc4-10.1.jar:na]

                              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                              ~[na:1.8.0_162]

                              at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                              at

                              org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)

                              ~[tomcat-jdbc-8.5.14.jar:na]

                              at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]

                              at

                              org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)

                              ~[translator-jdbc-10.1.0.jar:10.1.0]

                              ... 18 common frames omitted

                               

                              2018-11-29 08:40:32.183 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      : Request Thread HUQfb2uepBfb.0

                              with state PROCESSING

                              2018-11-29 08:40:32.184 DEBUG 11812 ---

                              org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Remove State

                              2018-11-29 08:40:32.185 DEBUG 11812 ---

                              org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Processing

                              Close : SELECT g_0.ID AS c_0 FROM credit.TABLE1 AS g_0 ORDER BY c_0

                              2018-11-29 08:40:32.185 DEBUG 11812 ---

                              org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Closed

                              execution

                              2018-11-29 08:40:32.185 DEBUG 11812 ---

                              org.teiid.CONNECTOR                      : HUQfb2uepBfb.0.0.1 Closed

                              connection

                              2018-11-29 08:40:32.185 DEBUG 11812 ---

                              org.teiid.COMMAND_LOG                    : END SRC COMMAND: endTime=2018-11-29

                              08:40:32.185 requestID=HUQfb2uepBfb.0 sourceCommandID=0 executionID=1

                              txID=null modelName=credit translatorName=db2 sessionID=HUQfb2uepBfb

                              principal=anonymous finalRowCount=0 cpuTime(ns)=15600100

                              2018-11-29 08:40:32.189 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      : QueryProcessor: closing processor

                              2018-11-29 08:40:32.189  INFO 11812 ---

                              org.teiid.COMMAND_LOG                    : ERROR USER COMMAND:

                              endTime=2018-11-29

                              08:40:32.189 requestID=HUQfb2uepBfb.0 txID=null sessionID=HUQfb2uepBfb

                              principal=anonymous vdbName=spring vdbVersion=1.0.0 finalRowCount=null

                              2018-11-29 08:40:32.192  WARN 11812 ---

                              org.teiid.PROCESSOR                      : TEIID30020 Processing exception

                              for request HUQfb2uepBfb.0 'TEIID30504 credit: -204 TEIID11008:TEIID11004

                              Error executing statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS

                              c_0 FROM "TABLE1" AS g_0 ORDER BY c_0]'. Originally

                              TeiidProcessingException 'DB2 SQL Error: SQLCODE=-204, SQLSTATE=42704,

                              SQLERRMC=ABCD.TABLE1, DRIVER=4.11.77' gd.java:676.

                               

                              org.teiid.core.TeiidProcessingException: TEIID30504 credit: -204

                              TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []

                              SQL: SELECT g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:397)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:157)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:398)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:480)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:340)

                              teiid-engine-10.1.0.jar:10.1.0

                              at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:255)

                              teiid-engine-10.1.0.jar:10.1.0

                              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                              ~[na:1.8.0_162]

                              at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                              at

                              org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:213)

                              teiid-runtime-10.1.0.jar:10.1.0

                              at java.util.concurrent.FutureTask.run(FutureTask.java:266) na:1.8.0_162

                              at

                              org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)

                              teiid-engine-10.1.0.jar:10.1.0

                              at

                              org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:264)

                              teiid-engine-10.1.0.jar:10.1.0

                              at

                              org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:211)

                              teiid-runtime-10.1.0.jar:10.1.0

                              at com.sun.proxy.$Proxy79.executeRequest(Unknown Source) na:na

                              at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:709)

                              teiid-client-10.1.0.jar:10.1.0

                              at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:551)

                              teiid-client-10.1.0.jar:10.1.0

                              at

                              org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:313)

                              teiid-client-10.1.0.jar:10.1.0

                              at

                              org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:72)

                              teiid-client-10.1.0.jar:10.1.0

                              at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:246)

                              teiid-olingo-10.1.0.jar:10.1.0

                              at

                              org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:350)

                              teiid-olingo-10.1.0.jar:10.1.0

                              at

                              org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:168)

                              teiid-olingo-10.1.0.jar:10.1.0

                              at

                              org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:332)

                              odata-server-core-ext-4.4.0.jar:4.4.0

                              at

                              org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:255)

                              odata-server-core-ext-4.4.0.jar:4.4.0

                              at

                              org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:160)

                              odata-server-core-ext-4.4.0.jar:4.4.0

                              at

                              org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:98)

                              odata-server-core-ext-4.4.0.jar:4.4.0

                              at

                              org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:67)

                              odata-server-core-ext-4.4.0.jar:4.4.0

                              at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:39)

                              teiid-olingo-10.1.0.jar:10.1.0

                              at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

                              tomcat-embed-websocket-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.teiid.spring.odata.SpringODataFilter.internalDoFilter(SpringODataFilter.java:93)

                              spring-odata-1.0.0.jar:na

                              at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:96)

                              teiid-olingo-10.1.0.jar:10.1.0

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              com.nordea.security.spring.NordeaTokenAuthorizationFilter.doFilterInternal(NordeaTokenAuthorizationFilter.java:77)

                              springsecurity-1.1.4.jar:na

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

                              na:1.8.0_162

                              at

                              java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                              na:1.8.0_162

                              at

                              org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at java.lang.Thread.run(Thread.java:748) na:1.8.0_162

                              Caused by: org.teiid.translator.jdbc.JDBCExecutionException: -204

                              TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []

                              SQL: SELECT g_0."ID" AS c_0  FROM "TABLE1" AS g_0 ORDER BY c_0]

                              at

                              org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127)

                              ~[translator-jdbc-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                              ~[na:1.8.0_162]

                              at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                              at

                              org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at java.util.concurrent.FutureTask.run(FutureTask.java:266) na:1.8.0_162

                              at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)

                              teiid-engine-10.1.0.jar:10.1.0

                              at

                              org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

                              na:1.8.0_162

                              at

                              java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                              na:1.8.0_162

                              ... 1 common frames omitted

                              Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:

                              SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ABCD.TABLE1, DRIVER=4.11.77

                              at com.ibm.db2.jcc.am.gd.a(gd.java:676) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.gd.a(gd.java:60) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.gd.a(gd.java:127) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.c(jn.java:2561) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.d(jn.java:2549) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.a(jn.java:2025) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.a(kn.java:6836) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.cb.g(cb.java:140) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.cb.a(cb.java:40) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.q.a(q.java:32) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.rb.i(rb.java:135) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.ib(jn.java:1996) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.sc(kn.java:3058) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.b(kn.java:3841) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.fc(kn.java:702) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:672) ~[db2jcc4-10.1.jar:na]

                              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                              ~[na:1.8.0_162]

                              at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                              at

                              org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)

                              ~[tomcat-jdbc-8.5.14.jar:na]

                              at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]

                              at

                              org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)

                              ~[translator-jdbc-10.1.0.jar:10.1.0]

                              ... 18 common frames omitted

                               

                              2018-11-29 08:40:32.197 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      : Removing tuplesource for the

                              request HUQfb2uepBfb.0

                              2018-11-29 08:40:32.197 DEBUG 11812 ---

                              org.teiid.BUFFER_MGR                     : Removing TupleBuffer: 3

                              2018-11-29 08:40:32.197 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      : HUQfb2uepBfb.0 Finished

                              Processing

                              2018-11-29 08:40:32.197 DEBUG 11812 ---

                              org.teiid.PROCESSOR                      :

                              org.teiid.core.TeiidProcessingException: TEIID30504 credit: -204

                              TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []

                              SQL: SELECT g_0."ID" AS c_0  FROM "TABLE1" AS g_0 ORDER BY c_0] Sending

                              error to client HUQfb2uepBfb.0

                              2018-11-29 08:40:32.198  INFO 11812 ---

                              org.teiid.COMMAND_LOG                    : END USER COMMAND: endTime=2018-11-29

                              08:40:32.198 requestID=HUQfb2uepBfb.0 txID=null sessionID=HUQfb2uepBfb

                              principal=anonymous vdbName=spring vdbVersion=1.0.0 finalRowCount=0

                              2018-11-29 08:40:32.200  WARN 11812 --- org.teiid.ODATA

                                                      : TEIID16052 Unable to process odata request due

                              to: TEIID30504 credit: -204 TEIID11008:TEIID11004 Error executing

                              statement(s): [Prepared Values: [] SQL: SELECT g_0."ID" AS c_0 FROM

                              "TABLE1" AS g_0 ORDER BY c_0]

                               

                              org.teiid.core.TeiidProcessingException: TEIID30504 credit: -204

                              TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []

                              SQL: SELECT g_0."ID" AS c_0 FROM "TABLE1" AS g_0 ORDER BY c_0]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource.exceptionOccurred(DataTierTupleSource.java:397)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource.nextTuple(DataTierTupleSource.java:157)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.relational.AccessNode.nextBatchDirect(AccessNode.java:398)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.relational.RelationalNode.nextBatch(RelationalNode.java:277)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.relational.RelationalPlan.nextBatch(RelationalPlan.java:141)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.QueryProcessor.nextBatchDirect(QueryProcessor.java:148)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.QueryProcessor.nextBatch(QueryProcessor.java:111)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:160)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.query.processor.BatchCollector.collectTuples(BatchCollector.java:142)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:480)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:350)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:47)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:276)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:340)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:255)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                              ~[na:1.8.0_162]

                              at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                              at

                              org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:213)

                              ~[teiid-runtime-10.1.0.jar:10.1.0]

                              at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_162]

                              at

                              org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:264)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:211)

                              ~[teiid-runtime-10.1.0.jar:10.1.0]

                              at com.sun.proxy.$Proxy79.executeRequest(Unknown Source) ~[na:na]

                              at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:709)

                              ~[teiid-client-10.1.0.jar:10.1.0]

                              at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:551)

                              ~[teiid-client-10.1.0.jar:10.1.0]

                              at

                              org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:313)

                              ~[teiid-client-10.1.0.jar:10.1.0]

                              at

                              org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:72)

                              ~[teiid-client-10.1.0.jar:10.1.0]

                              at org.teiid.olingo.service.LocalClient.executeSQL(LocalClient.java:246)

                              ~[teiid-olingo-10.1.0.jar:10.1.0]

                              at

                              org.teiid.olingo.service.TeiidServiceHandler.executeQuery(TeiidServiceHandler.java:350)

                              ~[teiid-olingo-10.1.0.jar:10.1.0]

                              at

                              org.teiid.olingo.service.TeiidServiceHandler.read(TeiidServiceHandler.java:168)

                              ~[teiid-olingo-10.1.0.jar:10.1.0]

                              at

                              org.apache.olingo.server.core.requests.DataRequest$EntityRequest.execute(DataRequest.java:332)

                              ~[odata-server-core-ext-4.4.0.jar:4.4.0]

                              at

                              org.apache.olingo.server.core.requests.DataRequest.execute(DataRequest.java:255)

                              ~[odata-server-core-ext-4.4.0.jar:4.4.0]

                              at

                              org.apache.olingo.server.core.ServiceDispatcher.internalExecute(ServiceDispatcher.java:160)

                              ~[odata-server-core-ext-4.4.0.jar:4.4.0]

                              at

                              org.apache.olingo.server.core.ServiceDispatcher.execute(ServiceDispatcher.java:98)

                              ~[odata-server-core-ext-4.4.0.jar:4.4.0]

                              at

                              org.apache.olingo.server.core.OData4HttpHandler.process(OData4HttpHandler.java:67)

                              ~[odata-server-core-ext-4.4.0.jar:4.4.0]

                              at org.teiid.olingo.web.ODataServlet.service(ODataServlet.java:39)

                              ~[teiid-olingo-10.1.0.jar:10.1.0]

                              at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)

                              ~[tomcat-embed-core-8.5.14.jar:8.5.14]

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:231)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52)

                              tomcat-embed-websocket-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.teiid.spring.odata.SpringODataFilter.internalDoFilter(SpringODataFilter.java:93)

                              spring-odata-1.0.0.jar:na

                              at org.teiid.olingo.web.ODataFilter.doFilter(ODataFilter.java:96)

                              teiid-olingo-10.1.0.jar:10.1.0

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:317)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:127)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:91)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:114)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:137)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:111)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:170)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:63)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              com.nordea.security.spring.NordeaTokenAuthorizationFilter.doFilterInternal(NordeaTokenAuthorizationFilter.java:77)

                              springsecurity-1.1.4.jar:na

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:116)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:96)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.header.HeaderWriterFilter.doFilterInternal(HeaderWriterFilter.java:64)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:105)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:56)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:331)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:214)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:177)

                              spring-security-web-4.2.2.RELEASE.jar:4.2.2.RELEASE

                              at

                              org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:262)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:99)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.web.filter.HttpPutFormContentFilter.doFilterInternal(HttpPutFormContentFilter.java:105)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.web.filter.HiddenHttpMethodFilter.doFilterInternal(HiddenHttpMethodFilter.java:81)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)

                              spring-web-4.3.8.RELEASE.jar:4.3.8.RELEASE

                              at

                              org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:193)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:166)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:198)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:96)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:478)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:140)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:80)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:87)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:342)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:799)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:66)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:861)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1455)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at

                              java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

                              na:1.8.0_162

                              at

                              java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                              na:1.8.0_162

                              at

                              org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)

                              tomcat-embed-core-8.5.14.jar:8.5.14

                              at java.lang.Thread.run(Thread.java:748) na:1.8.0_162

                              Caused by: org.teiid.translator.jdbc.JDBCExecutionException: -204

                              TEIID11008:TEIID11004 Error executing statement(s): [Prepared Values: []

                              SQL: SELECT g_0."ID" AS c_0 t

                              org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:127)

                              ~[translator-jdbc-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.datamgr.ConnectorWorkItem.execute(ConnectorWorkItem.java:358)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                              ~[na:1.8.0_162]

                              at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                              at

                              org.teiid.dqp.internal.datamgr.ConnectorManager$1.invoke(ConnectorManager.java:216)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at com.sun.proxy.$Proxy90.execute(Unknown Source) ~[na:na]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource.getResults(DataTierTupleSource.java:302)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:108)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DataTierTupleSource$1.call(DataTierTupleSource.java:104)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at java.util.concurrent.FutureTask.run(FutureTask.java:266) ~[na:1.8.0_162]

                              at org.teiid.dqp.internal.process.FutureWork.run(FutureWork.java:61)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:280)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.ThreadReuseExecutor$RunnableWrapper.run(ThreadReuseExecutor.java:115)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              org.teiid.dqp.internal.process.ThreadReuseExecutor$3.run(ThreadReuseExecutor.java:206)

                              ~[teiid-engine-10.1.0.jar:10.1.0]

                              at

                              java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)

                              na:1.8.0_162

                              at

                              java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)

                              na:1.8.0_162

                              ... 1 common frames omitted

                              Caused by: com.ibm.db2.jcc.am.SqlSyntaxErrorException: DB2 SQL Error:

                              SQLCODE=-204, SQLSTATE=42704, SQLERRMC=ABCD.TABLE1, DRIVER=4.11.77

                              at com.ibm.db2.jcc.am.gd.a(gd.java:676) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.gd.a(gd.java:60) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.gd.a(gd.java:127) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.c(jn.java:2561) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.d(jn.java:2549) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.a(jn.java:2025) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.a(kn.java:6836) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.cb.g(cb.java:140) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.cb.a(cb.java:40) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.q.a(q.java:32) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.t4.rb.i(rb.java:135) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.jn.ib(jn.java:1996) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.sc(kn.java:3058) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.b(kn.java:3841) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.fc(kn.java:702) ~[db2jcc4-10.1.jar:na]

                              at com.ibm.db2.jcc.am.kn.executeQuery(kn.java:672) ~[db2jcc4-10.1.jar:na]

                              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)

                              ~[na:1.8.0_162]

                              at

                              sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                              ~[na:1.8.0_162]

                              at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_162]

                              at

                              org.apache.tomcat.jdbc.pool.StatementFacade$StatementProxy.invoke(StatementFacade.java:114)

                              ~[tomcat-jdbc-8.5.14.jar:na]

                              at com.sun.proxy.$Proxy91.executeQuery(Unknown Source) ~[na:na]

                              at

                              org.teiid.translator.jdbc.JDBCQueryExecution.execute(JDBCQueryExecution.java:119)

                              ~[translator-jdbc-10.1.0.jar:10.1.0]

                              ... 18 common frames omitted

                               

                              2018-11-29 08:40:32.205 DEBUG 11812 --- org.teiid.jdbc

                                                     : Statement closed successfully.

                              2018-11-29 08:40:32.206 DEBUG 11812 ---

                              org.teiid.SECURITY                       : closeSession HUQfb2uepBfb

                              2018-11-29 08:40:32.206 DEBUG 11812 ---

                              org.teiid.AUDIT_LOG                      : 

                              2018-11-29 08:40:32.206 DEBUG 11812 ---

                              org.teiid.TXN_LOG                        : before

                              cancelTransactions:org.teiid.dqp.internal.process.TransactionServerImpl@5c92166b

                              (HUQfb2uepBfb,false)

                              2018-11-29 08:40:32.206 DEBUG 11812 ---

                              org.teiid.TXN_LOG                        : after cancelTransactions : null

                              2018-11-29 08:40:32.206 DEBUG 11812 --- org.teiid.jdbc

                                                     : Connection successfully closed.

                              • 12. Re: Teiid Spring Boot with IBMDB2
                                Ramesh Reddy Master

                                I am asking for the log from when you start the application, not when you issue the query. Also please attach the log, do not post into the forum, as it makes hard to scroll through since it is so long.

                                • 13. Re: Teiid Spring Boot with IBMDB2
                                  ABHILASH ASOKAN Newbie

                                  PFA-error logs while starting application

                                  • 14. Re: Teiid Spring Boot with IBMDB2
                                    Ramesh Reddy Master

                                    Add these properties to your "application.properties" file and restart

                                     

                                    spring.datasource.test.importer.UseQualifiedName=true
                                    spring.datasource.test.importer.UseFullSchemaName=false

                                     

                                    Hopefully, that should fix that.

                                    1 2 Previous Next