My Oracle Support Banner

High Number of Suspensed Records Due to Concurrent Usage in Sharing Group for Bulk SMS (Doc ID 2671591.1)

Last updated on MAY 24, 2020

Applies to:

Oracle Communications Offline Mediation Controller - Version 6.0.0.3.0 and later
Information in this document applies to any platform.

Symptoms

In a product system it was observed that there was high usage suspense majorly due to bulk Short Message Service (SMS) coming concurrently from two members who belong to same sharing group, where both are trying to get a lock on the sharing group owner in parallel and it is causing suspense as one of it could not get lock with the retry limit. Even if one moves old files and tries to process them in batches, as new files of same two numbers are coming as well, it is suspending them.

Steps to reproduce:

  1. Created a Charge Offering (CO) with TeloGsmSms
  2. Created a Charge sharing object in Pricing Design Center (PDC)
  3. Created four accounts parent1, child1, child2 and child3 with above CO
  4. Associated all the three child account to parent account for charge sharing
  5. Processed 8250 records

Observation: 2453 records failed with error CUSTOMER_IN_TRANSACTION and moved to Suspense.


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.