Pin_731_74_upgrade.pl Takes Long Time At The Step 731_74_modify_eventpoidlist_item.source (Doc ID 2216830.1)

Last updated on JANUARY 10, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 7.5.0.0.0 version, Upgrade

ACTUAL BEHAVIOR
---------------
User is in the process of upgrading from BRM 7.3.1 to 7.5 PS15.
During this process (7.3.1 to 7.4), pin_731_74_upgrade.pl is taking lot of time at the step add_new_objects_74.pl.
pin_731_74_upgrade.pl ==> add_new_objects_74.pl ==> 731_74_modify_eventpoidlist_item.source
731_74_modify_eventpoidlist_item.source took almost 17 hours to complete and move to next step. Table ITEM_T contains 64 million records.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Install 7.4_7594327_ThirdParty_Upgrade_linux_32_opt.bin
2. Install 7.4_7594327_Portal_Base_linux_32_opt.bin
3. execute pin_731_74_upgrade.pl

Changes

 

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