Troubleshooting
Problem
Locking Kit items in alphabetical order to avoid deadlock
Symptom
Description :
-------------------
How to let kit items be locked
(YFS_INVENTORY_ITEM) in a alphabetical order to avoid dead lock.
Please set
the property yfs.inventory.sortandlock in yfs.properties to 'Y' . The solution
created has
been tested on the following APIs.
Note : This
parameter has been tested on Version
5.0SP2
1.createOrder
2.scheduleOrder
3.releaseOrder
4.confirmShi
pment
PART: API-DM 5.0 SP2 Platform
PRODUCT:
Distributed Order Management
COMPONENT: confirmShipment
Cause
Resolving The Problem
Following is an example how the parameter helps avoid a deadlock issue with
respect to the table YFS_INVENTORY_ITEM,when yfs.inventory.sortandlock is
set to "Y' in yfs.properties.
Name of API Kit items in the
order Line Sequence in which the Lock was placed Observation
---------------------- ---------------------------------------
----------------------------------------------------------------
-------------------
CreateOrder Kit1 :
C+B+A
A,B,C
Initial sequence of locks are placed in alphabetical order.
Schedule Order Kit1 : C+B+A
A,B,C
Initial sequence of locks are placed in alphabetical order.
Release Order Kit1 : C+B+A
A,B,C
Initial sequence of locks are placed in alphabetical order.
Confirm Shipment Kit1 : C+B+A
A,B,C
Initial sequence of locks are placed in alphabetical order.
Historical Number
PRI49681
Product Synonym
[<p><b>]Fact[</b><p>];
Was this topic helpful?
Document Information
Modified date:
16 June 2018
UID
swg21546483