The Voucher and Wallet Server (VWS) Pair is Slowly and Silently Getting Out Of Sync and Some Transactions are being Silently Reverted (Doc ID 1264891.1)

Last updated on SEPTEMBER 19, 2011

Applies to:

Oracle Communications Network Charging and Control - Version: 2.4.0 and later   [Release: 2.4 and later ]
Information in this document applies to any platform.
This issue affects all the following Patches:
BE Patch 43287 (1.6) v2.4.0.17
BE Patch 44508 (1.1) v2.4.0.18
BE Patch 46850 (1.1) v2.4.0.19
BE Patch 46048 (1.5) v2.4.0.20
BE Patch 94102 (1.1) v2.4.0.21
BE Patch 98911 (1.3) v2.4.0.22

Symptoms

Symptom 1

Over time, the VWS pair's bucket information is slowly getting out of sync. This can be seen by manually running the following script on the SMS server as the ccs_oper user:

ccs_oper@SMS:/IN/service_packages/CCS$ cd /IN/service_packages/CCS/VW_SyncTools/Wallets

ccs_oper@SMS:/IN/service_packages/CCS/VW_SyncTools/Wallets$ ./check_be_wallet_bucket_diffs.sh
Select a UBE pair from the following list:
1) VWS01 [351] / VWS02 [352] ID: 01
UBE Pair[1-1]? 1

UBE Pair: 1
Domain ID: 01
Primary: VWS01 [db@"E2BE_01.WORLD"]
Secondary: VWS02 [db@"E2BE_02.WORLD"]


    WALLET         ID VALUE (PRI) VALUE (SEC) DIFF (PRI-SEC)
---------- ---------- ----------- ----------- --------------
      1519       6610       92899       92890              9

The above output shows that for Wallet 1519, there is a Bucket with ID 6610 which is 9 units greater on the Primary than the Secondary VWS server. If the buckets are getting out of sync, the number of rows returned will increase over time.

By scheduling the execution of the aforementioned script and gathering enough data for definitive trend analysis, a graph such as the following would be an indication that there is likely a problem:

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