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

      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

        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

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

              Created:
              Updated:
              Resolved: