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

[gioppoluca]

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

[van.halbert]

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.

[shawkins]

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

[gioppoluca]

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

[gioppoluca]

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

[gioppoluca]

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>

[rareddy]

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..

[gioppoluca]

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

[gioppoluca]

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

[gioppoluca]

Any hint??

[rareddy]

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

[gioppoluca]

Here are VDB and WAR (should be usefull).

Thanks

Luca

[rareddy]

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

[gioppoluca]

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

Luca

[rareddy]

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..