|
| Hi,
I am calling OrderPrepare from within a controller command that executes after OrderItemAdd is called. The URL parameter provided to OrderItemAdd is set to the name of the controller command. I am
seeing several entries per day in my ecmsg file with "The current transaction has been rolled back because of a deadlock or timeout." I am including the error message below. Any ideas on what is
causing this problem and any possible solutions would be greatly appreciated.
Thanks,
John
Thread ID: <Servlet.Engine.Transports:17756>
Class: com.ibm.commerce.order.calculation.CalculationHelper
Method: getTaxableAdjustmentTotals
Severity: 1
Message Text: CMN0412E The following Remote Exception occurred during processing: "javax.transaction.TransactionRolledbackException: CORBA TRANSACTION_ROLLEDBACK 0 No; nested exception is:
org.omg.CORBA.TRANSACTION_ROLLEDBACK: com.ibm.websphere.csi.CSITransactionRolledbackException: null; nested exception is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator. throw_SQLException(SQLExceptionGenerator
.java:269)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator. throw_SQLException(SQLExceptionGenerator
.java(Inlined Compiled Code))
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.execute2(DB2PreparedStatement.java(Compiled Code))
at COM.ibm.db2.jdbc.app.DB2PreparedStatement.executeQuery(DB2PreparedStatement.java(Compiled Code))
at com.ibm.ejs.cm.cache.CachedStatement.executeQuery(CachedStatement.java(Compiled Code))
at com.ibm.ejs.cm.proxy.StatementProxy.executeQueryCommon(StatementProxy.java(Compiled Code))
at com.ibm.ejs.cm.proxy.PreparedStatementProxy.executeQuery(PreparedStatementProxy.java(Compiled Code))
at com.ibm.commerce.order.objects. EJSJDBCPersisterCMPOrderItemAdjustmentBe
an. findByOrderItemIds(EJSJDBCPersisterCMPOr
derItemAdjustmentBean.java(Compiled Code))
at com.ibm.commerce.order.objects.EJSCMPOrderItemAdjustmentHomeBean. findByOrderItemIds(EJSCMPOrderItemAdjust
mentHomeBean.java(Inlined Compiled Code))
at com.ibm.commerce.order.objects.EJSRemoteCMPOrderItemAdjustmentHome. findByOrderItemIds(EJSRemoteCMPOrderItem
AdjustmentHome.java(Compiled Code))
at com.ibm.commerce.order.objects._OrderItemAdjustmentHome_Stub. findByOrderItemIds(_OrderItemAdjustmentH
ome_Stub.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationHelper. getTaxableAdjustmentTotals(CalculationHe
lper.java(Compiled Code))
at com.ibm.commerce.order.calculation. TaxableNetPriceCalculationScaleLookupCmd
Impl. performExecute(TaxableNetPriceCalculatio
nScaleLookupCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl. callScaleLookup(CalculationRuleCalculate
CmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl. scaleCalculate(CalculationRuleCalculateC
mdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCalculateCmdImpl. performExecute(CalculationRuleCalculateC
mdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCombineCmdImpl. callRuleCalculate(CalculationRuleCombine
CmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationRuleCombineCmdImpl. performExecute(CalculationRuleCombineCmd
Impl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationCodeCalculateCmdImpl. callRuleCombine(CalculationCodeCalculate
CmdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationCodeCalculateCmdImpl. performExecute(CalculationCodeCalculateC
mdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.ApplyCalculationUsageCmdImpl. callCodeCalculate(ApplyCalculationUsageC
mdImpl.java(Compiled Code))
at com.ibm.commerce.order.calculation.ApplyCalculationUsageCmdImpl. performExecute(ApplyCalculationUsageCmdI
mpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.calculation.CalculationHelper. applyCalculationUsages(CalculationHelper
.java(Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper. calculateShippingAndTaxCharges(OrderProc
essingHelper.java(Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper. calculateShippingTaxAndTotals(OrderProce
ssingHelper.java(Inlined Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper. updateOrderPricing(OrderProcessingHelper
.java(Inlined Compiled Code))
at com.ibm.commerce.order.commands.OrderProcessingHelper. updateOrderPricing(OrderProcessingHelper
.java(Inlined Compiled Code))
at com.ibm.commerce.order.commands.PrepareOrderCmdImpl.doProcess(PrepareOrderCmdImpl.java(Compiled Code))
at com.ibm.commerce.order.commands.PrepareOrderCmdImpl.performExecute(PrepareOrderCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECCommand.execute(AbstractECCommand.java(Compiled Code))
at com.ibm.commerce.order.commands.OrderPrepareCmdImpl.performExecute(OrderPrepareCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECCommandTarget.java(Compiled Code))
at com.ibm.sfc.cmd.TargetableCommandImpl.execute(TargetableCommandImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECTargetableCommand.execute(AbstractECTargetableCommand.java(Compiled Code))
at com.owls.wcs.command.MyControllerCmdImpl.performExecute(MyControllerCmdImpl.java(Compiled Code))
at com.ibm.commerce.command.ECCommandTarget.executeCommand(ECCommandTarget.java(Compiled Code))
at com.ibm.sfc.cmd.TargetableCommandImpl.execute(TargetableCommandImpl.java(Compiled Code))
at com.ibm.commerce.command.AbstractECTargetableCommand.execute(AbstractECTargetableCommand.java(Compiled Code))
at com.ibm.commerce.webcontroller.ControllerCmdExecUnit.execute(ControllerCmdExecUnit.java(Compiled Code))
at com.ibm.commerce.webcontroller.WebController.executeTransaction(WebController.java(Compiled Code))
at com.ibm.commerce.webcontroller.WebController.processRequest(WebController.java(Compiled Code))
at com.ibm.commerce.adapter.AbstractHttpAdapter.processRequest(AbstractHttpAdapter.java(Compiled Code))
at com.ibm.commerce.server.RequestServlet.service(RequestServlet.java(Compiled Code))
at javax.servlet.http.HttpServlet.service(HttpServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictServletInstance.doService(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet._service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServicingServletState.service(StrictLifecycleServlet.java(Compiled Code))
at com.ibm.servlet.engine.webapp.StrictLifecycleServlet.service(StrictLifecycleServlet.java(Inlined Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstance.service(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ValidServletReferenceState.dispatch(ServletManager.java(Compiled Code))
at com.ibm.servlet.engine.webapp.ServletInstanceReference.dispatch(ServletManager.java(Inlined Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher. handleWebAppDispatch(WebAppRequestDispat
cher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
at com.ibm.servlet.engine.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
at com.ibm.servlet.engine.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java(Compiled Code))
at com.ibm.servlet.engine.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
at com.ibm.servlet.engine.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
at com.ibm.servlet.engine.http11.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.CachedThread.run(ThreadPool.java(Compiled Code))
:javax.transaction.TransactionRolledbackException: com.ibm.websphere.csi.CSITransactionRolledbackException: null; nested exception is:
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUX] SQL0911N The current transaction has been rolled back because of a deadlock or timeout. Reason code "2". SQLSTATE=40001
|
|