XMLWordPrintable

Details

    • Patch request
    • Status: Closed
    • Trivial
    • Resolution: Incomplete
    • 5.0.11, 5.2.6, 5.4.0beta2
    • None
    • Templates (T)
    • CentOS8
      MariaDB
      Zabbix 5.4.rc1

      SQL Server 12.0.2000 on Windows Server 2012 R2

    Description

      > Attach the 'MSSQL by ODBC' template to the host running MSSQL
      > Modified the macros as documented
      > Zabbix isn't able to get all the dependent items data

      > Confirmed that ODBC connection from Zabbix host machine to server running MSSQL works
      > Installed official Microsoft Drivers
      > Items such as MSSQL: version and Uptime are monitored as expected. But the majority of all other dependent items have the same problem:

      Preprocessing failed for: [{"object_name":"MSSQL$MSSQL1:Access Methods","counter_name":"AU cleanup batches/sec","instance_n...
      1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Locks' && @.counter_name=='Average Wait Time Base' && @.instance_name=='_Total')].cntr_value.first()": no data matches the specified path

      Something about the json/path isn't correct and it has been an issue for awhile now with different Zabbix versions. Tried it with version 5.2 and 5.4. It has been previously reported in the community.

      Attachments

        1. Fault1.png
          Fault1.png
          80 kB
        2. Fault2.PNG
          Fault2.PNG
          22 kB
        3. Fault3.PNG
          Fault3.PNG
          22 kB
        4. Fault4.PNG
          Fault4.PNG
          173 kB

        Activity

          People

            atocko Andrey Tocko
            BOZK Burak Ozkan
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: