Deadlock Received Sending in 2 Rule11 Shipment Actuals For Shipments on Same Order At Same Time
(Doc ID 1365485.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Transportation Management - Version 6.2.2 and laterInformation in this document applies to any platform.
Symptoms
When uploading 2 Rule 11 actual shipments for the same order at the same time, the 2nd transmission fails with the following error:
ERROR
-----------------------
2011-07-22 07:43:12.746 258883 Debug Planning Load TItinerary for itineraryPK: TIN.FP_CHGO_RULE11_RAIL publishWait - 2
2011-07-22 07:48:12.794 258829 Error Exception Generic_Remote_Exception
weblogic.ejb20.locks.LockTimedOutException: EJB:010107The lock request from EJB:ejb.Leg with primary key:TIN.201 timed-out after waiting 300,000 ms. The transaction or thread requesting the lock was:Name=[EJB glog.business.shipmentactual.ShipmentActualSessionServerSideEJBWrapper.executeShipmentActual(glog.util.genericcontainer.GenericContainer,[Lglog.business.shipmentactual.ModViaOrderLine;,http://Lglog.business.shipmentactual.ModViaOrderShipUnit;,glog.business.shipmentactual.ShipmentActualOptions),Xid=BEA1-17B6C61AF1C19471A362(395219355),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=303,seconds left=6897,activeThread=ThreadpublishWait - 4,5,Pooled Threads,XAServerResourceInfohttp://weblogic.jdbc.wrapper.JTSXAResourceImpl=(ServerResourceInfohttp://weblogic.jdbc.wrapper.JTSXAResourceImpl=(state=started,assigned=none),xar=weblogic.jdbc.wrapper.JTSXAResourceImpl@178e91fd,re-Registered = false),SCInfoOtmv620+gc3-xldevotmapp1=(state=active),properties=({weblogic.transaction.name=[EJB glog.business.shipmentactual.ShipmentActualSessionServerSideEJBWrapper.executeShipmentActual(glog.util.genericcontainer.GenericContainer,[Lglog.business.shipmentactual.ModViaOrderLine;,http://Lglog.business.shipmentactual.ModViaOrderShipUnit;,glog.business.shipmentactual.ShipmentActualOptions), ISOLATION LEVEL=2, weblogic.jdbc=t3://10.250.101.141:7001=null}),local properties=({modifiedListeners=weblogic.ejb.container.internal.TxManager$TxListener@17c507e6=null}),OwnerTransactionManager=ServerTMServerCoordinatorDescriptor=(CoordinatorURL=gc3-xldevotmapp1+10.250.101.141:7001+Otmv620+t3+, XAResources={WSATGatewayRM_gc3-xldevotmapp1_Otmv620, WLStore_Otmv620__WLS_gc3-xldevotmapp1, weblogic.jdbc.wrapper.JTSXAResourceImpl=null},NonXAResources={=null}),CoordinatorURL=gc3-xldevotmapp1+10.250.101.141:7001+Otmv620+t3+).
weblogic.ejb20.locks.LockTimedOutException: EJB:010107The lock request from EJB:ejb.Leg with primary key:TIN.201 timed-out after waiting 300,000 ms. The transaction or thread requesting the lock was:Name=[EJB glog.business.shipmentactual.ShipmentActualSessionServerSideEJBWrapper.executeShipmentActual(glog.util.genericcontainer.GenericContainer,[Lglog.business.shipmentactual.ModViaOrderLine;,http://Lglog.business.shipmentactual.ModViaOrderShipUnit;,glog.business.shipmentactual.ShipmentActualOptions),Xid=BEA1-17B6C61AF1C19471A362(395219355),Status=Active,numRepliesOwedMe=0,numRepliesOwedOthers=0,seconds since begin=303,seconds left=6897,activeThread=ThreadpublishWait - 4,5,Pooled Threads,XAServerResourceInfohttp://weblogic.jdbc.wrapper.JTSXAResourceImpl=(ServerResourceInfohttp://weblogic.jdbc.wrapper.JTSXAResourceImpl=(state=started,assigned=none),xar=weblogic.jdbc.wrapper.JTSXAResourceImpl@178e91fd,re-Registered = false),SCInfoOtmv620+gc3-xldevotmapp1=(state=active),properties=({weblogic.transaction.name=[EJB glog.business.shipmentactual.ShipmentActualSessionServerSideEJBWrapper.executeShipmentActual(glog.util.genericcontainer.GenericContainer,[Lglog.business.shipmentactual.ModViaOrderLine;,http://Lglog.business.shipmentactual.ModViaOrderShipUnit;,glog.business.shipmentactual.ShipmentActualOptions), ISOLATION LEVEL=2, weblogic.jdbc=t3://10.250.101.141:7001}),local properties=({modifiedListeners=weblogic.ejb.container.internal.TxManager$TxListener@17c507e6}),OwnerTransactionManager=ServerTMServerCoordinatorDescriptor=(CoordinatorURL=gc3-xldevotmapp1+10.250.101.141:7001+Otmv620+t3+, XAResources={WSATGatewayRM_gc3-xldevotmapp1_Otmv620, WLStore_Otmv620__WLS_gc3-xldevotmapp1, weblogic.jdbc.wrapper.JTSXAResourceImpl},NonXAResources={}),CoordinatorURL=gc3-xldevotmapp1+10.250.101.141:7001+Otmv620+t3+).
at weblogic.ejb.container.locks.ExclusiveLockManager$LockBucket.lock(ExclusiveLockManager.java:362)
at weblogic.ejb.container.locks.ExclusiveLockManager.lock(ExclusiveLockManager.java:153)
at weblogic.ejb.container.manager.ExclusiveEntityManager.preInvoke(ExclusiveEntityManager.java:258)
at glog.ejb.itinerary.ejb_Leg_7hcmoi_EOImpl.getData(ejb_Leg_7hcmoi_EOImpl.java:7631)
at glog.business.itinerary.TItinerary.load(TItinerary.java:108)
at glog.business.shipment.TShipment.getTItinerary(TShipment.java:4144)
at glog.business.shipment.TShipment.getDepotLocationPair(TShipment.java:5949)
at glog.business.shipment.TShipment.makeDepotStops(TShipment.java:6197)
at glog.business.shipment.TShipment.createTShipments(TShipment.java:1075)
at glog.business.shipment.TShipment.load(TShipment.java:1023)
at glog.business.shipment.ShipmentLoader.loadShipments(ShipmentLoader.java:379)
at glog.business.shipment.ShipmentLoader.loadShipments(ShipmentLoader.java:238)
at glog.business.shipment.ShipmentLoader.loadShipments(ShipmentLoader.java:196)
at glog.business.shipment.ShipmentLoader.loadShipment(ShipmentLoader.java:164)
at glog.business.shipment.ShipmentLoader.loadShipment(ShipmentLoader.java:153)
at glog.business.shipmentactual.ShipmentActualExecutor.execute(ShipmentActualExecutor.java:188)
at glog.business.shipmentactual.ShipmentActualExecutor.execute(ShipmentActualExecutor.java:124)
at glog.business.shipmentactual.ShipmentActualSessionBean.executeShipmentActual(ShipmentActualSessionBean.java:100)
at glog.business.shipmentactual.ShipmentActualSessionServerSideEJBWrapper.executeShipmentActual(ShipmentActualSessionServerSideEJBWrapper.java:85)
at glog.business.shipmentactual.ShipmentActualSessionHome_4tsowh_EOImpl.executeShipmentActual(ShipmentActualSessionHome_4tsowh_EOImpl.java:59)
at glog.integration.application.shipment.ShipmentWrapper.invokeShipmentActualSession(ShipmentWrapper.java:1171)
at glog.integration.application.shipment.ShipmentWrapper.invokeShipmentActualSession(ShipmentWrapper.java:1153)
at glog.integration.application.shipment.ShipmentWrapper.persistViaShipmentActualSession(ShipmentWrapper.java:1203)
at glog.integration.application.shipment.ShipmentWrapper.persistContainerSelf(ShipmentWrapper.java:1347)
at glog.integration.xmlbasewrapper.XmlBaseWrapper.persistViaContainer(XmlBaseWrapper.java:349)
at glog.integration.application.shipment.ShipmentInterface.persistIndivXML(ShipmentInterface.java:262)
at glog.integration.application.shipment.ShipmentInterface.persistXML(ShipmentInterface.java:190)
at glog.integration.application.BaseInterface.persistXMLBase(BaseInterface.java:196)
at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:224)
at glog.integration.application.TransactionProcessor.processTransaction(TransactionProcessor.java:363)
at glog.server.workflow.transproc.TransProc.execute(TransProc.java:106)
at glog.server.workflow.SimpleWorkflow.execute(SimpleWorkflow.java:23)
at glog.server.workflow.WorkflowSessionBean.execute(WorkflowSessionBean.java:64)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper.execute(WorkflowSessionNonTransServerSideEJBWrapper.java:38)
at glog.server.workflow.WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.execute(WorkflowSessionNonTransServerSideEJBWrapper_t6tuwu_EOImpl.java:278)
at glog.server.workflow.WorkflowManager.execute(WorkflowManager.java:352)
at glog.server.workflow.Trigger.trigger(Trigger.java:122)
at glog.util.event.MemoryEventQueueRunnable.processEvent(MemoryEventQueueRunnable.java:147)
at glog.util.event.MemoryEventQueueRunnable.run(MemoryEventQueueRunnable.java:98)
at glog.util.event.EventThread.run(EventThread.java:83)
at java.lang.Thread.run(Thread.java:619)
publishWait - 4
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into OTM 6.2.
2. Send in 2 different Rule 11 shipment actual for the same order.
3. Note the deadlock error received in the transmission report.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |