My Oracle Support Banner

Customer Loading Was Hanging Due To Query Tools (Doc ID 2777469.1)

Last updated on APRIL 10, 2024

Applies to:

Oracle Communications BRM - Elastic Charging Engine - Version 12.0.0.3.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.0.0.3.0 version, Customer, Config, Pricing Migration

The customer data loading from Billing and Revenue Management (BRM) to Elastic Charging Engine (ECE) using customer updater was hanging due to query tools.

In the ecs log, there is a message printed every 5 mins saying member left cluster and member joined cluster. 

There are 2 issues:
- When customer loading is in progress, the query is not coming out fast (e.g select count() from Customer). It takes lot of time (like 10mins) and sometimes timeout.
- When query.sh is connected, it freezes the customer loading process.

Workaround:
If query.sh is not connected during customer loading then it works.

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.