My Oracle Support Banner

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

To view full details, 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 a vibrant support community of peers and Oracle experts.