GSM/GPRS Upgrade Scripts Have Poor Performance (Doc ID 790461.1)

Last updated on JULY 19, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.0.0.1 and later
HP-UX PA-RISC (32-bit)
HP-UX PA-RISC (32-bit)

Symptoms

On Oracle Communications Billing and Revenue Management(BRM), 7.3.0.0.1 version, poor performance and missing SQLs observed with GSM/GPRS upgrade scripts.

For example when executing the statement "UPDATE event_t..." of the script "update_event_service.sql" to change the service_obj_type and event_type to point to the new gsm objects, it takes a lot of time to complete.

Steps To Reproduce:

Upgrade GSM Manager from 1.0 to 2.0.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms