Timeout When Waiting For Lock While Saving A Stock Count Location
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
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.
Caused by: java.sql.BatchUpdateException: ORA-02049: timeout: distributed transaction waiting for lock
Steps To Recreate:
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.
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