Steps to reproduce:
- Configure and test ODBC connection
- Fill the Macros at Zabbix configuration
- Note that only some values are populated.
Result:
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log Flush Waits/sec')].cntr_value.first()": no data matches the specified path
1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.log_flush_wait_time["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log Flush Wait Time')].cntr_value.first()": no data matches the specified path
1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.log_files_used_size["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log File(s) Used Size (KB)')].cntr_value.first()": no data matches the specified path
1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.log_files_size["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log File(s) Size (KB)')].cntr_value.first()": no data matches the specified path
1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.log_bytes_flushed_sec.rate["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log Bytes Flushed/sec')].cntr_value.first()": no data matches the specified path
1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.data_files_size["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Data File(s) Size (KB)')].cntr_value.first()": no data matches the specified path
1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.active_transactions["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Active Transactions')].cntr_value.first()": no data matches the specified path