PCM_OP_BILL_DEBIT Is Unable To Commit The Transaction In DB (Doc ID 2289949.1)

Last updated on AUGUST 08, 2017

Applies to:

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

Symptoms

During High Avalability test from Billing Revenue Management(BRM)  GateWay  to BRM, one has sent continuous top-up request to BRM.  It has been observed that some of the requests are not got committed in BRM DB, though the output flist is successfully printing in the cm.pinlog.

Below are the steps to reproduce the problem

1. Create account with Plan 1 on Jul 10th

2. Move pin_virtual_time to Aug 10th and run the below flist through testnap

xop >>PCM_OP_BILL_DEBIT 0 1
0 PIN_FLD_POID           POID [0] 0.0.0.1 /account 58613441 0
0 PIN_FLD_AUTHORIZATION_ID    STR [0] "10059-hostname1;20170428054212384883625;12"
0 PIN_FLD_PROGRAM_NAME    STR [0] "ElasticChargingEngineExternalTopUp"
0 PIN_FLD_DEBIT_INFO    ARRAY [0] allocated 20, used 2
1     PIN_FLD_BAL_GRP_OBJ    POID [0] 0.0.0.1 /balance_group 58611649 0
1     PIN_FLD_DEBIT         ARRAY [1000100] allocated 20, used 3
2         PIN_FLD_SUB_BALANCES  ARRAY [8] allocated 20, used 2
3             PIN_FLD_VALID_TO     TSTAMP [0] (1493589600) Mon May  1 00:00:00 2017
3             PIN_FLD_VALID_FROM   TSTAMP [0] (1490997600) Sat Apr  1 00:00:00 2017
2         PIN_FLD_BAL_OPERAND  DECIMAL [0] -10240
2         PIN_FLD_VALIDITY_FLAGS    INT [0] 1
0 PIN_FLD_END_T        TSTAMP [0] (1493350944) Fri Apr 28 05:42:24 2017

3. Run the same flist through another session of testnap

4. Out of 57 request send to BRM 47 has been committed and 10 has not been.  But for those 10 output flist from bill_debit is visible

Actual Output: The transaction gets struck, doesn't come out of testnap

Expected Output: An error should occur and be reported

Changes

 

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