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:

       

       

        1. image-2024-07-01-11-11-39-758.png
          8 kB
          Sergio Belkin
        2. image-2024-07-01-11-13-42-725.png
          27 kB
          Sergio Belkin
        3. image-2024-07-01-11-18-36-159.png
          8 kB
          Sergio Belkin
        4. image-2024-07-01-11-40-47-652.png
          9 kB
          Sergio Belkin
        5. image-2024-07-01-11-42-11-655.png
          28 kB
          Sergio Belkin
        6. image-2024-07-01-13-19-46-682.png
          53 kB
          Sergio Belkin
        7. image-2024-07-01-13-20-18-728.png
          29 kB
          Sergio Belkin
        8. screenshot-1.png
          26 kB
          Aigars Kadikis
        9. screenshot-2.png
          27 kB
          Aigars Kadikis
        10. zbx_export_templates_mssql-odbc.yaml
          65 kB
          Sergio Belkin

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

              Created:
              Updated: