Deadlock Received Sending in 2 Rule11 Shipment Actuals For Shipments on Same Order At Same Time (Doc ID 1365485.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Transportation Management - Version: 6.2.2 and later   [Release: 6.2 and later ]
Information 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

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms