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?