Execution Of Install.sh (multi_db) Taking Way Too Long During PS10 Upgrade Activity (Doc ID 2054388.1)

Last updated on JULY 15, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

Below are the two testcases for issue reproduction between primary and secondary schemas:

Test Case 1: Different class ID's for /balance_group in dd_objects_t

1. Create of primary and secondary schemas
2. Run the following SQL's on the secondary schema:

update dd_objects_t set obj_id0 = 1022 where name like '/balance_group';
update dd_objects_fields_t set obj_id0 = 1022 where obj_id0 = 1021;
commit;

3. Restart secondary DMO
4. Create obj_for event
    Which would populate the event_essentials_t data through test->cm->dmo->db for 0.0.0.1 with the flag (PCM_OPFLG_USE_GIVEN_POID_DB_NUMBER 0x4000000).
5. Do read_obj for the above event from test->cm->dmo->db for 0.0.0.2.
    This should fail.
6. Run the install.sh process
    Let it run through its course.
7. Verify the logs of install.sh generated that event_essentials upgrade did go through
8. Restart DMO secondary DMO
9. Repeat step 5. This time it should work.


Test Case 2: Different class ID's for /account in dd_objects_t

1. Create of primary and secondary schemas
2. Run the following SQL's on the secondary schema

update dd_objects_t set obj_id0 = 1001 where name like '/account';
update dd_objects_fields_t set obj_id0 = 1001 where obj_id0 = 1000;
commit;

3. Run the install.sh process.
    Let it run through its course.
4. Verify the logs of install.sh generated, that event_essentials upgrade did not run
    Because class ID for /balance_group, /balance_group/monitor, /purchased_product, /purchased_discount or /product were the same between primary and secondary schemas.


In the above cases, the class IDs were different and did not include /balance_group, /balance_group/monitor, /purchased_product, /purchased_discount.





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