Timeout When Waiting For Lock While Saving A Stock Count Location

(Doc ID 1447281.1)

Last updated on MAY 30, 2017

Applies to:

Oracle Retail Store Inventory Management - Version 13.1.3 and later
Information in this document applies to any platform.
checked for relevance as on 25-JUL-2014

Symptoms

 In Oracle Retail Store Inventory Management (ORSIM) user is trying to save the count at multiple stock count locations at a time (or) single stock count location and it is failing because of the below error.

Error:
Caused by: java.sql.BatchUpdateException: ORA-02049: timeout: distributed transaction waiting for lock

Steps To Recreate:

1. Create a product group with all items present in the store and schedule as Unit stock count.
2. Once the stock count is generated, take snap shot of all the locations.
3. Parallelly use 10 handheld sessions and try saving count at multiple stock count locations at a time.
4. Even when tried with a single stock count location, the response is very slow and some times throwing the same error.

Cause

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 hundreds of Community platforms