Data Factory: Error Code 24200: Unable to establish a connection from link service to Data lake v2

Justin Hughes 1 Reputation point
2021-11-29T14:00:56.793+00:00

Hello everyone,

Apologies if this has already been asked, but I cannot find any similar answers on this forum.

I am following an online course for Azure Data Factory and I'm setting up a pipeline. Right now this pipeline only has one activity (a copy activity) and it is set up so that:

  • the link service for the source connects a Blob Storage container
  • the link service for the sink connects a Data Lake V2 storage container.

When I try to test the connection for the Source, it is successful, but the connection for the Sink gives the following message:

Error Code: 24200
Details: ADLS Gen2 operation failed for: Operation returned an invalid status code 'Conflict'. Account: '********'. ErrorCode: 'EndpointUnsupportedAccountFeatures'. Message: 'This endpoint does not support BlobStorageEvents or SoftDelete. Please disable these account features if you would like to use this endpoint.'. RequestId: 'd144c292-301f-0028-2522-e50b56000000'. TimeStamp: 'Mon, 29 Nov 2021 13:10:43 GMT'.. Operation returned an invalid status code 'Conflict' Activity ID: b6d32fbf-fb92-4eb9-bb5b-ba3bb1f510b6.

Running the whole pipeline gives the same error.

Also I censored the account name on purpose.

Please let me know if you need any more info, screenshots or anything. I appreciate all the help.

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.
894 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,271 questions
{count} votes

2 answers

Sort by: Most helpful
  1. PRADEEPCHEEKATLA-MSFT 53,096 Reputation points Microsoft Employee
    2021-11-30T07:16:27.81+00:00

    Hello @Justin Hughes ,

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

    Could you please share the authentication method used to connect the Azure Data Lake V2 storage account linked service?

    Meanwhile, I would suggest you to disable the soft deletion option at storage account level and see if that works.

    153623-image.png

    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
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification
    • If you are interested in joining the VM program and help shape the future of Q&A: Here is how you can be part of Q&A Volunteer Moderators

  2. Tamur Aziz 1 Reputation point
    2022-02-16T19:50:41.227+00:00

    Yes it did help me too actually i was using Student version. But it works. thanks.
    Just disable the boht storage account.

    No comments