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

Azure by HTTP - SQL doesn't work

XMLWordPrintable

    • 1

      Steps to reproduce:

      1. Import Template Azure by HTTP
      2. https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/cloud/azure_http?at=refs%2Fheads%2Frelease%2F6.4
      3. Set permissions according to docs:
      4. https://git.zabbix.com/projects/ZBX/repos/zabbix/browse/templates/cloud/azure_http/README.md?at=refs%2Fheads%2Frelease%2F6.4
      5. Create host with credentials

      Result:
      Storage discovery metrics work.

      Microsoft SQL Server discovery works, but all data collection fails

      Error:
      Failed to receive data:
      cpu_percent,physical_data_read_percent,log_write_percent,storage,connection_successful,connection_failed,blocked_by_firewall,deadlock,storage_percent,xtp_storage_percent,workers_percent,sessions_percent,sessions_count,cpu_limit,cpu_used,sqlserver_process_core_percent,sqlserver_process_memory_percent,tempdb_data_size,tempdb_log_size,tempdb_log_used_percent : Request failed with status code 400: {"error":{"additionalInfo":[{"type":"string","info":"TraceId={3d83a644-5463-4e29-912a-118835295d8d}"},{"type":"string","info":"ExceptionType=Microsoft.Online.Metrics.MetricsMP.Utilities.RPRequestFormatException"}],"code":"BadRequest","message":"Failed to find metric configuration for provider: Microsoft.Sql, resource Type: servers/databases, metric: cpu_limit, Valid metrics: cpu_percent,physical_data_read_percent,log_write_percent,dtu_consumption_percent,storage,connection_successful,connection_failed,connection_failed_user_error,blocked_by_firewall,deadlock,storage_percent,xtp_storage_percent,workers_percent,sessions_percent,sessions_count,dtu_limit,dtu_used,sqlserver_process_core_percent,sqlserver_process_memory_percent,sql_instance_cpu_percent,sql_instance_memory_percent,tempdb_data_size,tempdb_log_size,tempdb_log_used_percent,allocated_data_storage,ledger_digest_upload_success,ledger_digest_upload_failed"}}
      full_backup_size_bytes,diff_backup_size_bytes,log_backup_size_bytes : Request failed with status code 400: {"error":{"additionalInfo":[{"type":"string","info":"TraceId={61b9ffe6-9f16-4bef-aad4-9c42f59bc3d3}"},{"type":"string","info":"ExceptionType=Microsoft.Online.Metrics.MetricsMP.Utilities.RPRequestFormatException"}],"code":"BadRequest","message":"Failed to find metric configuration for provider: Microsoft.Sql, resource Type: servers/databases, metric: full_backup_size_bytes, Valid metrics: cpu_percent,physical_data_read_percent,log_write_percent,dtu_consumption_percent,storage,connection_successful,connection_failed,connection_failed_user_error,blocked_by_firewall,deadlock,storage_percent,xtp_storage_percent,workers_percent,sessions_percent,sessions_count,dtu_limit,dtu_used,sqlserver_process_core_percent,sqlserver_process_memory_percent,sql_instance_cpu_percent,sql_instance_memory_percent,tempdb_data_size,tempdb_log_size,tempdb_log_used_percent,allocated_data_storage,ledger_digest_upload_success,ledger_digest_upload_failed"}}
      

        1. image-2023-10-04-12-06-47-913.png
          33 kB
          Marco Hofmann
        2. image-2023-10-04-12-08-31-262.png
          9 kB
          Marco Hofmann
        3. image-2023-10-04-12-09-01-659.png
          156 kB
          Marco Hofmann
        4. image-2023-10-04-12-09-34-117.png
          49 kB
          Marco Hofmann
        5. image-2023-10-05-11-59-39-123.png
          30 kB
          Marco Hofmann

            abrosimovs Aleksejs Abrosimovs
            starko Marco Hofmann
            Team INT
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: