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

Official template MSSQLServer Failed: cannot extract value from json by path

    XMLWordPrintable

Details

    • Problem report
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 5.0.5rc1
    • Templates (T)
    • None
    • Centos 7.8 full updated
      Zabbix server 5.0.4
      Using ODBC Microsoft ODBC 17
    • Team INT
    • 0.5

    Description

      Steps to reproduce:

      1. Install the ODBC and configure odbc.ini at /etc/odbc.ini
      2. Configure a Host with the required values in MACRO from the official template of MSSQL in order to connect to MSSQL
      3. Configure the value {$MSSQL.INSTANCE} macro as MSSQL$instance
      4. Check each dependant item with the following error:

      Result:
      Preprocessing failed for: [{"object_name":"MSSQL$ISNTANCENAME","counter_na me":"Uptime","instance_name":"","cntr_value":".. .
      1. Failed: cannot extract value from json by path "$[?(@.object_name=='MSSQL$ISNTANCENAME:SQL Statistics' && @.counter_name=='Batch Requests/sec')].cntr_value.first()": no data matches the specified path
      Expected:
      See screenshot

      Attachments

        1. image_17428.png
          image_17428.png
          75 kB
        2. output.txt
          64 kB
        3. template_db_mssql_odbc.yaml
          146 kB
        4. zabbix1.png
          zabbix1.png
          42 kB
        5. zabbix2.png
          zabbix2.png
          71 kB
        6. zabbix3.png
          zabbix3.png
          28 kB

        Activity

          People

            abiba Andrew Biba (Inactive)
            sysadm.es Victor
            Votes:
            1 Vote for this issue
            Watchers:
            9 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: