My Oracle Support Banner

Contention/locking When DEALINC Batch is Multi-threaded (Doc ID 2763464.1)

Last updated on APRIL 08, 2021

Applies to:

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

Symptoms

Contention/locking when DEALINC batch is multi-threaded.

Error: err.dealinc_3.Feb_25:dealinc_3~20210225055233~process~deal_actuals_item_loc~-60~ORA-00060: deadlock detected while waiting for resource ORA-06512: at line 1~ARRAY UPDATE: NUM_RECORDS_PROCESSED=10, dai_id=173855, actual_income=0.000000

Steps to repoduce:
------------------
1. Multi-thread DEALINC batch.
2. Note the above error occurs upon execution.

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.