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

MSSQL by ODBC - cannot extract value from json

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Cannot Reproduce
    • Icon: Trivial Trivial
    • None
    • 5.0.4
    • Templates (T)
    • None
    • Cent OS 8
      Zabbix 5.0.4
      MSSQL

      Hi everyone,

      I had install Zabbix 5.0.4 and wanted to use Template DB MySQL by ODBC (downloaded from here https://git.zabbix.com/projects/ZBX/.../db/mssql_odbc). Odbc is configured on zabbix server and it is able to connect to it. Discovery rules are not showing any errors. I've got problems with items created by them:

      This is error message:

      Preprocessing failed for: [

      {"object_name":"EAIDEV","counter_name":"Uptime","instance_name":"","cntr_value":"228895"}

      ,{"obje...
      1. Failed: cannot extract value from json by path "$[?(@.object_name=='EAIDEV:Buffer Manager' && @.counter_name=='Page reads/sec')].cntr_value.first()": no data matches the specified path

      There are values so it can't be username, pw, DSN or instance name...

      The server is multi instance.

        1. [000375].png
          115 kB
          Emilien
        2. 380.png
          26 kB
          Emilien
        3. 381.png
          4 kB
          Emilien
        4. MSSQLGet performance counters.txt
          231 kB
          Emilien
        5. screMSSQL.INSTANCE.png
          2 kB
          Emilien
        6. template_db_mssql_odbc.xml
          214 kB
          Emilien

            zux Edgars Melveris
            emilien.henry Emilien
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: