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 and later
HP-UX PA-RISC (32-bit)
HP-UX PA-RISC (32-bit)


On Oracle Communications Billing and Revenue Management(BRM), 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.


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