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

Failed: cannot extract value from json by path no data matches the specified path. MSSQL with multiple instances.

XMLWordPrintable

    • Icon: Incident report Incident report
    • Resolution: Fixed
    • Icon: Trivial Trivial
    • None
    • 6.4.5
    • Agent (G), Templates (T)
    • None

      Steps to reproduce:

      1. Configure and test ODBC connection
      2. Fill the Macros at Zabbix configuration
      3. Note that only some values are populated. 

      Result:
      1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log Flush Waits/sec')].cntr_value.first()": no data matches the specified path
        1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.log_flush_wait_time["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
      1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log Flush Wait Time')].cntr_value.first()": no data matches the specified path
        1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.log_files_used_size["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
      1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log File(s) Used Size (KB)')].cntr_value.first()": no data matches the specified path
        1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.log_files_size["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
      1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log File(s) Size (KB)')].cntr_value.first()": no data matches the specified path
        1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.log_bytes_flushed_sec.rate["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
      1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Log Bytes Flushed/sec')].cntr_value.first()": no data matches the specified path
        1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.data_files_size["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
      1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Data File(s) Size (KB)')].cntr_value.first()": no data matches the specified path
        1320:20230802:083301.293 error reason for "SQLServerName:mssql.db.active_transactions["PAM_ExternalData"]" changed: Preprocessing failed for: [{"object_name":"SQLServerName$$InstanceName:Databases","cntr_value":"0","counter_name":"State","SQLServerName_...
      1. Failed: cannot extract value from json by path "$[?(@.counter_name=='Active Transactions')].cntr_value.first()": no data matches the specified path

        1. 1.png
          1.png
          8 kB
        2. 2.png
          2.png
          8 kB
        3. 3.png
          3.png
          20 kB
        4. 4.png
          4.png
          165 kB

            zabbix.support Zabbix Support Team
            anslu Łukasz
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: