Win a copy of JDBC Workbook this week in the JDBC and Relational Databases forum
or A Day in Code in the A Day in Code forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Jeanne Boyarsky
  • Junilu Lacar
  • Henry Wong
Sheriffs:
  • Ron McLeod
  • Devaka Cooray
  • Tim Cooke
Saloon Keepers:
  • Tim Moores
  • Stephan van Hulst
  • Frits Walraven
  • Tim Holloway
  • Carey Brown
Bartenders:
  • Piet Souris
  • salvin francis
  • fred rosenberger

Transaction has timed out after 1,200 seconds

 
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
 
author
Posts: 3281
8
Mac OS X Eclipse IDE Java
  • 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
 
Tomorrow is the first day of the new metric calendar. Comfort me tiny ad:
Devious Experiments for a Truly Passive Greenhouse!
https://www.kickstarter.com/projects/paulwheaton/greenhouse-1
    Bookmark Topic Watch Topic
  • New Topic