search cancel

UIM - Arithmetic overflow error on sqlserver probe

book

Article ID: 190382

calendar_today

Updated On:

Products

DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

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'

Environment

Release : 5.42

Component : UIM - SQLSERVER

Resolution

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

https://knowledge.broadcom.com/external/article/101549/sqlserver-failed-to-reopen-log-file-5-ti.html