Reset and Check Mailbox Counters

Feature Server release 8.1.201.64 includes these two python scripts:

• renewMailboxcountersColumnFamily.py — Renews or resets mailbox counters.
• getAllMailboxCountersInfo.py — Checks mailbox counters.

You can run python scripts, on the master Feature Server instance, to:

• correct an error that caused Feature Server to display incorrect totals for the number of messages in a mailbox.
• check the mailbox counters.

Feature Server release 8.1.201.64 includes these two python scripts:

• renewMailboxcountersColumnFamily.py — Renews or resets mailbox counters.
• getAllMailboxCountersInfo.py — Checks mailbox counters.

Deploy the python scripts

1. On the master Feature Server instance, copy the jython-2.7b1.jar file...
   from FS installation path\work\jetty-x.x.x.x-pppp-fs.war-_fs-any-\webapp\WEB-INF\lib
   to FS installation path\python\util
2. Open the console and navigate to FS installation path\python\util, which contains the scripts.
3. Enter the appropriate command to set the JYTHONPATH...
   Windows
   set JYTHONPATH=FS installation path\python
   Linux
   export JYTHONPATH=FS installation path/python

Run the python scripts

The following python scripts save data, such as User roles, User Voicemail Profiles assignments, and User Group Voicemail Profiles assignments, that are not related to or synchronized with Configuration Server.

Each script creates a csv file that you can analyze, edit as needed, and use as the input data for the scripts restoring the data not contained in Configuration Server.

Use this command line format to run each script:

java -jar jython-2.7b1.jar scriptname.py script input parameters

Check and Refresh Mailbox Counters

1. Run getAllMailboxCountersInfo.py to identify mailboxes having invalid counters.

   These mailboxes will be marked with !!! in script output log, e.g. (SIPVM-3970)

   Mailbox: 86025: Read value: '-1/0 (0/0)'; Calculated value: '0/0 (0/0)';  !!!

2. Create the input file listing all mailboxes having invalid counters.
3. Run refreshMailboxCounters.py using input file created.

Refresh Mailbox Counters

1. Verify that:
   • Your Cassandra database is backed up. See [Documentation:FS:Admin:cassback Backing Up and Restoring Cassandra Data].
   • All Feature Servers are up and running.
   • There is no voicemail activity (no one can deposit, read, or listen to voicemail).
2. Create a .csv file which has the list of mailboxes that needs to be refreshed.
3. Run the Python script refreshMailboxcounters.py.

The content of the file mailboxeIdsInput.csv should be in this format:

4909045
4909185
4909005
4909889

Sample Command Line

java -jar jython-2.7b1.jar refreshMailboxCounters.py -H localhost -p 9160 -i ./mailboxeIdsInput.csv -o ./refreshMailboxCounters.log

Check Mailbox Counters

1. Verify that:
   • All Feature Servers are up and running.
   • There is no voicemail activity (no one can deposit, read, or listen to voicemail).
2. Run getAllMailboxCountersInfo.py.

Sample Command Line

java -jar jython-2.7b1.jar getAllMailboxCountersInfo.py -H localhost -p 9160 -o ./getAllMailboxCountersInfo.log