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

Template DB MSSQL by ODBC: Most dependent items fail with: Preprocessing failed

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • 5.0.3rc1, 5.2.0alpha1, 5.2 (plan)
    • 5.0.2
    • Templates (T)
    • Debian amd64 10 Buster
      MariaDB 10.4
      Zabbix Server 5.0.2
      Microsoft SQL Server 2016 13.0.5820.21
    • Sprint 66 (Jul 2020)
    • 1

      Steps to reproduce:

      1. Import latest Version of Template Template DB MSSQL by ODBC from:
        https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/db/mssql_odbc
      2. Link Template with a Windows Host, that has SQL Server 2016 installed.
      3. Create a SQL server with appropriate permissions
      4. Create the corresponding macros:
        {$MSSQL.DSN}
        {$MSSQL.USER}
        {$MSSQL.PASSWORD}
        {$MSSQL.PORT}
      5. Wait for results and watch item status

      Result:
      See screenshot...
      Example errors from several failed dependent items:

       

      Preprocessing failed for: [{"object_name":"MSSQL$AX:Access Methods","counter_name":"AU cleanup batches/sec","instance_name"...
      1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Buffer Manager' && @.counter_name=='Page reads/sec')].cntr_value.first()": no data matches the specified path
      Preprocessing failed for: [{"object_name":"MSSQL$AX:Access Methods","counter_name":"AU cleanup batches/sec","instance_name"...
      1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Buffer Manager' && @.counter_name=='Page life expectancy')].cntr_value.first()": no data matches the specified path
      Preprocessing failed for: [{"object_name":"MSSQL$AX:Access Methods","counter_name":"AU cleanup batches/sec","instance_name"...
      1. Failed: cannot extract value from json by path "$[?(@.object_name=='SQLServer:Buffer Manager' && @.counter_name=='Lazy writes/sec')].cntr_value.first()": no data matches the specified path
      

      Expected:
      Working items.

        1. axsql2016-01.png
          axsql2016-01.png
          2 kB
        2. image-2020-07-20-16-08-47-741.png
          image-2020-07-20-16-08-47-741.png
          20 kB
        3. image-2020-07-20-19-30-45-810.png
          image-2020-07-20-19-30-45-810.png
          89 kB
        4. image-2020-07-20-19-32-20-311.png
          image-2020-07-20-19-32-20-311.png
          62 kB
        5. odbc1.png
          odbc1.png
          293 kB
        6. sql2016-01.png
          sql2016-01.png
          1 kB

            mchudinov Maxim Chudinov (Inactive)
            starko Marco Hofmann
            Team INT
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: