代码之家  ›  专栏  ›  技术社区  ›  Boris K

Azure Logic App Application Insights电子邮件失败

  •  0
  • Boris K  · 技术社区  · 9 年前

    我正在运行的查询在Application Insights Metrics Explorer中运行良好。

    以下响应失败:

    标题:

    {
      "Pragma": "no-cache",
      "Timing-Allow-Origin": "*",
      "Cache-Control": "no-cache",
      "Date": "Thu, 13 Jul 2017 07:33:15 GMT",
      "Server": "Microsoft-IIS/8.0,Microsoft-HTTPAPI/2.0",
      "X-AspNet-Version": "4.0.30319",
      "X-Powered-By": "ASP.NET",
      "Content-Length": "2197",
      "Content-Type": "application/json",
      "Expires": "-1"
    }
    

    {
      "error": {
        "code": 500,
        "message": "\"Microsoft.ApplicationInsights.DraftClient.Exceptions.FailedToParseDraftQueryResponseException: Failed to convert table (JToken) to Table object ---> System.ArgumentException: Can not convert Null to Int32.\\r\\n   at Newtonsoft.Json.Linq.JToken.op_Explicit(JToken value)\\r\\n   at Newtonsoft.Json.Linq.JToken.ToObject(Type objectType)\\r\\n   at Microsoft.ApplicationInsights.DraftClient.Helpers.DraftResponseParser.ConvertToTable(JToken token)\\r\\n   --- End of inner exception stack trace ---\\r\\n   at Microsoft.ApplicationInsights.DraftClient.Helpers.DraftResponseParser.ConvertToTable(JToken token)\\r\\n   at Microsoft.ApplicationInsights.DraftClient.Helpers.DraftResponseParser.ParseDraftQueryResponse(String draftQueryResponseInJson)\\r\\n   at Microsoft.ApplicationInsights.DraftClient.DraftApiClient.<ExecuteQueryAsync>d__10.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at Microsoft.ApplicationInsights.DraftClient.DraftApiClient.<ExecuteQueryAsync>d__9.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at DraftFlowConnector.VisualizeDraftResults.<RunAsync>d__6.MoveNext()\\r\\n--- End of stack trace from previous location where exception was thrown ---\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)\\r\\n   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()\\r\\n   at DraftFlowConnector.VisualizeDraftResults.<RunAsync>d__5.MoveNext()\""
      }
    }
    

    1 回复  |  直到 9 年前
        1
  •  1
  •   Harel Broitman    9 年前

    我们将对此进行修复,同时,您可以通过向查询中添加“where”语句来解决此问题,该语句可以过滤出相关数值列中包含空值的行,例如:

    | where tostring(columnName) != ""