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