The "Subscriber ID" from the Voucher Manager Screen Shows "No information available" AND the ccsCDRLoader Fails With the Message "ccsCDRLoader(847) ERROR: flush: UPDATE: ORA-01403: no data foun" (Doc ID 1454882.1)

Last updated on OCTOBER 18, 2016

Applies to:

Oracle Communications Network Charging and Control - Version 4.4.1 and later
Information in this document applies to any platform.

Symptoms

In a normal situation When a voucher is redeemed, two EDRs are created:

  • EDR type 4 : a Voucher Redeem EDR is created as a consequence of the voucher redeem action.
     
  • EDR type 15 : if the Voucher Redeem operation succeeds, the account's wallet is recharged with the voucher value. A Wallet Recharge EDR is created as a consequence of the recharge action.

These EDRs will be sent to the SMS by the cmnPushFiles process to be transferred in the ccsCDRLoader incoming directory. The ccsCDRLoader will apply a series of plugins, each of which runs actions based on the type and the content of CDR.

One of these plugins is the VoucherRedeemPlugin, which scans Type 4 EDRs to insert data of every redeeming action into the main database on the SMS.


This problem has several symptoms that may be observed together:

 

On the Type 15 EDR


As explained above, with each voucher recharge, a type 15 EDR (consequence of the wallet recharge) will be created. Despite the fact that the recharge itself worked, and as a consequence of this problem, it may show an incorrect value in the VOUCHER tag.

 

  • And as a consequence of that problem, the Voucher Manager Service Management Server (SMS) management screen shows "No information available" in the Subscriber ID field for a redeemed voucher instead of the Subscriber ID:

    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