ADF copy activity dyanamic-crm to sql server, fault tolerance not working

NANAWARE, Sagar 6 Reputation points

We Add copy activity to copy data from CRM dynamic 365 entity to Sql server table
If there is no error then activity is successfully completed and copy data to destination but
We added fault tolerance (skip incompatible row) and provide folder path of blob storage for logging

but if any error occur while copying data then it will create black file in blob storage and failed copy activity, no data is copy to destination
could you please give solution for this problem?

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,909 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. BhargavaGunnam-MSFT 28,111 Reputation points Microsoft Employee

    Hello @NANAWARE, Sagar ,

    I was able to reproduce the issue from my end. When you enable fault tolerance and select skip incompatible rows, it always captures the log file with header info even if there are no 'Incompatible rows' or pipeline activity failed.

    This is expected behavior as of now.

    I saw the below product feedback request to Prevent the Creation of Empty Log Files.

    Appreciate if you could upvote and comment on this feedback. All the feedback shared in this forum is actively monitored and reviewed by the product team which will prioritize them accordingly based on the number of requests.
    Hope this info helps.