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

Failed: cannot extract value from json by path

    XMLWordPrintable

Details

    Description

      1. I setup new host using default template (Template DB MSSQL by ODBC and Template OS Windows By Zabbix Agent)
      2. On Graph for MSSQL still no data 
      3. i see on zabbix_server.log return this error message 
        Failed: cannot extract value from json by path "$[?(@.object_name=='SQLEXPRESS_2019:SQL Statistics' && @.counter_name=='Batch Requests/sec')].cntr_value.first()": no data matches the specified path
          2769:20210107:133416.720 error reason for "SQLSERVER:mssql.readahead_pages_sec.rate" changed: Preprocessing failed for: [{"object_name":"MSSQL$SQLEXPRESS_2019:Access Methods","counter_name":"AU cleanup batches/sec","i...
      1. this macros on the host 
        {$MSSQL.DSN} => sql1
        {$MSSQL.INSTANCE} => SQLEXPRESS_2019
        {$MSSQL.PASSWORD}
        {$MSSQL.PORT} => 4019
        {$MSSQL.USER} =>zabbix
        
      1. For MSSQL.INSTANCE this is wrong ? because i got from query 
        select @@servername

        the result is 

        WIN-3HQL3VMV7Q8\SQLSERVER_2017
        

      Attachments

        1. macros-2.png
          macros-2.png
          30 kB
        2. sample_screen-2.png
          sample_screen-2.png
          74 kB
        3. templates-2.png
          templates-2.png
          16 kB
        4. zabbix_server.log
          317 kB

        Activity

          People

            elina.kuzyutkina Elina Kuzyutkina
            febridev febriyant
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: