1 2 Previous Next 20 Replies Latest reply on Sep 28, 2012 10:33 PM by Ramesh Reddy

    TEIID31100 Parsing error: : Encountered "(" at line 1, column 6.

    luca gioppo Novice

      Ok next step next error:

      Now the Webservice connects to the VDB but crashes, now it could be something missing, but can depend on some of my code on the WS part

       

      This is the procedure that get's called, mind I just run the autogeneration so it mat be missing few stuff around, but I'm on a new ground here.

       

      CREATE VIRTUAL PROCEDURE

      BEGIN

          DECLARE string VARIABLES.IN_exampleVar;

          VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');

          SELECT * FROM BooksDB_Output_View.books_books_OutputView;

      END

       

      15:44:35,432 DEBUG [org.teiid.PROCESSOR] (http--127.0.0.1-8080-1) Request Thread wvdrZZTkEDC6.0 - error occurred: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

       

          at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:204)

          at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:158)

          at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:134)

          at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:304)

          at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:380)

          at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:155)

          at org.teiid.dqp.internal.process.Request.processRequest(Request.java:453)

          at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:532)

          at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:280)

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

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

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

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

          at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.1.0.Final.jar:8.1.0.Final]

          at org.teiid.jboss.TransportService$2.invoke(TransportService.java:205)

          at $Proxy18.executeRequest(Unknown Source)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

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

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

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

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

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

          at $Proxy18.executeRequest(Unknown Source)    at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)

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

          at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:192)

          at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

          at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:124) [classes:]

          at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

          at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

          at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

          at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

          at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

          at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

          at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

          at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

          at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

          at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

          at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

       

      15:44:35,530 WARN  [org.teiid.PROCESSOR] (http--127.0.0.1-8080-1) TEIID30020 Processing exception 'TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

          ' for request wvdrZZTkEDC6.0.  Exception type org.teiid.api.exception.query.QueryParserException thrown from org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:204). Enable more detailed logging to see the entire stacktrace.

      15:44:35,541 DEBUG [org.teiid.PROCESSOR] (http--127.0.0.1-8080-1) Sending error to client wvdrZZTkEDC6.0: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

       

          at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:204)

          at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:158)

          at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:134)

          at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:304)

          at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:380)

          at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:155)

          at org.teiid.dqp.internal.process.Request.processRequest(Request.java:453)

          at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:532)

          at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:280)

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

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

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

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

          at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.1.0.Final.jar:8.1.0.Final]

          at org.teiid.jboss.TransportService$2.invoke(TransportService.java:205)

          at $Proxy18.executeRequest(Unknown Source)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

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

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

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

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

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

          at $Proxy18.executeRequest(Unknown Source)    at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)

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

          at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:192)

          at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

          at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:124) [classes:]

          at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

          at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

          at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

          at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

          at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

          at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

          at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

          at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

          at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

          at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

          at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

       

      15:44:35,623 GRAVE [org.teiid.soap] (http--127.0.0.1-8080-1) Exception in executeDataservice: {0}: java.lang.Throwable: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

       

          at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:194) [classes:]

          at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

          at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

          at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

          at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

          at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

          at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

          at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

          at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

          at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

          at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

          at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

      Caused by: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

       

          at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

          at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

          at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:656)

          at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

          at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:512)

          at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)

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

          at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:192)

          at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

          at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:124) [classes:]

          ... 41 more

      Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

       

          at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:204)

          at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:158)

          at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:134)

          at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:304)

          at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:380)

          at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:155)

          at org.teiid.dqp.internal.process.Request.processRequest(Request.java:453)

          at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:532)

          at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:280)

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

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

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

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

          at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.1.0.Final.jar:8.1.0.Final]

          at org.teiid.jboss.TransportService$2.invoke(TransportService.java:205)

          at $Proxy18.executeRequest(Unknown Source)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

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

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

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

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

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

          at $Proxy18.executeRequest(Unknown Source)    at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)

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

          ... 44 more

       

      15:44:35,838 FINE  [org.teiid.jdbc] (http--127.0.0.1-8080-1) Statement closed successfully.

      15:44:35,842 ERROR [org.jboss.ws.common.invocation.InvocationHandlerJAXWS] (http--127.0.0.1-8080-1) Method invocation failed with exception: null: java.lang.reflect.InvocationTargetException

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

          at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

          at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

          at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

          at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

          at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

          at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

          at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

          at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

          at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

          at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

      Caused by: java.lang.RuntimeException: javax.xml.ws.soap.SOAPFaultException: TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

       

          at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:318) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

          ... 38 more

      Caused by: javax.xml.ws.soap.SOAPFaultException: TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

       

          at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248) [classes:]

          at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:201) [classes:]

          at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

          ... 40 more

       

      15:44:35,919 AVVERTENZA [org.apache.cxf.phase.PhaseInterceptorChain] (http--127.0.0.1-8080-1) Application {http://teiid.org}BookXMLDBWS has thrown exception, unwinding now: org.apache.cxf.binding.soap.SoapFault: TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

       

          at org.jboss.wsf.stack.cxf.JBossWSInvoker.createFault(JBossWSInvoker.java:237)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:201)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

          at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

          at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

          at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

          at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

          at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

          at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

          at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

          at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

          at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

          at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

          at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doGet(AbstractHTTPServlet.java:113)

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:734) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

          at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

          at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

          at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

          at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

          at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

      Caused by: javax.xml.ws.soap.SOAPFaultException: TEIID31100 Parsing error: Encountered "null" at line 1, column 6.

      Was expecting one of:

          "instead" ...

          "enabled" ...

          "disabled" ...

          "view" ...

          "key" ...

          "serial" ...

          "textagg" ...

          "count" ...

          "row_number" ...

          "rank" ...

          ...

       

          at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248) [classes:]

          at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:201) [classes:]

          at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

          at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

          at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

          at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

          at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

          at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

          at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

          ... 32 more

        • 1. Re: TEIID31100 Parsing error: Encountered "null"
          Van Halbert Master

          Looking at the docs (https://docs.jboss.org/author/display/TEIID/XML+Functions), it indicates a "doc" needs to be passed in, not a "null".  I would surmize that if a null was allowed to be passed in, an NPE would occur.

          • 2. Re: TEIID31100 Parsing error: Encountered "null"
            Steven Hawkins Master

            An NPE will not occur at processing.  null is a valid expression.  The result of most functions, including xpathvalue with a null argument is null.

             

            The parsing exception is from your user query.  What are you sending to the server?

             

            Steve

            • 3. Re: TEIID31100 Parsing error: Encountered "null"
              luca gioppo Novice

              I know its a dumb way of testing but just called the end point:

              http://localhost:8080/BookXMLDBWS/BooksDB_books_books

              Bear with me

              Hoped that it could return something, but obviously it need a proper SOAP call.

              Will try with soapUI.

              Luca

              • 4. Re: TEIID31100 Parsing error: Encountered "null"
                luca gioppo Novice

                But where do I get the wsdl in jboss?

                I know I'm on the dumb side of the road.

                 

                15:44:13,164 INFO  [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-6) Add Service

                id=BooksDB_books_authors

                address=http://localhost:8080/BookXMLDBWS/BooksDB_books_authors

                implementor=org.teiid.soap.provider.BooksDB_books_authors

                invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

                serviceName={http://teiid.org}BookXMLDBWS

                portName={http://teiid.org}BooksDB_books_authors

                wsdlLocation=null

                mtomEnabled=false

                15:44:13,178 INFO  [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-6) Add Service

                id=BooksDB_books_books

                address=http://localhost:8080/BookXMLDBWS/BooksDB_books_books

                implementor=org.teiid.soap.provider.BooksDB_books_books

                invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

                serviceName={http://teiid.org}BookXMLDBWS

                portName={http://teiid.org}BooksDB_books_books

                wsdlLocation=null

                mtomEnabled=false

                15:44:13,202 INFO  [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-6) Add Service

                id=BooksDB_books_book_authors

                address=http://localhost:8080/BookXMLDBWS/BooksDB_books_book_authors

                implementor=org.teiid.soap.provider.BooksDB_books_book_authors

                invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

                serviceName={http://teiid.org}BookXMLDBWS

                portName={http://teiid.org}BooksDB_books_book_authors

                wsdlLocation=null

                mtomEnabled=false

                15:44:13,217 INFO  [org.jboss.wsf.stack.cxf.metadata.MetadataBuilder] (MSC service thread 1-6) Add Service

                id=BooksDB_books_publishers

                address=http://localhost:8080/BookXMLDBWS/BooksDB_books_publishers

                implementor=org.teiid.soap.provider.BooksDB_books_publishers

                invoker=org.jboss.wsf.stack.cxf.JBossWSInvoker

                serviceName={http://teiid.org}BookXMLDBWS

                portName={http://teiid.org}BooksDB_books_publishers

                wsdlLocation=null

                mtomEnabled=false

                15:44:13,390 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB BookXMLDB.1 model "BookXML" metadata is currently being loaded. Start Time: 24/09/12 15.44

                15:44:13,395 INFO  [org.teiid.RUNTIME] (MSC service thread 1-1) TEIID50029 VDB BookXMLDB.1 model "BooksDB" metadata is currently being loaded. Start Time: 24/09/12 15.44

                15:44:13,479 INFO  [org.teiid.RUNTIME] (teiid-async-threads - 2) TEIID40003 VDB BookXMLDB.1 is set to ACTIVE

                15:44:13,567 INFO  [org.apache.cxf.service.factory.ReflectionServiceFactoryBean] (MSC service thread 1-6) Creating Service {http://teiid.org}BookXMLDBWS from WSDL: WEB-INF/wsdl/BookXMLDBWS.wsdl

                15:44:13,896 INFO  [org.apache.cxf.endpoint.ServerImpl] (MSC service thread 1-6) Setting the server's publish address to be http://localhost:8080/BookXMLDBWS/BooksDB_books_authors

                15:44:14,009 INFO  [org.jboss.wsf.stack.cxf.deployment.WSDLFilePublisher] (MSC service thread 1-6) WSDL published to: file:/D:/Servers/jboss-as-7.1.1-TEIID8.1/standalone/data/wsdl/BookXMLDBWS.war/BookXMLDBWS.wsdl

                15:44:14,031 INFO  [org.apache.cxf.service.factory.ReflectionServiceFactoryBean] (MSC service thread 1-6) Creating Service {http://teiid.org}BookXMLDBWS from WSDL: WEB-INF/wsdl/BookXMLDBWS.wsdl

                15:44:14,036 INFO  [org.apache.cxf.endpoint.ServerImpl] (MSC service thread 1-6) Setting the server's publish address to be http://localhost:8080/BookXMLDBWS/BooksDB_books_books

                15:44:14,058 INFO  [org.jboss.wsf.stack.cxf.deployment.WSDLFilePublisher] (MSC service thread 1-6) WSDL published to: file:/D:/Servers/jboss-as-7.1.1-TEIID8.1/standalone/data/wsdl/BookXMLDBWS.war/BookXMLDBWS.wsdl

                15:44:14,072 INFO  [org.apache.cxf.service.factory.ReflectionServiceFactoryBean] (MSC service thread 1-6) Creating Service {http://teiid.org}BookXMLDBWS from WSDL: WEB-INF/wsdl/BookXMLDBWS.wsdl

                15:44:14,076 INFO  [org.apache.cxf.endpoint.ServerImpl] (MSC service thread 1-6) Setting the server's publish address to be http://localhost:8080/BookXMLDBWS/BooksDB_books_book_authors

                15:44:14,094 INFO  [org.jboss.wsf.stack.cxf.deployment.WSDLFilePublisher] (MSC service thread 1-6) WSDL published to: file:/D:/Servers/jboss-as-7.1.1-TEIID8.1/standalone/data/wsdl/BookXMLDBWS.war/BookXMLDBWS.wsdl

                15:44:14,100 INFO  [org.apache.cxf.service.factory.ReflectionServiceFactoryBean] (MSC service thread 1-6) Creating Service {http://teiid.org}BookXMLDBWS from WSDL: WEB-INF/wsdl/BookXMLDBWS.wsdl

                15:44:14,103 INFO  [org.apache.cxf.endpoint.ServerImpl] (MSC service thread 1-6) Setting the server's publish address to be http://localhost:8080/BookXMLDBWS/BooksDB_books_publishers

                15:44:14,121 INFO  [org.jboss.wsf.stack.cxf.deployment.WSDLFilePublisher] (MSC service thread 1-6) WSDL published to: file:/D:/Servers/jboss-as-7.1.1-TEIID8.1/standalone/data/wsdl/BookXMLDBWS.war/BookXMLDBWS.wsdl

                15:44:14,130 INFO  [org.jboss.as.webservices] (MSC service thread 1-3) JBAS015539: Starting service jboss.ws.port-component-link

                • 5. Re: TEIID31100 Parsing error: Encountered "null"
                  luca gioppo Novice

                  OK

                  Found the wsdl place I looked at the admin consolle for it.

                   

                  now I'm sending soap requests for authors:

                  CREATE VIRTUAL PROCEDURE

                  BEGIN

                      DECLARE string VARIABLES.IN_AUTHOR_ID;

                      VARIABLES.IN_AUTHOR_ID = xPathValue(BooksDB_WS.BooksDB_books_authors.getbooks_authors.books_authors_InputMsg, '/*:books_authors_Input/*:AUTHOR_ID');

                      SELECT * FROM BooksDB_Output_View.books_authors_OutputView WHERE BooksDB_Output_View.books_authors_OutputView.books_authors_Output.books_authors_Output_Instance.AUTHOR_ID = convert(VARIABLES.IN_AUTHOR_ID, integer);

                  END

                   

                  <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:book="http://www.metamatrix.com/books_authors_Input">

                     <soapenv:Header/>

                     <soapenv:Body>

                        <book:books_authors_Input>

                           <!--Optional:-->

                           <AUTHOR_ID>1</AUTHOR_ID>

                        </book:books_authors_Input>

                     </soapenv:Body>

                  </soapenv:Envelope>

                   

                  and getting:

                  <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

                     <soap:Body>

                        <soap:Fault>

                           <faultcode>soap:Server</faultcode>

                           <faultstring>TEIID30352 BOOKSDB_WS.BOOKSDB_BOOKS_AUTHORS.GETBOOKS_AUTHORS does not exist.</faultstring>

                        </soap:Fault>

                     </soap:Body>

                  </soap:Envelope>

                   

                  Or for just getting books

                  CREATE VIRTUAL PROCEDURE

                  BEGIN

                      DECLARE string VARIABLES.IN_exampleVar;

                      VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');

                      SELECT * FROM BooksDB_Output_View.books_books_OutputView;

                  END

                   

                  <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

                     <soapenv:Header/>

                     <soapenv:Body/>

                  </soapenv:Envelope>

                  result:

                  <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

                     <soap:Body>

                        <soap:Fault>

                           <faultcode>soap:Client</faultcode>

                           <faultstring>TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                  Was expecting one of:

                      "instead" ...

                      "enabled" ...

                      "disabled" ...

                      "view" ...

                      "key" ...

                      "serial" ...

                      "textagg" ...

                      "count" ...

                      "row_number" ...

                      "rank" ...

                      ...</faultstring>

                        </soap:Fault>

                     </soap:Body>

                  </soap:Envelope>

                  • 6. Re: TEIID31100 Parsing error: Encountered "null"
                    Ramesh Reddy Master

                    Did Designer validate correctly and you are having issues at runtime? if you want you can directly execute the web service procedures directly from Teiid Designer against Teiid 7.x server using the Data tools. Once you think all the SQL is correct,  then fix the dependencies and deploy to a Teiid 8.x server and use SOAP-UI

                     

                    Ramesh..

                    • 7. Re: TEIID31100 Parsing error: Encountered "null"
                      luca gioppo Novice

                      Sorry folks it seems I'm really overlooking things in these days, maybe updating the VDB after adding the web services views and creating the WS could be usefull.

                       

                      OK, now the example runs correctly to the end.

                      Luca

                      • 8. Re: TEIID31100 Parsing error: Encountered "null"
                        luca gioppo Novice

                        OK  ... just half success:

                        This works:

                        CREATE VIRTUAL PROCEDURE

                        BEGIN

                            DECLARE string VARIABLES.IN_AUTHOR_ID;

                            VARIABLES.IN_AUTHOR_ID = xPathValue(BooksDB_WS.BooksDB_books_authors.getbooks_authors.books_authors_InputMsg, '/*:books_authors_Input/*:AUTHOR_ID');

                            SELECT * FROM BooksDB_Output_View.books_authors_OutputView WHERE BooksDB_Output_View.books_authors_OutputView.books_authors_Output.books_authors_Output_Instance.AUTHOR_ID = convert(VARIABLES.IN_AUTHOR_ID, integer);

                        END

                         

                        The SELECT transformation is valid and fully reconciled

                         

                        And calling with:

                        <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:book="http://www.metamatrix.com/books_authors_Input">

                           <soapenv:Header/>

                           <soapenv:Body>

                              <book:books_authors_Input>

                                 <!--Optional:-->

                                 <AUTHOR_ID>1</AUTHOR_ID>

                              </book:books_authors_Input>

                           </soapenv:Body>

                        </soapenv:Envelope>

                         

                        Returns:

                        <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

                           <soap:Body>

                              <books_authors_Output:books_authors_Output xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:books_authors_Output="http://www.metamatrix.com/books_authors_Output" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

                                 <books_authors_Output_Instance>

                                    <AUTHOR_ID>1</AUTHOR_ID>

                                    <FIRSTNAME>Elfriede</FIRSTNAME>

                                    <LASTNAME>Dustin</LASTNAME>

                                    <MIDDLEINIT xsi:nil="true"/>

                                 </books_authors_Output_Instance>

                              </books_authors_Output:books_authors_Output>

                           </soap:Body>

                        </soap:Envelope>

                         

                        Now this one doesn't work:

                        CREATE VIRTUAL PROCEDURE

                        BEGIN

                            DECLARE string VARIABLES.IN_exampleVar;

                            VARIABLES.IN_exampleVar = xPathValue(null, '//*[local-name()="exampleName"]');

                            SELECT * FROM BooksDB_Output_View.books_books_OutputView;

                        END

                         

                        The SELECT transformation is valid and fully reconciled

                         

                        Calling with:

                        <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/">

                           <soapenv:Header/>

                           <soapenv:Body/>

                        </soapenv:Envelope>

                         

                        returns:

                        <soap:Envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/">

                           <soap:Body>

                              <soap:Fault>

                                 <faultcode>soap:Client</faultcode>

                                 <faultstring>TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...</faultstring>

                              </soap:Fault>

                           </soap:Body>

                        </soap:Envelope>

                         

                        And the server log is:

                        10:10:57,834 DEBUG [org.teiid.PROCESSOR] (http--127.0.0.1-8080-1) Request Thread sIWlU+A04mkn.4 with state NEW

                        10:10:57,836 DEBUG [org.teiid.PROCESSOR] (http--127.0.0.1-8080-1) sIWlU+A04mkn.4 Non-cachable command.

                        10:10:57,837 DEBUG [org.teiid.PROCESSOR] (http--127.0.0.1-8080-1) sIWlU+A04mkn.4 executing prepared call ();

                        10:10:57,840 DEBUG [org.teiid.PROCESSOR] (http--127.0.0.1-8080-1) Request Thread sIWlU+A04mkn.4 - error occurred: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                           

                            at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:204)

                            at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:158)

                            at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:134)

                            at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:304)

                            at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:380)

                            at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:155)

                            at org.teiid.dqp.internal.process.Request.processRequest(Request.java:453)

                            at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:532)

                            at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:280)

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

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

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

                            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

                            at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.1.0.Final.jar:8.1.0.Final]

                            at org.teiid.jboss.TransportService$2.invoke(TransportService.java:205)

                            at $Proxy18.executeRequest(Unknown Source)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

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

                            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

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

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

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

                            at $Proxy18.executeRequest(Unknown Source)    at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)

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

                            at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:192)

                            at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

                            at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:124) [classes:]

                            at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

                            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

                            at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

                            at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                            at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                            at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                            at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                            at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                            at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                            at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:108)

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                            at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                            at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                            at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

                         

                        10:10:57,938 WARN  [org.teiid.PROCESSOR] (http--127.0.0.1-8080-1) TEIID30020 Processing exception 'TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                            ' for request sIWlU+A04mkn.4.  Exception type org.teiid.api.exception.query.QueryParserException thrown from org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:204). Enable more detailed logging to see the entire stacktrace.

                        10:10:57,953 DEBUG [org.teiid.PROCESSOR] (http--127.0.0.1-8080-1) Sending error to client sIWlU+A04mkn.4: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                           

                            at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:204)

                            at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:158)

                            at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:134)

                            at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:304)

                            at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:380)

                            at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:155)

                            at org.teiid.dqp.internal.process.Request.processRequest(Request.java:453)

                            at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:532)

                            at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:280)

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

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

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

                            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

                            at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.1.0.Final.jar:8.1.0.Final]

                            at org.teiid.jboss.TransportService$2.invoke(TransportService.java:205)

                            at $Proxy18.executeRequest(Unknown Source)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

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

                            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

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

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

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

                            at $Proxy18.executeRequest(Unknown Source)    at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)

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

                            at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:192)

                            at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

                            at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:124) [classes:]

                            at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

                            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

                            at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

                            at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                            at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                            at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                            at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                            at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                            at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                            at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:108)

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                            at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                            at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                            at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

                         

                        10:10:58,052 GRAVE [org.teiid.soap] (http--127.0.0.1-8080-1) Exception in executeDataservice: {0}: java.lang.Throwable: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                           

                            at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:194) [classes:]

                            at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

                            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

                            at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

                            at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                            at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                            at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                            at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                            at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                            at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                            at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:108)

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                            at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                            at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                            at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

                        Caused by: org.teiid.jdbc.TeiidSQLException: TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                           

                            at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

                            at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

                            at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:656)

                            at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

                            at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:512)

                            at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)

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

                            at org.teiid.jdbc.PreparedStatementImpl.execute(PreparedStatementImpl.java:192)

                            at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:404)

                            at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:124) [classes:]

                            ... 41 more

                        Caused by: org.teiid.api.exception.query.QueryParserException: TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                           

                            at org.teiid.query.parser.QueryParser.convertParserException(QueryParser.java:204)

                            at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:158)

                            at org.teiid.query.parser.QueryParser.parseCommand(QueryParser.java:134)

                            at org.teiid.dqp.internal.process.Request.parseCommand(Request.java:304)

                            at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:380)

                            at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:155)

                            at org.teiid.dqp.internal.process.Request.processRequest(Request.java:453)

                            at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:532)

                            at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:280)

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

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

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

                            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

                            at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.1.0.Final.jar:8.1.0.Final]

                            at org.teiid.jboss.TransportService$2.invoke(TransportService.java:205)

                            at $Proxy18.executeRequest(Unknown Source)    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

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

                            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

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

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

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

                            at $Proxy18.executeRequest(Unknown Source)    at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:631)

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

                            ... 44 more

                         

                        10:10:58,238 FINE  [org.teiid.jdbc] (http--127.0.0.1-8080-1) Statement closed successfully.

                        10:10:58,240 ERROR [org.jboss.ws.common.invocation.InvocationHandlerJAXWS] (http--127.0.0.1-8080-1) Method invocation failed with exception: null: java.lang.reflect.InvocationTargetException

                            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

                            at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

                            at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                            at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                            at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                            at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                            at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                            at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                            at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:108)

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                            at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                            at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                            at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

                        Caused by: java.lang.RuntimeException: javax.xml.ws.soap.SOAPFaultException: TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                           

                            at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:318) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

                            ... 38 more

                        Caused by: javax.xml.ws.soap.SOAPFaultException: TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                           

                            at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248) [classes:]

                            at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:201) [classes:]

                            at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                            ... 40 more

                         

                        10:10:58,353 AVVERTENZA [org.apache.cxf.phase.PhaseInterceptorChain] (http--127.0.0.1-8080-1) Application {http://teiid.org}BookXMLDBWS has thrown exception, unwinding now: org.apache.cxf.binding.soap.SoapFault: TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                           

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker.createFault(JBossWSInvoker.java:237)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:201)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker.invoke(JBossWSInvoker.java:127)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:58)

                            at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:441) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_35]

                            at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_35]

                            at org.apache.cxf.workqueue.SynchronousExecutor.execute(SynchronousExecutor.java:37)

                            at org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:106)

                            at org.apache.cxf.phase.PhaseInterceptorChain.doIntercept(PhaseInterceptorChain.java:263)

                            at org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121)

                            at org.apache.cxf.transport.http.AbstractHTTPDestination.invoke(AbstractHTTPDestination.java:207)

                            at org.jboss.wsf.stack.cxf.RequestHandlerImpl.handleHttpRequest(RequestHandlerImpl.java:91)

                            at org.jboss.wsf.stack.cxf.transport.ServletHelper.callRequestHandler(ServletHelper.java:169)

                            at org.jboss.wsf.stack.cxf.CXFServletExt.invoke(CXFServletExt.java:87)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:185)

                            at org.apache.cxf.transport.servlet.AbstractHTTPServlet.doPost(AbstractHTTPServlet.java:108)

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:754) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.jboss.wsf.stack.cxf.CXFServletExt.service(CXFServletExt.java:135)

                            at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140) [jbossws-spi-2.0.3.GA.jar:2.0.3.GA]

                            at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.0.Final.jar:1.0.0.Final]

                            at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:329) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:248) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:275) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:161) [jbossweb-7.0.13.Final.jar:]

                            at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:153) [jboss-as-web-7.1.1.Final.jar:7.1.1.Final]

                            at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:155) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:368) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:877) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:671) [jbossweb-7.0.13.Final.jar:]

                            at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:930) [jbossweb-7.0.13.Final.jar:]

                            at java.lang.Thread.run(Thread.java:662) [rt.jar:1.6.0_35]

                        Caused by: javax.xml.ws.soap.SOAPFaultException: TEIID31100 Parsing error: Encountered "(" at line 1, column 6.

                        Was expecting one of:

                            "instead" ...

                            "enabled" ...

                            "disabled" ...

                            "view" ...

                            "key" ...

                            "serial" ...

                            "textagg" ...

                            "count" ...

                            "row_number" ...

                            "rank" ...

                            ...

                           

                            at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248) [classes:]

                            at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:201) [classes:]

                            at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:22) [classes:]

                            at org.teiid.soap.provider.BooksDB_books_books.invoke(BooksDB_books_books.java:15) [classes:]

                            at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_35]

                            at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_35]

                            at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_35]

                            at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_35]

                            at org.jboss.ws.common.invocation.AbstractInvocationHandlerJSE.invoke(AbstractInvocationHandlerJSE.java:111)

                            at org.jboss.wsf.stack.cxf.JBossWSInvoker._invokeInternal(JBossWSInvoker.java:181)

                            ... 32 more

                         

                         

                        Do not understand where is "(" at line 1, column 6. that create the problem

                        • 10. Re: TEIID31100 Parsing error: Encountered "null"
                          Ramesh Reddy Master

                          is it possible for you to attach a strip down version of your VDB that exibits the issue?

                          • 11. Re: TEIID31100 Parsing error: Encountered "null"
                            luca gioppo Novice

                            Here are VDB and WAR (should be usefull).

                            Thanks

                            Luca

                            • 12. Re: TEIID31100 Parsing error: Encountered "null"
                              Ramesh Reddy Master

                              I do not see same error when testing against latest 8.2 trunk version.

                              • 13. Re: TEIID31100 Parsing error: Encountered "null"
                                luca gioppo Novice

                                But can you reproduce the error in AS 7.1.1 TEIID 8.1?

                                Luca

                                • 14. Re: TEIID31100 Parsing error: Encountered "null"
                                  Ramesh Reddy Master

                                  In both I got exception like below; was not sure what was about

                                   

                                  Caused by: javax.xml.ws.soap.SOAPFaultException: BookXMLDB_ws -- service jboss.naming.context.java.BookXMLDB_ws
                                      at org.teiid.soap.provider.TeiidWSProvider.createSOAPFaultMessage(TeiidWSProvider.java:248) [classes:]
                                      at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:215) [classes:]
                                      at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:316) [classes:]
                                  

                                   

                                  Ramesh..

                                  1 2 Previous Next