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

Details

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

    Description

      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.

      Attachments

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

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: