Attix5 Pro FAQ
Search:     Advanced search

Arithmetic overflow error when logging in with the Storage Platform Console

Article ID: 274
Last updated: 04 Nov, 2014

Symptom

When logging into the Storage Platform with the SP Console you get a popup similar to this:

Or in the AccountServer log you see a similar error:

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. very large negative value. This throws out the StorageServer calculations used in the Console.

Resolution

Run the following query to identify the account:

SELECT
  backupgroup,
  accountname,
  OnDiskSize
FROM
   dbo.BackupAccountinfo
   order by OnDiskSize desc

The problem account should be the first one listed.  Locate the account in the Console and confirm it has an excessive OnDisk value. Run a quick IC with fixes on it and confirm that the Ondisk Value is now within sensible limits.  Afterwards the StorageServers will show again in the Console.

Article ID: 274
Last updated: 04 Nov, 2014
Revision: 2
Views: 1698
Comments: 0
Posted: 10 Oct, 2014 by Van Rensburg J.
Updated: 04 Nov, 2014 by Van Rensburg J.
This article was:  
Prev   Next
Article 270 - Unable to change other collection-level Backup Administrators'...     Article 280 - VSS Restore Failed - The system cannot find the path specified