When the Usage Statistics > Total Hits in lifetime reaches/counts more than 2147483647 hits, then it is impossible to login to the MultiTerm Desktop Administrator view to manage server-termbases.

Right after the login the following error is displaying:

Arithmetic overflow error converting expression to data type int.




Clicking on OK will close the message and you are not able to do anything in the Administrator view. Another login attempt within the same session (without restarting MultiTerm) might lead to the message appearing a couple of times, clicking OK to close the messages will end up crashing/closing MultiTerm Desktop.

IMPORTANT: Follow the steps below only if you are an SQL specialists and only after you have created a backup of your databases.

Run the following SQL query on the MTMaster database to confirm the error "Arithmetic overflow error converting expression to data type int." is returned:
 

SELECT SUM(len) AS TotalHits FROM MtIndexes -- will error overflow if [len] is [int]

If the error is confirmed, run the following query on the [MTMaster] database to convert the type from int to bigint:
 

SELECT SUM(convert(bigint,len)) AS TotalHits FROM MtIndexes
ALTER TABLE [dbo].[MtIndexes]
ALTER COLUMN [len] bigint not null -- was [int]

When the Usage Statistics > Total Hits in lifetime reaches/counts more than 2147483647 total hits on the database side, then this value is evaluated as the sum of two ints and therefore the overflow error is displaying.

This was reported to our Development with the reference CRQ-32975.