Errors and weird values using MSSQL ODBC based template

[sbelkin]

Hi!
On Zabbix 6.0 LTS I have an error with items:

• Buffer cache hit ratio
• Cache Hit Ratio
• 'Worktables From Cache Ratio

Error happens on preprocessing steps using parameter, for example

$[?(@.counter_name=='WorktablesFromCacheRatio')].cntr_value.first()

it fails with this message:

Preprocessing failed for: [{"object_name":"SQLServer:Access Methods","cntr_value":"828","counter_name":"AU cleanup batches/...

1. Failed: cannot extract value from json by path "$[?(@.counter_name=='WorktablesFromCacheRatio')].cntr_value.first()": no data matches the specified path

I've found that adding spaces in counter_name (Worktables From Cache Ratio) the errors go away and I get following the values:



If I run the query manually from "Get performance counters" I get the same values…. are those value reasonable?