Null RPS Data: Cannot Close Or Change Service Due To Missing "/rate_plan_selector" (Doc ID 1294377.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

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

Symptoms

Unable to close or change service.

Changes to a user implemented Price Plan updated a product (changed scaled amounts and product description for an existing product). Since then, changes to the related service failed with message Error getting rps_datap: Null RPS data. It appears that the "au_rate_plan_selector_t" table points to the old rate_plan_selector that was deleted when the new one was created.

cm.pinlog shows the following error when tried to close a service:

W Tue Feb 8 09:09:01 2011 host01 cm:26093 ../cm_utils.c:1001 1:ST30315:UnknownProgramName:0:AWT-EventQueue-0:86:1297177733:0
   CM FM->DM op PCM_OP_SEARCH, opflags 0x0
# number of field entries allocated 20, used 6
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
0 PIN_FLD_FLAGS INT [0] 256
0 PIN_FLD_TEMPLATE STR [0] "select X from /rate_plan_selector where F1 = V1 and F2 = V2 "
0 PIN_FLD_ARGS ARRAY [1] allocated 20, used 1
1   PIN_FLD_POID POID [0] 0.0.0.1 /rate_plan_selector 82238321 4
0 PIN_FLD_ARGS ARRAY [2] allocated 20, used 1
1   PIN_FLD_ACCOUNT_OBJ POID [0] 0.0.0.1 /account 1 0
0 PIN_FLD_RESULTS ARRAY [0] allocated 20, used 0
W Tue Feb 8 09:09:01 2011 host01 cm:26093 ../cm_utils.c:1331 1:ST30315:UnknownProgramName:0:AWT-EventQueue-0:86:1297177733:0
   CM DM->FM op PCM_OP_SEARCH, opflags 0x0
# number of field entries allocated 1, used 1
0 PIN_FLD_POID POID [0] 0.0.0.1 /search -1 0
W Tue Feb 8 09:09:01 2011 host01 cm:26093 fm_rate_cache.c:2338 1:ST30315:UnknownProgramName:0:AWT-EventQueue-0:86:1297177733:0
   Could not get the selector data from DB
D Tue Feb 8 09:09:01 2011 host01 cm:26093 fm_rate_cache.c:2380 1:ST30315:UnknownProgramName:0:AWT-EventQueue-0:86:1297177733:0
   fm_rate_cache_get_selector: Can not find selector data
E Tue Feb 8 09:09:01 2011 host01 cm:26093 fm_rate_cache.c:9795 1:STC0030315:UnknownProgramName:0:AWT-EventQueue-0:86:1297177733:0
   Error getting rps_datap: Null RPS data
   <location=PIN_ERRLOC_FM:5 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1 errno=PIN_ERR_NULL_PTR:39>
   <field num=opsflds:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>


The search could not find "/rate_plan_selector" 82238321 4.

How to resolve this issue?

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