aspose file tools*
The moose likes IDEs, Version Control and other tools and the fly likes Transaction has timed out after 1,200 seconds Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of Spring in Action this week in the Spring forum!
JavaRanch » Java Forums » Engineering » IDEs, Version Control and other tools
Bookmark "Transaction has timed out after 1,200 seconds" Watch "Transaction has timed out after 1,200 seconds" New topic
Author

Transaction has timed out after 1,200 seconds

satya sompalle
Greenhorn

Joined: Aug 28, 2008
Posts: 6
Hi,
I am getting following error? Can anyone please advice me.
[8/28/08 0:01:58:957 CEST] 4db83a33 WebGroup E SRVE0026E: [Servlet Error]-[RASUploader]: com.ibm.ws.webcontainer.webapp.WebAppErrorReport: Error reported: 500
at com.ibm.ws.webcontainer.srt.SRTServletResponseContext.sendError(SRTServletResponseContext.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.SRTServletResponse.sendError(SRTServletResponse.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.srt.SRTServletResponse.sendError(SRTServletResponse.java(Compiled Code))
at com.shell.seop.cpfe.rasupload.RASUploader.performTask(RASUploader.java(Compiled Code))
at com.shell.seop.cpfe.rasupload.RASUploader.doPost(RASUploader.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictServletInstance.doService(StrictServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.IdleServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstance.service(ServletInstance.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ValidServletReferenceState.dispatch(ValidServletReferenceState.java(Compiled Code))
at com.ibm.ws.webcontainer.servlet.ServletInstanceReference.dispatch(ServletInstanceReference.java(Inlined Compiled Code))
at com.ibm.ws.webcontainer.filter.WebAppFilterChain.doFilter(WebAppFilterChain.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.handleWebAppDispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java(Compiled Code))

8/28/08 0:47:14:679 CEST] 1ccf7a20 CoordinatorIm I WTRN0066W: Transaction (1630688) 0001bba9:00000001d8e1e01491c11734522550e8d483a91981e12f450de38b41[] has timed out after 1,200 seconds.
[8/28/08 0:52:00:683 CEST] 3a487a2d LocalTransact E J2CA0026E: Method addSync caught javax.transaction.RollbackException
at com.ibm.ejs.jts.jta.TransactionImpl.registerSynchronization(TransactionImpl.java(Compiled Code))
at com.ibm.ejs.jts.jta.JTSXA.registerSynchronization(JTSXA.java(Compiled Code))
at com.ibm.ejs.j2c.LocalTransactionWrapper.addSync(LocalTransactionWrapper.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.shell.seop.cpfe.util.DBConnectionHandler.getConnection(DBConnectionHandler.java(Compiled Code))
at com.shell.seop.cpfe.util.DBConnectionHandler.getConnection(DBConnectionHandler.java(Inlined Compiled Code))
at com.shell.seop.cpfe.util.QueryProcessor.doQuery(QueryProcessor.java(Compiled Code))
at com.shell.seop.cpfe.util.QueryHandler.getHistoricalCalcBookStock(QueryHandler.java(Compiled Code))
at com.shell.seop.cpfe.process.calculations.PerformCalculationsDAO.getBookStockFromHistoricalData(PerformCalculationsDAO.java(Compiled Code))
at com.shell.seop.cpfe.process.calculations.PerformCalculationsBean.performDeliveryCalculations(PerformCalculationsBean.java(Compiled Code))
at com.shell.seop.cpfe.process.calculations.PerformCalculationsBean.startCalculationProcessing(PerformCalculationsBean.java(Compiled Code))
at com.shell.seop.cpfe.process.calculations.EJSRemoteStatelessPerformCalculations_5f89915d.startCalculationProcessing(Unknown Source)(Compiled Code)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.CORBA.iiop.ClientDelegate$1.run(ClientDelegate.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy15.startCalculationProcessing(Unknown Source)(Compiled Code)
at com.shell.seop.cpfe.process.calculations._PerformCalculations_Stub.startCalculationProcessing(_PerformCalculations_Stub.java(Compiled Code))
at com.shell.seop.cpfe.process.cycle.CycleProcessBean.startCycleProcess(CycleProcessBean.java(Compiled Code))
at com.shell.seop.cpfe.process.cycle.EJSRemoteStatelessCycleProcess_2abc4da0.startCycleProcess(Unknown Source)(Compiled Code)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.CORBA.iiop.ClientDelegate$1.run(ClientDelegate.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy5.startCycleProcess(Unknown Source)(Compiled Code)
at com.shell.seop.cpfe.process.cycle._CycleProcess_Stub.startCycleProcess(_CycleProcess_Stub.java(Compiled Code))
at com.shell.seop.cpfe.bootstrap.CycleProcessThread.process(CycleProcessThread.java(Compiled Code))
at com.shell.seop.cpfe.bootstrap.CycleProcessThread.run(CycleProcessThread.java:90)
while trying to register the Resource Adapter with the Synchronization Manager for the current transaction, and threw a Exception.
[8/28/08 0:52:00:822 CEST] 3a487a2d LocalTransact E J2CA0026E: Method addSync caught javax.transaction.RollbackException
at com.ibm.ejs.jts.jta.TransactionImpl.registerSynchronization(TransactionImpl.java(Compiled Code))
at com.ibm.ejs.jts.jta.JTSXA.registerSynchronization(JTSXA.java(Compiled Code))
at com.ibm.ejs.j2c.LocalTransactionWrapper.addSync(LocalTransactionWrapper.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.initializeForUOW(ConnectionManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.involveMCInTran(ConnectionManager.java(Compiled Code))
at com.ibm.ejs.j2c.ConnectionManager.allocateConnection(ConnectionManager.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.ibm.ws.rsadapter.jdbc.WSJdbcDataSource.getConnection(WSJdbcDataSource.java(Compiled Code))
at com.shell.seop.cpfe.util.DBConnectionHandler.getConnection(DBConnectionHandler.java(Compiled Code))
at com.shell.seop.cpfe.util.DBConnectionHandler.getConnection(DBConnectionHandler.java(Inlined Compiled Code))
at com.shell.seop.cpfe.util.QueryProcessor.doQuery(QueryProcessor.java(Compiled Code))
at com.shell.seop.cpfe.util.QueryHandler.getHistoricalCalcPrevious(QueryHandler.java(Compiled Code))
at com.shell.seop.cpfe.process.calculations.PerformCalculationsDAO.getPreviousOrCurrentRecord(PerformCalculationsDAO.java(Compiled Code))
at com.shell.seop.cpfe.process.calculations.PerformCalculationsBean.startCalculationProcessing(PerformCalculationsBean.java(Compiled Code))
at com.shell.seop.cpfe.process.calculations.EJSRemoteStatelessPerformCalculations_5f89915d.startCalculationProcessing(Unknown Source)(Compiled Code)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.CORBA.iiop.ClientDelegate$1.run(ClientDelegate.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy15.startCalculationProcessing(Unknown Source)(Compiled Code)
at com.shell.seop.cpfe.process.calculations._PerformCalculations_Stub.startCalculationProcessing(_PerformCalculations_Stub.java(Compiled Code))
at com.shell.seop.cpfe.process.cycle.CycleProcessBean.startCycleProcess(CycleProcessBean.java(Compiled Code))
at com.shell.seop.cpfe.process.cycle.EJSRemoteStatelessCycleProcess_2abc4da0.startCycleProcess(Unknown Source)(Compiled Code)
at java.lang.reflect.Method.invoke(Native Method)
at com.ibm.CORBA.iiop.ClientDelegate$1.run(ClientDelegate.java(Compiled Code))
at java.security.AccessController.doPrivileged(Native Method)
at com.ibm.CORBA.iiop.ClientDelegate.invoke(ClientDelegate.java(Compiled Code))
at $Proxy5.startCycleProcess(Unknown Source)(Compiled Code)
at com.shell.seop.cpfe.process.cycle._CycleProcess_Stub.startCycleProcess(_CycleProcess_Stub.java(Compiled Code))
at com.shell.seop.cpfe.bootstrap.CycleProcessThread.process(CycleProcessThread.java(Compiled Code))
at com.shell.seop.cpfe.bootstrap.CycleProcessThread.run(CycleProcessThread.java:90)
while trying to register the Resource Adapter with the Synchronization Manager for the current transaction, and threw a Exception.
[8/28/08 0:52:00:838 CEST] 3a487a2d ExceptionUtil E CNTR0019E: Non-application exception occurred while processing method "setErrorCustomer". Exception data: com.ibm.websphere.csi.CSITransactionRolledbackException: Global tx rolled back

Regards,
satya
Martijn Verburg
author
Bartender

Joined: Jun 24, 2003
Posts: 3274
    
    5

You query that you run from com.shell.seop.cpfe.util.QueryHandler.getHistoricalCalcBookStock is taking more than 1200 seconds to complete. As you have a transaction timeout configured for 1200 seconds (you can probably find this setting throguh the console or in a config file) so the transaction manager then times out the transaction.

You should look at your query and see why it is taking so long (it could be the query it could also be other factors such as a extremely slow connection to your DB etc)

Cheers,
Martijn


Cheers, Martijn - Blog,
Twitter, PCGen, Ikasan, My The Well-Grounded Java Developer book!,
My start-up.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Transaction has timed out after 1,200 seconds