UIM - Arithmetic overflow error on sqlserver probe
search cancel

UIM - Arithmetic overflow error on sqlserver probe


Article ID: 190382


Updated On:


DX Unified Infrastructure Management (Nimsoft / UIM)


On some servers the logfile_usage checkpoint metric is throwing errors like this -

query execution did not run successfully  xxxxx 'Arithmetic overflow error converting expression to data type int'


Release : 5.42

Component : UIM - SQLSERVER


The build version 5.42HF3 fixes below issues:-
  • Alarm not generated, for customs checkpoint if anything modified in profile (Activate or deactivate defined checkpoint ).
  • logfile_usage checkpoints were not working and giving an error (Arithmetic overflow error converting the expression to data type int. ) and changed the query for MSSQL version 2012 and above for this checkpoints.
  •  Fixed issue when probe migrated from version 5.40 to 5.42 with connection type windows auth, in 5.42 connection type was changing to SQL server auth.
  • Added the feature for checkpoints agent_job_failure for exclude or include list to work based on the job name.

Please contact support via support ticket to get this hotfix

Additional Information

SQLServer: Failed to re-open log file 5 times. Logging is deactivated