This week's book giveaway is in the Design forum.
We're giving away four copies of Design for the Mind and have Victor S. Yocco on-line!
See this thread for details.
Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Transaction has timed out after 1,200 seconds

 
satya sompalle
Greenhorn
Posts: 6
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 3275
5
Eclipse IDE Java Mac OS X
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic