Loadpricelist: Memory Error Due To A Big Quantity Of Transitions Plans and Slow Performance (Doc ID 1291519.1)

Last updated on SEPTEMBER 26, 2016

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.3.1.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 19-Dec-2012***
***Checked for relevance on 15-Jun-2014***

Goal

Qn1:

When using loadpricelist to load pricing data, a user received PIN_ERR_NO_MEM. How can we resolve this problem?


Log file shows:

cm.pinlog:
D Wed Jun 23 18:47:37 2010 xxxxx cm:4108 pcm.c(54):862 1:xxxxx:loadpricelist:0:main:663:1277329626:0
   pcm_op: cannot retry PCM_OP_SEARCH, flags 0x0 - in a transaction - state=2
E Wed Jun 23 18:47:37 2010 xxxxx cm:4108 fm_price_utils.c:1612 1:xxxxx:loadpricelist:0:main:663:1277329626:0
   PCM Op error
   <location=PIN_ERRLOC_DM:4 class=UNKNOWN:0 errno=PIN_ERR_NO_MEM:1>
   <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
   <facility=0 msg_id=0 version=0>

dm_oracle.pinlog:
E Wed Jun 23 18:47:37 2010 xxxxx dm:29379 pin_flist(63):1141 1:xxxxx:loadpricelist:0:main:663:1277329626:0
   malloc failed in pin_flist_create
E Wed Jun 23 18:47:37 2010 xxxxx dm:29379 pin_flist(63):3487 1:xxxxx:loadpricelist:0:main:663:1277329626:0
   flist creation failed (1) in pin_flist_copy
E Wed Jun 23 18:47:37 2010 xxxxx dm:29379 dm_search.c(90):1333 1:xxxxx:loadpricelist:0:main:663:1277329626:0
   dm_search_rflds: pin_flist_copy failed, cmd=select distinct poid_DB, poid_ID0, poid_TYPE, poid_REV, created_t, mod_t, read_access, write_access, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV, end_t, fee_flag, from_obj_DB, from_obj_ID0, from_obj_TYPE, from_obj_REV, permitted, start_t, to_obj_DB, to_obj_ID0, to_obj_TYPE, to_obj_REV, type from transition_t where transition_t.poid_TYPE = :1 AND transition_t.account_obj_ID0 = :2 err=1(PIN_ERR_NO_MEM)


Qn2:

When using loadpricelist to load pricing data, it took 7 minutes to load 2MB of plan transition pricing data (approximately 10,000 transitions).
When loading 100,000 plan transition data, the user estimated 70 minutes or more to load all the transition data. Is there a possibility to optimize this loading time?


Solution

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