Upgrade_account_product_split.Sql Is Taking More Than 25 Hrs And Still Running (Doc ID 795268.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version: 7.3.0.0.0
This problem can occur on any platform.

Symptoms

Execution of upgrade_account_product_split.sql is taking very long time


-- Steps To Reproduce:
 run upgrade.pl.

The below queries take very long time:

DELETE FROM au_account_products_t
WHERE rowid not in (SELECT MIN(rowid) FROM au_account_products_t
GROUP BY node_location, last_modified_t);

 

UPDATE au_purchased_product_t au_pp
SET effective_t = last_modified_t,
-- the assumption here is that it points to account and not the au_account
(account_obj_db, account_obj_id0, account_obj_type, account_obj_rev,
au_parent_obj_db, au_parent_obj_id0, au_parent_obj_type,
au_parent_obj_rev, package_id) =
(SELECT account_obj_db, account_obj_id0, account_obj_type,
account_obj_rev, poid_db, poid_id0, poid_type, poid_rev,
package_id FROM purchased_product_t pp
WHERE au_pp.node_location = pp.node_location);



 

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