6 Replies Latest reply on Jan 22, 2008 9:39 AM by 807603

    XA Transaction error while starting WSAD

    807603
      Hi,
      I am facing a problem while starting WSAD. It is giving below error:
      [1/21/08 12:48:45:029 IST] 6528e6db RegisteredRes E WTRN0078E: An attempt by the transaction manager to call start on a transactional resource has resulted in an error. The error code was XAER_RMERR. The exception stack trace follows: javax.transaction.xa.XAException: [IBM][SQLServer JDBC Driver][SQLServer]Can't find an idle worker thread for XaStart
           at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.executeXaRpc(Unknown Source)
           at com.ibm.websphere.jdbcx.sqlserver.SQLServerImplXAResource.start(Unknown Source)
           at com.ibm.websphere.jdbcx.base.BaseXAResource.start(Unknown Source)
           at com.ibm.ws.rsadapter.spi.WSRdbXaResourceImpl.start(WSRdbXaResourceImpl.java:927)
           at com.ibm.ejs.j2c.XATransactionWrapper.start(XATransactionWrapper.java:1267)
           at com.ibm.ws.Transaction.JTA.JTAResourceBase.start(JTAResourceBase.java:164)
           at com.ibm.ws.Transaction.JTA.RegisteredResources.startRes(RegisteredResources.java:390)
           at com.ibm.ws.Transaction.JTA.TransactionImpl.enlistResource(TransactionImpl.java:1903)
           at com.ibm.ws.Transaction.JTA.TranManagerSet.enlist(TranManagerSet.java:494)
           at com.ibm.ejs.j2c.XATransactionWrapper.enlist(XATransactionWrapper.java:602)
           at com.ibm.ejs.j2c.ConnectionEventListener.interactionPending(ConnectionEventListener.java:745)
           at com.ibm.ws.rsadapter.spi.WSRdbManagedConnectionImpl.processInteractionPendingEvent(WSRdbManagedConnectionImpl.java:1456)
           at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.beginTransactionIfNecessary(WSJdbcConnection.java:349)
           at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1453)
           at com.ibm.ws.rsadapter.jdbc.WSJdbcConnection.prepareStatement(WSJdbcConnection.java:1424)
           at com.freedomgroup.common.server.db.LeakDetectingConnection.prepareStatement(LeakDetectingConnection.java:298)
           at com.freedomgroup.policystar.dax.base.TFGPSSysAdminStatementCache.getStatementSelAllDesktopFields(TFGPSSysAdminStatementCache.java:25372)
           at com.freedomgroup.policystar.service.sysadmin.TFGPSSysAdminDataServiceBean.getDesktopFieldSecurityTotalDO(TFGPSSysAdminDataServiceBean.java:477)
           at com.freedomgroup.policystar.service.sysadmin.EJSLocalStatelessTFGPSSysAdminDataService_a3688495.getDesktopFieldSecurityTotalDO(EJSLocalStatelessTFGPSSysAdminDataService_a3688495.java:2487)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java(Compiled Code))
           at java.lang.reflect.Method.invoke(Method.java(Compiled Code))
           at com.freedomgroup.common.request.TFGRequest.processRequest(TFGRequest.java:214)
           at com.freedomgroup.common.servlets.TFGHttpServlet.serviceOctet(TFGHttpServlet.java:287)
           at com.freedomgroup.common.servlets.TFGHttpServlet.service(TFGHttpServlet.java:185)
           at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java:110)
           at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java:174)
           at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java:313)
           at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java:116)
           at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java:283)
           at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java:42)
           at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java:40)
           at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java:983)
           at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:564)
           at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:200)
           at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:119)
           at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:276)
           at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
           at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
           at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
           at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
           at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
           at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:618)
           at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:443)
           at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:672)