search

lausser / check_mssql_health

Wenn du dich für Plugins (oder OMD oder allgemein Monitoring) interessierst oder von deiner Installation erzählen willst...die Tradition der deutschsprachigen Monitoring-Workshops wird wiederbelebt: https://discord.gg/jDfPZ63FcJ A plugin, which checks various parameters of Microsoft SQL database servers.
http://labs.consol.de/nagios/check_mssql_health
GNU General Public License v2.0
38 stars 27 forks source link

failed-jobs undefined value as array on Microsoft SQL Server 2000 SP4 #30

Open trevrobwhite opened 7 years ago

trevrobwhite commented 7 years ago

I'm hoping your able to help, we've got a few Microsoft SQL Server 2000 SP4 Servers which haven't been upgraded yet, the plugin is crashing with:

Can't use an undefined value as an ARRAY reference at ./check_mssql_health line 4789.

Any ideas or is this old version just not supported any more (I'm sure it worked in the past), SQL queries still work ok.

Thanks in advance.

./check_mssql_health --server 192.168.X.X --username "XXXXX" --password "XXXX" --warning 43200 --critical 86400 --mode=failed-jobs --lookback 10080 --mitigation=0 --commit -v -v -v

Thu Sep 21 11:21:41 2017: SQL: SELECT @@VERSION ARGS: $VAR1 = [];

Thu Sep 21 11:21:41 2017: RESULT: $VAR1 = [ 'Microsoft SQL Server 2000 - 8.00.2282 (Intel X86) Dec 30 2008 02:22:41 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.2 (Build 3790: Service Pack 2) ' ];

Thu Sep 21 11:21:41 2017: AUTOLOAD Classes::MSSQL::DBI::override_opt

Thu Sep 21 11:21:41 2017: AUTOLOAD Classes::MSSQL::DBI::check_messages

Thu Sep 21 11:21:41 2017: SQL: SELECT SYSTEM_USER ARGS: $VAR1 = [];

Thu Sep 21 11:21:41 2017: RESULT: $VAR1 = [ 'USER' ];

Thu Sep 21 11:21:41 2017: SQL: SELECT @@SERVICENAME ARGS: $VAR1 = [];

Thu Sep 21 11:21:41 2017: RESULT: $VAR1 = [ 'MSSQLSERVER' ];

Thu Sep 21 11:21:41 2017: SQL: SELECT CAST(COALESCE(SERVERPROPERTY('IsHadrEnabled'), 0) as int) ARGS: $VAR1 = [];

Thu Sep 21 11:21:41 2017: RESULT: $VAR1 = [ 0 ];

Thu Sep 21 11:21:41 2017: AUTOLOAD Classes::MSSQL::DBI::analyze_and_check_job_subsystem

Thu Sep 21 11:21:41 2017: $self->{components}->{job_subsystem} = Classes::MSSQL::Component::JobSubsystem->new() Thu Sep 21 11:21:41 2017: AUTOLOAD Classes::MSSQL::DBI::check_job_subsystem

Can't use an undefined value as an ARRAY reference at ./check_mssql_health_orig line 4789.

jgbuenaventura commented 3 years ago

same issue at Microsoft SQL Server 2000 - 8.00.2039 (Intel X86).