Errors in MSSQL ODBC template for Azure SQL
Hi,
After configuring the MSSQL ODBC template on Zabbix 5.2 to Monitor Azure SQL Server, we are stuck with the following errors in the Zabbix server logs (same errors are reported on UI as well):
From Zabbix Server Logs:
1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Access Methods' && @.counter_name=='Index Searches/sec')].cntr_value.first()": no data matches the specified path
From Zabbix UI:
Preprocessing failed for: [{"object_name":"MSSQL$F788A23CE74D:Access Methods","counter_name":"AU cleanup batches/sec","inst...
1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:SQL Statistics' && @.counter_name=='Auto-Param Attempts/sec')].cntr_value.first()": no data matches the specified path
Can someone help to understand what do these errors mean and how to resolve them?
Also, please do share If there is any standard working template to get started with Azure SQL Monitoring on Zabbix 5.2. Thanks in advance.
After configuring the MSSQL ODBC template on Zabbix 5.2 to Monitor Azure SQL Server, we are stuck with the following errors in the Zabbix server logs (same errors are reported on UI as well):
From Zabbix Server Logs:
1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Access Methods' && @.counter_name=='Index Searches/sec')].cntr_value.first()": no data matches the specified path
From Zabbix UI:
Preprocessing failed for: [{"object_name":"MSSQL$F788A23CE74D:Access Methods","counter_name":"AU cleanup batches/sec","inst...
1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:SQL Statistics' && @.counter_name=='Auto-Param Attempts/sec')].cntr_value.first()": no data matches the specified path
Can someone help to understand what do these errors mean and how to resolve them?
Also, please do share If there is any standard working template to get started with Azure SQL Monitoring on Zabbix 5.2. Thanks in advance.
Comment