My Oracle Support Banner

Tsfclose - Locking Issues Result In Failures - Need To Handle Locks As Non-Fatal (Doc ID 3010864.1)

Last updated on MARCH 21, 2024

Applies to:

Oracle Retail Merchandising System - Version 16.0.3 and later
Information in this document applies to any platform.

Symptoms

In RMS 16.0.3 with Patch 35382665: RMS_16.0.3_CUMULATIVE_HF_MAY_2023_2

tsfclose - Locking Issues result in failures - Need to handle locks as non-fatal

Client has upwards of 10,000 transfers with millions of item/locations to be processed by tsfclose each day; thus, they have to run tsfclose with multiple threads in order for the batch to run within SLAs. However, since a single warehouse will have transfers to 100s of stores for the same dates/items the batch fails with the following errors:

tsfclose_3~20230922135807~bulk_update_tables~item_loc_soh~-54~ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired~LOCK_RECORDS: FOR UPDATE OF item_loc_soh
item=100421862, loc=414, loc_type=W

The tsfclose batch needs to handle these errors as non-fatal and simply skip records/item locs/transfers that cannot be locked. This change in logic was added to the cloud versions of tsfclose.pc via Bug ID: 32294007 – TSFCLOSE FAILING WITH LOCKING ERRORS IF HAS MORE THAN ONE THREAD. This same logic needs to be added to the RMS 16.0.3 version of tsfclose.

This issue is rather urgent as the current run-time/failures of tsfclose will prevent them from rolling out additional warehouses.

Steps To Recreate:

1) Create thousands of transfers using same item/warehouse to many stores
2) Setup auto close W/S parameter so that tsfclose will process transfers in step #1
3) Setup multi-threading for tsfclose (8 to 16 threads)
4) Run tsfclose
5) Notice most threads abort with locking issues.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.