My Oracle Support Banner

Row Lock Contentions On Member Creation via EAI causes task to run continuously (Doc ID 1490429.1)

Last updated on AUGUST 03, 2018

Applies to:

Siebel Loyalty Engine - Version 8.1.1.1 SIA [21211] to 8.1.1.8 SIA [23012] [Release V8]
Information in this document applies to any platform.
Add ***Checked for relevance on 15-Jul-2014***

Symptoms

Customer was seeing an issue when multiple records were being inserted via a batch process.

The Loyalty application was locking the S_LOY_SRV_MAP table and therefore any further members were not being processed

This was seen in the tasks, where multiple tasks were still processing and did not complete.

EAI/web service calls were being used to enroll new members and create new customers. The OOTB business service 'LOY Customer Action Business Service' method 'GetKeyForMember' is invoked when workflow SQL WriteRecord is executed.

Under single thread, it works fine. When multiple calls were tested, this failed because of the DB row lock.

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.