Mechanism to Manage the Throttling of CDR Load to UEL (Doc ID 2453005.1)

Last updated on JUNE 29, 2022

Applies to:

Goal

Scenario :

In a customer production setup, consider the process of receiving the rated CDRs from mediation system (Prepaid and postpaid) and loading in BRM through Universal Event Loader (UEL) :

1. Mediation systems deliver cdr files in predefined input directory of BRM server.
2. BRM Pre-UEL process (scheduled and runs in every 1 minute) picks those files, validates them as per business defined rules, splits them into multiple files (1000 event records per file) and ..
   - transfers to the processing directory if success
   - OutOfSequence Directory if validation fails in predefined business rules.
   - Error Directory if validation failed due to wrong file etc.
3. BRM UEL process (14 UEL processes run in parallel) randomly picks those files, so 14 files at a time with 1000 events per file processing and uploading in BRM.

Challenges :

1. At one time, 14 files are picked, so 14X1000= 14000 records are processing and uploading in BRM.
2. Because there is no Throttling mechanism defined, hence files are continuously picked by UEL process and some times UEL processes are getting stuck or go in a hang state.
3. While one is trying to stop the UEL process it is not possible and hence the UEL process ID hast o be killed and need to restart it forcefully.
4. Due to this continuous runs of UEL process, database transactions are also getting stuck and facing database blocking issues.

Overall, there is no error in the system at time of CDR loading. But in case of process being down at the time of Bill run or any other situation, there are huge number of CDRs piling in the system. To process huge number of CDRs, there is no throttling mechanism to pass CDRs to UEL process. What are the recommendations to apply throttling mechanism in UEL process?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.