-
Type:
Problem report
-
Resolution: Won't fix
-
Priority:
Trivial
-
None
-
Affects Version/s: 6.0.31
-
Component/s: Templates (T)
There are errors with items such as:
- Buffer cache hit ratio
- Cache Hit Ratio
- Worktables From Cache Ratio
Error happens on preprocessing steps using parameter, for example
**
Code:
$[?(@.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
One can modifies preprocessing steps to:
$[?(@.counter_name=='Worktables From Cache Ratio')].cntr_value.first()
Now it get values but I think they are miscalculated:
