Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-24754

Errors and weird values using MSSQL ODBC based template

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Unresolved
    • Icon: Trivial Trivial
    • None
    • 6.0.31
    • Templates (T)
    • None

      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:

       

       

            aigars.kadikis Aigars Kadikis
            sbelkin Sergio Belkin
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated: