My Oracle Support Banner

Getting Core Dumps While Passing Missing POID Values In PCM_OP_COLLECTIONS_GROUP_GET_BILLINFO Input FLIST. (Doc ID 1922281.1)

Last updated on JANUARY 05, 2017

Applies to:

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


On BRM 7.5PS4, Collections Opcode


Getting coredumps while passing missing POID values in Collections opcode PCM_OP_COLLECTIONS_GROUP_GET_BILLINFO input flist.


 This is the order of events:

1) 6 tables were truncated at 10:03 in Production environment.
2) Nobody realized that this happened and system continued to work and new orders were processed and new accounts (including records in /billinfo, /service, etc.) were created.
3) After several hours was realized that something is not OK with BRM and it was shut down (let's say at 13:30)
4) DB was restored as it was at 9:57 (so a few minutes before the disaster). This is a consistent image and everything is perfect at BRM DB level
5) BRM is restarted and new requests come from external systems (FMW/AIA). But some of these commands refer to objects that were created in step 2. However, those objects do not exist anymore in DB because it was restored so everything that was created in step 2 does not exist. The problem is that other systems (AIA XREF tables which link Siebel IDs to BRM ones) are not aware about the facts that those objects do not exist anymore because they were created after the restore point and were lost when DB was restored.

Errors observed:

E Tue Aug 12 05:07:05 2014  uknp54sr-vf  cm:44607  fm_collections_group_get_billinfo.c:955 1:uknp90sr-vf:UnknownProgramName:0:Workmanager: , Version: 0, Scheduled=false, Started=false, Wait time: 0 ms:10007:1407816425:0
    <location=PIN_ERRLOC_DM:4 class="UNKNOWN":0 errno=PIN_ERR_NOT_FOUND:3>
    <field num=0:0,0 recid=0 reserved=0 reserved2=0 time(sec:usec)=0:0>
    <facility=0 msg_id=0 version=0>
Received Signal 11
#0  0xf7766430 in __kernel_vsyscall ()
#1  0x488cf833 in __waitpid_nocancel () from /lib/
#2  0x4887419b in do_system () from /lib/
#3  0x489a6ead in system () from /lib/
#4  0xf75aa61a in printExceptionReport () from /opt/brm/common1/pin01/7.5/lib/
#5  0xf75a29ed in sigsegv_handler () from /opt/brm/common1/pin01/7.5/lib/
#6  <signal handler called>
#7  0xf4ef9ded in fm_collections_group_get_billinfo () from /opt/brm/common1/pin01/7.5/lib/
#8  0xf4ef88b6 in op_collections_group_get_billinfo () from /opt/brm/common1/pin01/7.5/lib/
#9  0xf7630ba0 in cm_pre_pcm_op () from /opt/brm/common1/pin01/7.5/lib/
#10 0xf7645953 in pcm_op_ex () from /opt/brm/common1/pin01/7.5/lib/
#11 0xf76454fc in pcm_op () from /opt/brm/common1/pin01/7.5/lib/
#12 0xf49d5721 in fm_collections_group_manage () from /opt/brm/common1/pin01/7.5/lib/
#13 0xf49d235c in vf_op_collections_group_manage () from /opt/brm/common1/pin01/7.5/lib/
#14 0xf759d81f in cm_custom_ex () from /opt/brm/common1/pin01/7.5/lib/
#15 0xf759ccce in cm_custom () from /opt/brm/common1/pin01/7.5/lib/
#16 0xf759b00f in cm_child () from /opt/brm/common1/pin01/7.5/lib/
#17 0xf75a9f8b in mainThread () from /opt/brm/common1/pin01/7.5/lib/

Actual Result:

coredump got generated when collections opcode is called for objects that do not exist or with a NULL POID_ID.

Expected Result:

The issue is that instead of core, just an error should have been raised.


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

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