Transaction Time out error.

[Nirmal Kannan]

Hello All,

I am getting timeout using Webshpere ND 6.0.2.39

[3/10/10 15:55:36:775 GMT] 0000003e TranManagerIm I WTRN0041I: Transaction 0000012745D15988000000010003DC125C82E0F7B26B255CA65669129AEF9FE393243BB70000012745D15988000000010003
DC125C82E0F7B26B255CA65669129AEF9FE393243BB700000001 has been rolled back.
[3/10/10 15:55:36:778 GMT] 0000003e ExceptionUtil E CNTR0019E: EJB threw an unexpected (non-declared) exception during invocation of method "findByPrimaryKey". Exception data:
com.ibm.websphere.csi.CSITransactionRolledbackException: Transaction rolled back; nested exception is:
javax.transaction.TransactionRolledbackException: Transaction is ended due to timeout
at com.ibm.ejs.csi.TransactionControlImpl.completeTxTimeout(TransactionControlImpl.java(Compiled Code))
at com.ibm.ejs.csi.TransactionControlImpl.preInvoke(TransactionControlImpl.java(Compiled Code))
at com.ibm.ejs.container.EJSContainer.preInvokeActivate(EJSContainer.java(Compiled Code))
at com.ibm.ejs.container.EJSContainer.preInvoke(EJSContainer.java(Compiled Code))
at com.ibm.commerce.base.objects.EJSRemoteCMPSchedulerConfigHome_3b1fe5e9.findByPrimaryKey(EJSRemoteCMPSchedulerConfigHome_3b1fe5e9.java(Compiled Code))
at com.ibm.commerce.base.objects._SchedulerConfigHome_Stub.findByPrimaryKey(_SchedulerConfigHome_Stub.java(Compiled Code))
at com.ibm.commerce.base.objects.SchedulerConfigAccessBean.instantiateEJB(SchedulerConfigAccessBean.java(Compiled Code))
at com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean._instantiate(AbstractEntityAccessBean.java(Inlined Compiled Code))
at com.ibm.ivj.ejb.runtime.AbstractEntityAccessBean.refreshCopyHelper(AbstractEntityAccessBean.java(Compiled Code))
at com.ibm.commerce.base.objects.SchedulerConfigAccessBean.refreshCopyHelper(SchedulerConfigAccessBean.java(Inlined Compiled Code))
at com.ibm.commerce.scheduler.Scheduler.getReadyToRunLateJob(Scheduler.java(Compiled Code))
at com.ibm.commerce.scheduler.Scheduler.prepareLateJobs(Scheduler.java(Compiled Code))
at com.ibm.commerce.scheduler.Scheduler.serverLoop(Scheduler.java(Compiled Code))
at com.ibm.commerce.scheduler.Scheduler.process(Scheduler.java:1663)
at com.ibm.commerce.scheduler.SchedulerSecurityPriviledgedAction.run(SchedulerSecurityPriviledgedAction.java:59)
at com.ibm.commerce.scheduler.Scheduler.run(Scheduler.java:1622)
Caused by: javax.transaction.TransactionRolledbackException: Transaction is ended due to timeout
at com.ibm.ws.Transaction.JTA.TranManagerImpl.completeTxTimeout(TranManagerImpl.java(Compiled Code))
at com.ibm.ws.Transaction.JTA.TranManagerSet.completeTxTimeout(TranManagerSet.java(Inlined Compiled Code))
... 16 more

Can someone please give an insight what could be the possible problem? Thanks in advance.

[Marcelo Sousa Ancelmo]

Hello Nirmal,

Your problem is that your business transaction, has timed out, you can try one of the following:
The easy way - Change the timeout value for the transactions, WebSphere default is 2 minutes (Bad idea, but will work)
The right way - Why is your transaction taking so long? It is a database problem? A logic problem? Try to investigate that.

Regards,