Http Source到Azure SQL表 [英] Http Source to Azure SQL table

问题描述

您好，

我正在从事数据工厂复制活动，并且在将http源转换为azure sql作为目标表时遇到了问题.

I am working on data factory copy activity and facing issue on http source to azure sql as destination table.

以下是错误

{"errorCode":"2200"，"message":"'Type = Microsoft.DataTransfer.Common.Shared.HybridDeliveryException，Message =读取HTTP文件超时，请指定 较长的httpRequestTimeout，以毫秒为单位.，Source = Microsoft.DataTransfer.ClientLibrary，''Type = System.Net.WebException，Message =操作已超时.，Source = System，'''，"failureType":"UserError" ;，"target":"PushDirectExpenseData" }

{ "errorCode": "2200", "message": "'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Read http file timeout, please specify a longer httpRequestTimeout in millisecond.,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.WebException,Message=The operation has timed out.,Source=System,'", "failureType": "UserError", "target": "PushDirectExpenseData" }

http来源我们提供了一个简单的get方法，该方法返回json数组，并使用sql接收器将数据插入sql表，此过程仅适用于15条记录，但超过15条记录则无效.数据工厂作业运行5分钟并出现错误 超时错误.我已将复制活动源处的httprequest超时指定为00:30:00

http source us simple get method which returns json array and using sql sink inserting the data to sql table and this process works for only 15 record but more than 15 record it is not working. the data factory job runs for 5 mins and getting above error timeout error. i have specified httprequest time out at source of copy activity as 00:30:00

请帮忙，因为这对我们来说是个表演障碍. http源get方法也可能返回超过50K的记录.

Please help on this as this is a show stopper for us. the http source get method may return more than 50K record also.

推荐答案

嗨

Hi DELSUNDAS I'm sorry to hear that you are facing this issue. This will require some deeper analysis. Can you please file a support request @ https://aka.ms/azsupt? If you do not have access to a support plan, please reach out @ [e-mail] with a link to this Doc/Issue as well as your subscription ID and we can help get the support ticket opened for this issue. Please share your answer here so it can help other users facing the same issue.

这篇关于Http Source到Azure SQL表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！