Locking Error When LCLRBLD Is Run in Multiple Threads: 'RET-0103: generic function processing error~Rebuild list error' (Doc ID 2149602.1)

Last updated on AUGUST 15, 2017

Applies to:

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

Symptoms

When running the Location List Batch Rebuild batch (LCLRBLD) in multi-threaded mode, the batch is failing with the error below due to locking issues:


Steps to Reproduce:

  1. Create several Location Lists with the batch rebuild indicator 'Y'
  2. Ensure that same locations are included in multiple lists
  3. Assign Item List to Location Lists above for use of SITMAIN (Scheduled Item Maintenance batch),
  4. Change the LCLRBLD batch to execute with 6 threads
  5. Execute the 6 threads of LCLRBLD simultaneously
  6. Notice that some of the threads are failing with the above 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