none
Http Source to Azure SQL table

    Question

  • Hi Team,

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

    below is the error

    { "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 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

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

    Tuesday, September 18, 2018 3:25 PM

All replies

  • 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 @ AZCommunity@microsoft.com 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.
    Friday, September 21, 2018 5:26 PM
  • Can you share a runId and your subscription with us?
    Tuesday, October 9, 2018 3:18 AM