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

    Details

    • Type: Problem report
    • Status: Closed
    • Priority: Trivial
    • Resolution: Fixed
    • Affects Version/s: 5.0.2
    • Fix Version/s: 5.0.3rc1, 5.2.0alpha1, 5.2 (plan)
    • Component/s: Templates (T)
    • Labels:
    • Environment:
      Debian amd64 10 Buster
      MariaDB 10.4
      Zabbix Server 5.0.2
      Microsoft SQL Server 2016 13.0.5820.21
    • Team:
      Team INT
    • Sprint:
      Sprint 66 (Jul 2020)
    • Story Points:
      1

      Description

      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.

        Attachments

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

          Activity

            People

            Assignee:
            mchudinov Maxim Chudinov
            Reporter:
            starko Marco Hofmann
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: