-
Problem report
-
Resolution: Fixed
-
Trivial
-
5.0.2
-
Debian amd64 10 Buster
MariaDB 10.4
Zabbix Server 5.0.2
Microsoft SQL Server 2016 13.0.5820.21
-
Sprint 66 (Jul 2020)
-
1
Steps to reproduce:
- Import latest Version of Template Template DB MSSQL by ODBC from:
https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mssql_odbc - Link Template with a Windows Host, that has SQL Server 2016 installed.
- Create a SQL server with appropriate permissions
- Create the corresponding macros:
{$MSSQL.DSN}
{$MSSQL.USER}
{$MSSQL.PASSWORD}
{$MSSQL.PORT} - Wait for results and watch item status
Result:
See screenshot...
Example errors from several failed dependent items:
Preprocessing failed for: [{"object_name":"MSSQL$AX:Access Methods","counter_name":"AU cleanup batches/sec","instance_name"... 1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Buffer Manager' && @.counter_name=='Page reads/sec')].cntr_value.first()": no data matches the specified path Preprocessing failed for: [{"object_name":"MSSQL$AX:Access Methods","counter_name":"AU cleanup batches/sec","instance_name"... 1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Buffer Manager' && @.counter_name=='Page life expectancy')].cntr_value.first()": no data matches the specified path Preprocessing failed for: [{"object_name":"MSSQL$AX:Access Methods","counter_name":"AU cleanup batches/sec","instance_name"... 1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Buffer Manager' && @.counter_name=='Lazy writes/sec')].cntr_value.first()": no data matches the specified path
Expected:
Working items.
