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

XMLWordPrintable

    • Type: Incident report
    • Resolution: Fixed
    • Priority: Trivial
    • None
    • Affects Version/s: 6.4.5
    • Component/s: Agent (G), Templates (T)
    • None
    • Environment:

      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

            Assignee:
            Zabbix Support Team
            Reporter:
            Łukasz
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: