IBM Support

Deadlocks observed while trying to invoke adjustInventory API.

Technote (troubleshooting)


Deadlocks are observed while trying to invoke adjustInventory API.


Deadlocks are detected as shown in the error trace below :

java.sql.SQLException: ORA-00060: deadlock detected while waiting for resource
at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4CTTIoer.processError( at oracle.jdbc.driver.T4C8Oall.processError( at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement. java:205)

Resolving the problem

Enabling below mentioned property will help in resolving the problem, as it will lock items in alphabetical order.

yfs.yfs.inventory.sortandlock=Y in or yfs.inventory.sortandlock=Y in

Setting this property to Y will prevent dead locks on YFS_Inventory_Item table during
order creation and when synchronizing changes from a shipment back to the order. This
parameter is only used if the order contains a logical kit, or when a shipment lines are created for different orders.

Setting this property to Y will result into holding lock on YFS_Inventory_Item table for longer period. So, this may degrade overall system performance. Because of this reason, this property should be set to Y only if excessive dead locks are occurring on YFS_Inventory_Item table.

Document information

More support for: Sterling Order Management

Software version: All

Operating system(s): Platform Independent

Reference #: 1625219

Modified date: 06 December 2014

Translate this page: