Symptoms

During the precheck before the upgrade to 7.3, the following error occurs:

    Precheck error: There are active, trial, graced, expired or on hold subscriptions with transferred accounts,
    which last billing date is earlier than transfer date, and plans were not replaced in SubscrHistRec for last billing period.
    This is the list with their identificators: <list_of_identificators>
    Do the following: Fix the issue as described in the Knowledgebase Article #131127
    (https://kb.cloudblue.com/131127).

Cause

The tariffs for ABP subscriptions in the SubscrHistRec table were not changed on accounts' transfer.

Resolution

If the precheck tool found active, trial, graced, expired or "put on hold" subscriptions belonging to the transferred accounts, whose last billing date is earlier than the transfer, and the plans were not replaced in the SubscrHistRec table for the last billing period, then do the following:

  1. Connect to OA Billing Application node via ssh.
  2. Download the fix_subscription_and_tariffs.py (attached to this KB article).
  3. Run the script:

    # python /usr/local/bm/tools_py/patcher.py fix_subscription_and_tariffs.py
    
  4. Rerun the precheck tool.

Internal content