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

Template DB MSSQL by ODBC fails on "bigger" monitored MSSQL servers

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • 5.0.16
    • Templates (T)
    • None
    • CentOS8

      Description

      The template "Template DB MSSQL by ODBC" internally uses Item "Get performance counters" that runs complex SQL query and returns JSON Item used by other dependent Items

      On the "bigger" MSSQL servers with cca 5 databases and more it creates JSON document so big that it is truncated to fit maximum Text Item limit 64kB. Tre truncated JSON document produces a lot of unsupported LLD Items

      Steps to reproduce:

      1. Apply the template on "bigger" MSSQL instance

      Result:
      See truncated JSON document produced by Item "Get performance counters" in attached file "truncated.json". 
      Expected:
      Working template

            abiba Andrew Biba
            kbelunek Karel Bělunek
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: