379 - Arithmetic overflow error when logging in with the Storage Platform Console

Symptom

When logging into the Storage Platform Console, you see an error message similar to this:

Error: Arithmetic overflow error converting expression to data type binint.

Or, in the AccountServer log, you see an error similar to this:

12:07:47.750 (9c) Error: Error while processing XML-RPC call from john.doe@192.168.8.8: Arithmetic overflow error converting expression to data type bigint.. System.Data.SqlClient.SqlException (0x80131904): Arithmetic overflow error converting expression to data type bigint.

Cause

There are one or more accounts with invalid OnDisk information, e.g. a very large negative value. This throws out the StorageServer calculations used in the Console.

Solution

1. Run the following query to identify the account:
   SELECT
  backupgroup,
  accountname,
  OnDiskSize
FROM
   dbo.BackupAccountinfo
   order by OnDiskSize desc
2. The problematic account should be the first one listed.
3. Run an Integrity Check with fixes on this account using a task file (since access via the Console is likely not possible):
   1. Create a text file with the extension *.IntegrityCheck e.g., <accountname>.IntegrityCheck 
      Note: Ensure it does not have a .txt extension
   2. Paste the following into the file and modify it with the correct account GUID:
      CheckCRCs=False
CheckPatches=False
FixErrors=True
AccountGuid=<Account GUID here>
   3. Save the file and drop it into the TaskQueue folder on the correct StorageServer.
      Note: Do not create the file in the TaskQueue folder; it will be read before you can populate it.
   4. Progress can be seen in the Console and any errors or warnings detected will be reported in the StorageServer logs.
4. Once the Integrity Check is complete, run the query again and confirm that the OnDisk value is now within sensible limits.
5. Confirm login via the Console if successful.