Azure DataFactory Synapse: Error while copying data from http source to ADLS Gen2

Wafaa HAOURAJI 1 Reputation point
2021-12-28T09:59:14.127+00:00

......................................

Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,559 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. svijay-MSFT 5,256 Reputation points Microsoft Employee Moderator
    2021-12-29T07:26:03.59+00:00

    Hello @Wafaa HAOURAJI ,

    Thanks for the question and using MS Q&A platform.

    Is the issue intermittent or are you getting the error all instances?

    if the issue is intermittent :

    Issue could be because of throttling that is happening at the sink end. Since it is not sequential, you have higher possibility of hitting the throttling as lot request at the same time

    It is suggested to add a retry logic at activity level to secure pipelines against such intermittent errors.

    161060-image.png

    You could modify and have Retry above 0.

    Alternatively, you could save the files sequentially and see whether you re encountering the issue.

    Hope this will help. Please let us know if any further queries.

    ------------------------------

    • Please don't forget to click on 130616-image.png or upvote 130671-image.png button whenever the information provided helps you. Original posters help the community find answers faster by identifying the correct answer. Here is how

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.