Issue In Reservation Post Overlay Patch In Production

(Doc ID 1350765.1)

Last updated on NOVEMBER 27, 2011

Applies to:

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

Symptoms


Error encountered in DM while rating due to reservation release/ extension. [ STOP and Update accounting]


Here dm_oracle.pinlog
==================

E Mon Apr 11 02:04:00 2011 machine01 dm:29617 dm_ops.c(183):3406 1:machine01:cm:29426:1:1301:1302357:1302467640:174
ERROR RFLDS: do_sql_select "select poid_DB, poid_ID0, poid_TYPE, poid_REV, bal_grp_obj_DB, bal_grp_obj_ID0, bal_grp_obj_TYPE, bal_grp_obj_REV, reservation_status, account_obj_DB, account_obj_ID0, account_obj_TYPE, account_obj_REV from reservation_t where reservation_t.poid_id0 = :1", x=2, pp->id 18446744073709551615
E Mon Apr 11 02:04:00 2011 machine01  dm:29617 dm_back.c(29):1439 1:machine01:cm:29426:1:1301:1302357:1302467640:174
DMbe #144: process_op: op 4, err 3



Here snippet of cm.pinlog
==================

E Mon Apr 11 02:04:00 2011 machine01 cm:29991 fm_reserve_release.c:734 1:machine01:cm:29426:1:1301:1302357:1302467640:174
fm_reserve_release_list_update_rsv error
<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>
E Mon Apr 11 02:04:00 2011 machine01 cm:29991 fm_reserve_release.c:344 1:machine01:cm:29426:1:1301:1302357:1302467640:174
fm_reserve_release error
<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>
E Mon Apr 11 02:04:00 2011 machine01 cm:29991 fm_reserve_release.c:153 1:machine01:cm:29426:1:1301:1302357:1302467640:174
op_reserve_release error
<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>
E Mon Apr 11 02:04:00 2011 machineapp01 cm:29991 fm_term_pol_accounting.c:1385 1:machine01:cm:29426:1:1301:1302357:1302467640:174
op_term_pol_accounting error - during release of reservation
<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>
E Mon Apr 11 02:04:00 2011 machine01 cm:29991 fm_term_pol_accounting.c:1420 1:machine01:cm:29426:1:1301:1302357:1302467640:174
op_term_pol_accounting error
<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>
E Mon Apr 11 02:04:00 2011 machineapp01 cm:29991 fm_term_ip_close_a_session.c:163 1:machineapp01:cm:29426:1:1301:1302357:1302467640:174
fm_term_ip_close_a_session, accounting policy error
<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>
E Mon Apr 11 02:04:00 2011 machineapp01 cm:29991 fm_term_ip_stop_accounting.c:164 1:machineapp01:cm:29426:1:1301:1302467640:1
op_term_ip_stop_accounting error
<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>
E Mon Apr 11 02:04:00 2011 machine01 cm:29991 cm_child.c(109):4661 1:machine01:cm:29426:1:1301:1302467640:1
op PCM_OP_TERM_IP_DIALUP_STOP_ACCOUNTING returned an error
<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>

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