Problem Partitioning ITEM_T Using BRM 7.4 (Doc ID 1104165.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.4.0.0.0 to 7.4.0.0.0 [Release 7.4.0]
Information in this document applies to any platform.
Checked for relevance on 26-Mar-2012
*** Checked for relevance on 02-29-2016 ***


Symptoms

Tried to partition /item using the steps in the BRM documentation.

BRM 7.4 Documentation says:

Partitioning item tables
You might need to partition item tables when upgrading from previous versions. To partition item tables, do the following:
1. Use the pin_deploy utility to export the existing /item storable class definition.
        cd BRM_home/sys/test
        pin_deploy class -mn /item > item.podl
2. Using a text editor, open the item.podl file.
3. Add or modify the following:
        IS_PARTITIONED = "1";
        PARTITION_MODE = "Finite";
    Note The value for PARTITION_MODE could be Finite or Historic depending on the requirement.
4. Save and close the file.
5. Run the following command:
       pin_deploy replace item.podl
    This updates the data dictionary for this class and also creates the basic partitions in the item tables.
6. To partition item tables, run the partition_utils utility with the add operation. The syntax is:
       partition_utils -o add -t realtime|delayed -s start_date -u month|week|day -q quantity
       [-c storable_class] [-w width] [-f] [-p]
For more information, see partition_utils.

On step 5, got this error :

/portal/evolutivo/7.4/sys/test> pin_deploy replace item.podl
Warning: Class Name /item already exists.
Error: [location=<PIN_ERRLOC_DM:4> class=<PIN_ERRCLASS_SYSTEM_DETERMINATE:1>
errno=<PIN_ERR_BAD_ARG:4>
field num=<PIN_FLD_IS_PARTITIONED:1,564>
recid=<0>
reserved=<0>

Could not set IS_PARTITIONED for item_t. 

Did not see any change in PARTITIONED field for item class in dd_object table.


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