Skip to Content
0
Former Member
Aug 31, 2015 at 09:57 PM

CannotAcquireLockException (stockService.updateActualStockLevel)

518 Views

When I try to update stock levels using OOB method updateActualStockLevel(ProductModel product, WarehouseModel warehouse, int actualAmount, String comment), I am getting below error.

[DefaultStockService] update not successful: org.springframework.dao.CannotAcquireLockException: PreparedStatementCallback; SQL [UPDATE stocklevels SET p_reserved = 0, p_available =? WHERE PK=?]; Lock wait timeout exceeded; try restarting transaction; nested exception is java.sql.SQLException: Lock wait timeout exceeded; try restarting transactionERROR [ActionNode] Error executingde.hybris.platform.servicelayer.exceptions.SystemException

Can some one please help?