3 Replies Latest reply on Jun 27, 2008 11:58 AM by 666705

    Transaction timeout when two system communicate by web service.

    666705
      Currently, our application run under WLS 10, and exchange data with another system build on WLS 10 also by web service.
                These two system both set global transaction timeout through Console: Server-->Configuration-->JTA-->Timeout Seconds, set number is 1800s.
                
                Long time operation within one system is ok, never meet tracation timeout exception. But, when one system call another system via web service, always meet below exception(same operation run under wls 8.1 is ok):
                
                15-02-2008@17:35:56 ERROR leave : [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [CTLeaveWebService@PSA] [B2E_CTLeave.Get_Leave_Info] Exception Occured, Failure creating new instance of RowMapper, org.apache.beehive.controls.api.ControlException: RowToObjectMapper: SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 30 seconds
                BEA1-067F39AED8C5E04484B3
                at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1419)
                at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1331)
                at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:189)
                at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:64)
                at weblogic.jdbc.wrapper.ResultSetMetaData.preInvocationHandler(ResultSetMetaData.java:37)
                at weblogic.jdbc.wrapper.ResultSetMetaData_oracle_jdbc_driver_OracleResultSetMetaData.getColumnCount(Unknown Source)
                at org.apache.beehive.controls.system.jdbc.RowToObjectMapper.<init>(RowToObjectMapper.java:63)
                at sun.reflect.GeneratedConstructorAccessor136.newInstance(Unknown Source)
                at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
                at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
                at org.apache.beehive.controls.system.jdbc.RowMapperFactory.getMapper(RowMapperFactory.java:160)
                at org.apache.beehive.controls.system.jdbc.RowMapperFactory.getRowMapper(RowMapperFactory.java:85)
                at org.apache.beehive.controls.system.jdbc.DefaultObjectResultSetMapper.arrayFromResultSet(DefaultObjectResultSetMapper.java:93)
                at org.apache.beehive.controls.system.jdbc.DefaultObjectResultSetMapper.mapToResultType(DefaultObjectResultSetMapper.java:61)
                at org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:370)
                at org.apache.beehive.controls.system.jdbc.JdbcControlImpl.invoke(JdbcControlImpl.java:228)
                at com.psa.citos.rms.leave.services.resouces.StaffLeaveDBBean.getLeaveDetailsByLvEmpIdStDtEndDtStatusInArray(StaffLeaveDBBean.java:198)
                at com.psa.citos.rms.leave.services.bizlogic.StaffLeaveServiceImpl.getLeaveDetailsByLvEmpIdStDtEndDt(StaffLeaveServiceImpl.java:276)
                at com.psa.citos.rms.leave.services.bizlogic.StaffLeaveServiceBean.getLeaveDetailsByLvEmpIdStDtEndDt(StaffLeaveServiceBean.java:1112)
                at com.psa.citos.rms.leave.services.bizlogic.LeaveServiceImpl.getLeaveDetailsByLvEmpIdStDtEndDt(LeaveServiceImpl.java:337)
                at com.psa.citos.rms.leave.services.bizlogic.LeaveServiceBean.getLeaveDetailsByLvEmpIdStDtEndDt(LeaveServiceBean.java:596)
                at com.psa.citos.rms.leave.facades.WebServiceFacadesImpl.getStaffLeaveInfoForRoster(WebServiceFacadesImpl.java:254)
                at com.psa.citos.rms.leave.facades.WebServiceFacadesBean.getStaffLeaveInfoForRoster(WebServiceFacadesBean.java:250)
                at com.psa.citos.rms.leave.webservice.CTLeaveWebService.getLeaveInfo(Unknown Source)
                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                at java.lang.reflect.Method.invoke(Method.java:585)
                at weblogic.wsee.component.pojo.JavaClassComponent.invoke(JavaClassComponent.java:99)
                at weblogic.wsee.ws.dispatch.server.ComponentHandler.handleRequest(ComponentHandler.java:64)
                at weblogic.wsee.handler.HandlerIterator.handleRequest(HandlerIterator.java:123)
                at weblogic.wsee.ws.dispatch.server.ServerDispatcher.dispatch(ServerDispatcher.java:85)
                at weblogic.wsee.ws.WsSkel.invoke(WsSkel.java:80)
                at weblogic.wsee.server.servlet.SoapProcessor.handlePost(SoapProcessor.java:66)
                at weblogic.wsee.server.servlet.SoapProcessor.process(SoapProcessor.java:44)
                at weblogic.wsee.server.servlet.BaseWSServlet$AuthorizedInvoke.run(BaseWSServlet.java:257)
                at weblogic.wsee.server.servlet.BaseWSServlet.service(BaseWSServlet.java:156)
                at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
                at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
                at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
                at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
                at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3392)
                at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                at weblogic.security.service.SecurityManager.runAs(Unknown Source)
                at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
                at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
                at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
                at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
                at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
                [java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 30 seconds
                
                Data Sourse config:
                URL: jdbc:oracle:thin:@xxxxxx:1521:xxxxxx
                Driver Class Name: oracle.jdbc.xa.client.OracleXADataSource
                
                
                Can help to advise what this exception cause and how to resolve?
                
                thanks and best regards.
                
                --
                Edited by rendlut at 02/17/2008 7:29 PM
                
                --
                Edited by rendlut at 02/17/2008 7:38 PM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
        • 1. Re: Transaction timeout when two system communicate by web service.
          3004
          r c wrote:
                    
                    > Currently, our application run under WLS 10, and exchange data with another system build on WLS 10 also by web service.
                    > These two system both set global transaction timeout through Console: Server-->Configuration-->JTA-->Timeout Seconds, set number is 1800s.
                    >
                    > Long time operation within one system is ok, never meet tracation timeout exception. But, when one system call another system via web service, always meet below exception(same operation run under wls 8.1 is ok):
                    >
                    > 15-02-2008@17:35:56 ERROR leave : [[ACTIVE] ExecuteThread: '6' for queue: 'weblogic.kernel.Default (self-tuning)'] [CTLeaveWebService@PSA] [B2E_CTLeave.Get_Leave_Info] Exception Occured, Failure creating new instance of RowMapper, org.apache.beehive.controls.api.ControlException: RowToObjectMapper: SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 30 seconds
                    > BEA1-067F39AED8C5E04484B3
                    > at weblogic.jdbc.jta.DataSource.enlist(DataSource.java:1419)
                    > at weblogic.jdbc.jta.DataSource.refreshXAConnAndEnlist(DataSource.java:1331)
                    > at weblogic.jdbc.wrapper.JTAConnection.getXAConn(JTAConnection.java:189)
                    > at weblogic.jdbc.wrapper.JTAConnection.checkConnection(JTAConnection.java:64)
                    > at weblogic.jdbc.wrapper.ResultSetMetaData.preInvocationHandler(ResultSetMetaData.java:37)
                    > at weblogic.jdbc.wrapper.ResultSetMetaData_oracle_jdbc_driver_OracleResultSetMetaData.getColumnCount(Unknown Source)
                    > at org.apache.beehive.controls.system.jdbc.RowToObjectMapper.<init>(RowToObjectMapper.java:63)
                    > at sun.reflect.GeneratedConstructorAccessor136.newInstance(Unknown Source)
                    > at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
                    > at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
                    > at org.apache.beehive.controls.system.jdbc.RowMapperFactory.getMapper(RowMapperFactory.java:160)
                    > at org.apache.beehive.controls.system.jdbc.RowMapperFactory.getRowMapper(RowMapperFactory.java:85)
                    > at org.apache.beehive.controls.system.jdbc.DefaultObjectResultSetMapper.arrayFromResultSet(DefaultObjectResultSetMapper.java:93)
                    > at org.apache.beehive.controls.system.jdbc.DefaultObjectResultSetMapper.mapToResultType(DefaultObjectResultSetMapper.java:61)
                    > at org.apache.beehive.controls.system.jdbc.JdbcControlImpl.execPreparedStatement(JdbcControlImpl.java:370)
                    > at org.apache.beehive.controls.system.jdbc.JdbcControlImpl.invoke(JdbcControlImpl.java:228)
                    > at com.psa.citos.rms.leave.services.resouces.StaffLeaveDBBean.getLeaveDetailsByLvEmpIdStDtEndDtStatusInArray(StaffLeaveDBBean.java:198)
                    > at com.psa.citos.rms.leave.services.bizlogic.StaffLeaveServiceImpl.getLeaveDetailsByLvEmpIdStDtEndDt(StaffLeaveServiceImpl.java:276)
                    > at com.psa.citos.rms.leave.services.bizlogic.StaffLeaveServiceBean.getLeaveDetailsByLvEmpIdStDtEndDt(StaffLeaveServiceBean.java:1112)
                    > at com.psa.citos.rms.leave.services.bizlogic.LeaveServiceImpl.getLeaveDetailsByLvEmpIdStDtEndDt(LeaveServiceImpl.java:337)
                    > at com.psa.citos.rms.leave.services.bizlogic.LeaveServiceBean.getLeaveDetailsByLvEmpIdStDtEndDt(LeaveServiceBean.java:596)
                    > at com.psa.citos.rms.leave.facades.WebServiceFacadesImpl.getStaffLeaveInfoForRoster(WebServiceFacadesImpl.java:254)
                    > at com.psa.citos.rms.leave.facades.WebServiceFacadesBean.getStaffLeaveInfoForRoster(WebServiceFacadesBean.java:250)
                    > at com.psa.citos.rms.leave.webservice.CTLeaveWebService.getLeaveInfo(Unknown Source)
                    > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                    > at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                    > at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                    > at java.lang.reflect.Method.invoke(Method.java:585)
                    > at weblogic.wsee.component.pojo.JavaClassComponent.invoke(JavaClassComponent.java:99)
                    > at weblogic.wsee.ws.dispatch.server.ComponentHandler.handleRequest(ComponentHandler.java:64)
                    > at weblogic.wsee.handler.HandlerIterator.handleRequest(HandlerIterator.java:123)
                    > at weblogic.wsee.ws.dispatch.server.ServerDispatcher.dispatch(ServerDispatcher.java:85)
                    > at weblogic.wsee.ws.WsSkel.invoke(WsSkel.java:80)
                    > at weblogic.wsee.server.servlet.SoapProcessor.handlePost(SoapProcessor.java:66)
                    > at weblogic.wsee.server.servlet.SoapProcessor.process(SoapProcessor.java:44)
                    > at weblogic.wsee.server.servlet.BaseWSServlet$AuthorizedInvoke.run(BaseWSServlet.java:257)
                    > at weblogic.wsee.server.servlet.BaseWSServlet.service(BaseWSServlet.java:156)
                    > at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                    > at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:226)
                    > at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:124)
                    > at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:283)
                    > at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:175)
                    > at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3392)
                    > at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
                    > at weblogic.security.service.SecurityManager.runAs(Unknown Source)
                    > at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2140)
                    > at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2046)
                    > at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1366)
                    > at weblogic.work.ExecuteThread.execute(ExecuteThread.java:200)
                    > at weblogic.work.ExecuteThread.run(ExecuteThread.java:172)
                    > [java.sql.SQLException: Unexpected exception while enlisting XAConnection java.sql.SQLException: Transaction rolled back: Transaction timed out after 30 seconds
                    >
                    > Data Sourse config:
                    > URL: jdbc:oracle:thin:@xxxxxx:1521:xxxxxx
                    > Driver Class Name: oracle.jdbc.xa.client.OracleXADataSource
                    >
                    >
                    > Can help to advise what this exception cause and how to resolve?
                    >
                    > thanks and best regards.
                    >
                    > --
                    > Edited by rendlut at 02/17/2008 7:29 PM
                    >
                    > --
                    > Edited by rendlut at 02/17/2008 7:38 PM
                    
                    
                    
                    In the console, you can set the JTA timeout to
                    something more appropriate for your needs than
                    the default 30 seconds.
                    Joe                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           
          • 2. Re: Transaction timeout when two system communicate by web service.
            666705
            Hi,
                      Suppose i am calling a web service through the studio, so is there any way to set to timeout for the web service call through the studio.
            • 3. Re: Transaction timeout when two system communicate by web service.
              666705
              Hi Brijesh
                        
                        I am Facing same issue. We are currently migrating our wes services from weblogic 8.1 to 10.1. While doing testing on 10.1 when I called this web service I got following exception whereas it was working fine on 8.1.
                        
                        weblogic.transaction.RollbackException: Transaction timed out after 30 seconds
                        BEA1-00009BD3D1343057A4BDTransaction timed out after 30 seconds
                        BEA1-00009BD3D1343057A4BD
                        
                        I have increased JTA time out period in Server console and even I have added one timeout entry in wlw-config.xml but all in vain. Still it is getting time out in 30 seconds.