My Oracle Support Banner

Loadpricelist Throwing Memory Errors Due to Large Quantities of Transition Plans and Slow Performance (Doc ID 1291519.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Communications Billing and Revenue Management - Version 6.0.3.0.0 and later
Information in this document applies to any platform.

Goal

On all versions of Oracle Communications Billing and Revenue Management (BRM), when using the loadpricelist utility to load pricing data, it fails with "PIN_ERR_NO_MEM".  How can this be resolved?

From the cm.pinlog log file:

D Wed Jun 23 18:47:37 2010 cm:4108 pcm.c(54):862 1: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 cm:4108 fm_price_utils.c:1612 1: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>

From the dm_oracle.pinlog log file:

E Wed Jun 23 18:47:37 2010  dm:29379 pin_flist(63):1141 1:loadpricelist:0:main:663:1277329626:0
   malloc failed in pin_flist_create
E Wed Jun 23 18:47:37 2010  dm:29379 pin_flist(63):3487 1:loadpricelist:0:main:663:1277329626:0
   flist creation failed (1) in pin_flist_copy
E Wed Jun 23 18:47:37 2010  dm:29379 dm_search.c(90):1333 1: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)

When using LoadPriceList to load 100,000 plan transition data, it is estimated to that it will take over 70 minutes.  Is it possible to optimize this process and decrease the loading time?

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.