My Oracle Support Banner

Processing Item and PO Upload In Parallel Cause Deadlocks (Doc ID 2427451.1)

Last updated on DECEMBER 05, 2019

Applies to:

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

Symptoms



After you start processing a Purchase Order (PO) Upload, you see the deadlocks for an existing Item Upload which eventually causes the PO Upload to perform slow.

 Though Item and PO Upload belong to different AQ, these two AQs feed into one DB Scheduler. Hence, expect the application to provide a way where the user can define or feed in the scheduler to reduce the contention.


The issue can be reproduced at will with the following steps:


1. Start Item Upload and PO Upload in parallel.
2. Notice the deadlocks.

Changes

 

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
Changes
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.