Data-conversion resulted in overflow - FULL SCANS

[ravikua]

We have Nagios Configured to Monitor SQL Server. Below is detailed information.
On Server we have 3 SQL instance. Instance1, Instance2, Instance3.
on Instance3, Full-scan is reporting as error_handler: Data-conversion resulted in overflow. while on the other 2 instance its working. Also please note on Instance3 other parameters like database free space is working.
Also we try with different user, through command line. Still FULL SCANS alone has the issue. we don't have any error message in SQL.
Below is the error message.

root@servername:/usr/lib/nagios/plugins# ./check_mssql_health –server Servername –username “Domain\\\\usename” –password password –mode full-scans
error_handler: Data-conversion resulted in overflow.
UNKNOWN – unable to aquire counter data
root@server:/usr/lib/nagios/plugins#

[tmcdonald]

I see you are using check_mssql_health but can you please specify the database type and version you are checking against?

[ravikua]

This issue we are facing on Microsoft SQL Server 2008 R2 (SP2) - SQL instance.

[ssax]

Please check with your DBA and make sure that the user that you're using has the same permissions on instance 3 that they have one 1 and 2, that's the likely cause.

Let us know the results.

Thank you

[ssax]

Also, what is the output of this command on the XI server:

Code: Select all

/usr/local/nagios/libexec/check_mysql_health -V

[ravikua]

SQL Server Instance has sysadmin rights. Below is the result of the code. Only FULL scans is showing error. other parameter like database free, etc is working

root@ABCDEF:/usr/local/nagios/libexec# ./check_mssql_health -V
check_mssql_health (1.5.8.2)
This nagios plugin comes with ABSOLUTELY NO WARRANTY. You may redistribute
copies of this plugin under the terms of the GNU General Public License.
root@ABCDEF:/usr/local/nagios/libexec#

[ssax]

That's a pretty old version, please upgrade to the latest and see if that resolves the issue for you:

https://labs.consol.de/nagios/check_mss ... index.html