Error writing to Datalake Gen 2

Silvano P 101 Reputation points


my Source is a SQL Server, queried with a Self Hosted IR Runtime and my sink is a Datalake Gen 2,

I get the following Error

Failure happened on 'Sink' side. ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: Operation returned an invalid status code 'Forbidden'. Account: 'mydatalake'. FileSystem: 'temp'. Path: 'NavTemp/navcustomer.csv'. ErrorCode: 'AuthenticationFailed'. Message: 'Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature.'. RequestId: '1148db6e-a01f-0069-616e-d94891000000'. TimeStamp: 'Wed, 23 Dec 2020 20:59:25 GMT'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Operation returned an invalid status code 'Forbidden',Source=,''Type=Microsoft.Azure.Storage.Data.Models.ErrorSchemaException,Message=Operation returned an invalid status code 'Forbidden',Source=Microsoft.DataTransfer.ClientLibrary,'

If I read from other Sources (using Self Hosted or Azure IR) and write to the same DataLake it works.

Could it be the Source?

Thank you so much

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

1 answer

Sort by: Most helpful
  1. Silvano P 101 Reputation points

    It was a Firewall issue!

    1 person found this answer helpful.