7 Replies Latest reply on Jan 18, 2018 12:51 AM by kevinyjn kevinyjn

    How can I deploy VDB for a SOAP interface in TeiidDesigner?

    kevinyjn kevinyjn Newbie

      The option of [Generate SOAP War] were disabled when I executing Modeling->Generate SOAP War on a vdb. How can I enable this option?

        • 3. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?
          kevinyjn kevinyjn Newbie

          Sorry for asking you again, when I deployed the SOAP war from vdb, the soap interface was able to be accessed, but it returns error bellow every time, would you please give me some suggestions?

           

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

             <soap:Body>

                <soap:Fault>

                   <faultcode>soap:Server</faultcode>

                   <faultstring>You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.getuser_info_result('&lt;?xml version="1.0" encoding="UTF-8"?>&lt;com:getUser_Input x' at line 1</faultstring>

                </soap:Fault>

             </soap:Body>

          </soap:Envelope>

          • 4. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?
            Ramesh Reddy Master

            You should first test your VDB using the any SQL Client like SquirreL and make sure there are no errors in your design. Then build the SOAP interface on it. From the error, it looks like there an error either in VDB or MySQL based procedure?

            • 5. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?
              kevinyjn kevinyjn Newbie

              Thanks for reply me, I've found that I forgot to do the [Create  VDB Data Source] operation from my test1.vdb.

              However when I create the test1.vdb jndi name as java:/test1, and deployed the vdb, it still prompts errors like 'For input string "1.0.0"' and org.teiid.designer.datasource.ui exception, the screenshot is:

              but it seams that the vdb was deployed successfully on teiid runtime server, when i test the soap interface using SoapUI, the teiid server throws the exception:

               

              09:37:22,125 WARN  [org.teiid.SECURITY] (NIO2)  TEIID40011 Processing exception 'TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.' for session null.  Exception type org.teiid.client.security.LogonException thrown from org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:154). Enable more detailed logging to see the entire stacktrace.

              09:37:22,128 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (default task-9)  IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection

                at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:336)

                at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:343)

                at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:278)

                at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:1289)

                at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:492)

                at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:627)

                at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:599)

                at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:579)

                at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:430)

                at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:737)

                at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)

                at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:67)

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:91)

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:299)

                at org.teiid.soap.provider.Application.invoke(Application.java:22)

                at org.teiid.soap.provider.Application.invoke(Application.java:15)

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

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

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

                at java.lang.reflect.Method.invoke(Method.java:498)

                at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)

                at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)

                at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:232)

                at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:69)

                at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)

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

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

                at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor$2.run(ServiceInvokerInterceptor.java:126)

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

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

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

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

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

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

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

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

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

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

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

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

                at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140)

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

                at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:86)

                at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

                at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)

                at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)

                at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)

                at io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)

                at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)

                at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)

                at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)

                at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)

                at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:72)

                at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)

                at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:282)

                at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:261)

                at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:80)

                at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:172)

                at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)

                at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:774)

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

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

                at java.lang.Thread.run(Thread.java:748)

              Caused by: org.teiid.jdbc.TeiidSQLException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

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

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

                at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66)

                at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

                at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)

                at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:312)

                ... 72 more

              Caused by: org.teiid.net.ConnectionException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

                at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:142)

                at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)

                at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316)

                at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64)

                ... 75 more

              Caused by: org.teiid.client.security.LogonException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

                at org.teiid.transport.LogonImpl.logon(LogonImpl.java:162)

                at org.teiid.transport.LogonImpl.logon(LogonImpl.java:127)

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

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

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

                at java.lang.reflect.Method.invoke(Method.java:498)

                at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87)

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

                at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:237)

                at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:223)

                at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:212)

                at org.teiid.transport.SSLAwareChannelHandler.channelRead(SSLAwareChannelHandler.java:218)

                at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

                at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

                at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)

                at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

                at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

                at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)

                at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

                at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

                at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)

                at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)

                at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)

                at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)

                at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)

                at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)

                at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)

                ... 1 more

              Caused by: javax.security.auth.login.LoginException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

                at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:154)

                at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:60)

                at org.teiid.services.SessionServiceImpl.createSession(SessionServiceImpl.java:207)

                at org.teiid.transport.LogonImpl.logon(LogonImpl.java:142)

                ... 27 more

               

              09:37:22,130 SEVERE [org.teiid.soap] (default task-9)  Exception in executeDataservice: {0}: java.lang.Throwable: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/test1

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:175)

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:299)

                at org.teiid.soap.provider.Application.invoke(Application.java:22)

                at org.teiid.soap.provider.Application.invoke(Application.java:15)

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

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

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

                at java.lang.reflect.Method.invoke(Method.java:498)

                at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)

                at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)

                at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:232)

                at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:69)

                at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)

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

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

                at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor$2.run(ServiceInvokerInterceptor.java:126)

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

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

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

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

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

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

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

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

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

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

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

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

                at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140)

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

                at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:86)

                at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

                at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)

                at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)

                at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)

                at io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)

                at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)

                at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)

                at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)

                at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)

                at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:72)

                at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)

                at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:282)

                at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:261)

                at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:80)

                at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:172)

                at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)

                at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:774)

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

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

                at java.lang.Thread.run(Thread.java:748)

              Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/test1

                at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:146)

                at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:67)

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:91)

                ... 60 more

              Caused by: javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:/test1

                at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:646)

                at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:430)

                at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:737)

                at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)

                ... 62 more

              Caused by: javax.resource.ResourceException: IJ031084: Unable to create connection

                at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:336)

                at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:343)

                at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:278)

                at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:1289)

                at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:492)

                at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:627)

                at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:599)

                at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:579)

                ... 65 more

              Caused by: org.teiid.jdbc.TeiidSQLException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

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

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

                at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:66)

                at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:107)

                at org.teiid.jdbc.TeiidDriver.connect(TeiidDriver.java:55)

                at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:312)

                ... 72 more

              Caused by: org.teiid.net.ConnectionException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

                at org.teiid.net.socket.SocketServerConnection.selectServerInstance(SocketServerConnection.java:142)

                at org.teiid.net.socket.SocketServerConnection.<init>(SocketServerConnection.java:95)

                at org.teiid.net.socket.SocketServerConnectionFactory.getConnection(SocketServerConnectionFactory.java:316)

                at org.teiid.jdbc.SocketProfile.connect(SocketProfile.java:64)

                ... 75 more

              Caused by: org.teiid.client.security.LogonException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

                at org.teiid.transport.LogonImpl.logon(LogonImpl.java:162)

                at org.teiid.transport.LogonImpl.logon(LogonImpl.java:127)

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

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

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

                at java.lang.reflect.Method.invoke(Method.java:498)

                at org.teiid.transport.ServerWorkItem.run(ServerWorkItem.java:87)

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

                at org.teiid.transport.SocketClientInstance.processMessagePacket(SocketClientInstance.java:237)

                at org.teiid.transport.SocketClientInstance.receivedMessage(SocketClientInstance.java:223)

                at org.teiid.transport.SSLAwareChannelHandler.messageReceived(SSLAwareChannelHandler.java:212)

                at org.teiid.transport.SSLAwareChannelHandler.channelRead(SSLAwareChannelHandler.java:218)

                at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

                at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

                at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)

                at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

                at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

                at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)

                at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)

                at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)

                at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)

                at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)

                at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)

                at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)

                at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)

                at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)

                at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)

                ... 1 more

              Caused by: javax.security.auth.login.LoginException: TEIID50072 The username "anonymous" and/or password and/or payload token could not be authenticated by security domain teiid-security.

                at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:154)

                at org.teiid.jboss.JBossSecurityHelper.authenticate(JBossSecurityHelper.java:60)

                at org.teiid.services.SessionServiceImpl.createSession(SessionServiceImpl.java:207)

                at org.teiid.transport.LogonImpl.logon(LogonImpl.java:142)

                ... 27 more

               

              09:37:22,133 WARNING [org.apache.cxf.phase.PhaseInterceptorChain] (default task-9)  Application {TestService}test1#{TestService}DataQuery has thrown exception, unwinding now: org.apache.cxf.interceptor.Fault

                at org.apache.cxf.service.invoker.AbstractInvoker.createFault(AbstractInvoker.java:163)

                at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.createFault(AbstractJAXWSMethodInvoker.java:267)

                at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:129)

                at org.apache.cxf.jaxws.AbstractJAXWSMethodInvoker.invoke(AbstractJAXWSMethodInvoker.java:232)

                at org.apache.cxf.jaxws.JAXWSMethodInvoker.invoke(JAXWSMethodInvoker.java:69)

                at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:75)

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

                at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

                at java.util.concurrent.FutureTask.run(FutureTask.java:266)

                at org.apache.cxf.interceptor.ServiceInvokerInterceptor$2.run(ServiceInvokerInterceptor.java:126)

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

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

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

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

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

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

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

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

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

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

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

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

                at org.jboss.wsf.spi.deployment.WSFServlet.service(WSFServlet.java:140)

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

                at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:86)

                at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

                at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)

                at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131)

                at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)

                at io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:51)

                at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)

                at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)

                at io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:56)

                at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:58)

                at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:72)

                at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)

                at io.undertow.security.handlers.SecurityInitialHandler.handleRequest(SecurityInitialHandler.java:76)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)

                at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:282)

                at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:261)

                at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:80)

                at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:172)

                at io.undertow.server.Connectors.executeRootHandler(Connectors.java:199)

                at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:774)

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

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

                at java.lang.Thread.run(Thread.java:748)

              Caused by: java.lang.NullPointerException

                at org.teiid.soap.provider.TeiidWSProvider$SQLStates.belongsToClass(TeiidWSProvider.java:410)

                at org.teiid.soap.provider.TeiidWSProvider$SQLStates.isUsageErrorState(TeiidWSProvider.java:406)

                at org.teiid.soap.provider.TeiidWSProvider.execute(TeiidWSProvider.java:178)

                at org.teiid.soap.provider.TeiidWSProvider.invoke(TeiidWSProvider.java:299)

                at org.teiid.soap.provider.Application.invoke(Application.java:22)

                at org.teiid.soap.provider.Application.invoke(Application.java:15)

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

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

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

                at java.lang.reflect.Method.invoke(Method.java:498)

                at org.apache.cxf.service.invoker.AbstractInvoker.performInvocation(AbstractInvoker.java:181)

                at org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97)

                ... 51 more

               

              I'm not sure what's wrong with my operation.

              • 6. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?
                Ted Jones Master

                When you created the VDB data source in Designer, did you check the passthrough authentication checkbox? If not, give that a try.

                • 7. Re: How can I deploy VDB for a SOAP interface in TeiidDesigner?
                  kevinyjn kevinyjn Newbie

                  Thank you, Ted, I found that I was forget to create jndi name for vdb.