Share via

self-hosted Integration runtime datafactory copy fails: The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.

YusufD 0 Reputation points
2024-07-29T11:26:28.19+00:00

In datafactory we have a step to copy data from the on-premises oracle database to azure blob storage (private endpoint) with a self-hosted integration runtime. This self-hosted integration runtime has access to the blob storage.

But the copy steps fails and produces this error.

ErrorCode=AdlsGen2OperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=ADLS Gen2 operation failed for: An error occurred while sending the request.. Account: 'x'. FileSystem: 'x'..,Source=Microsoft.DataTransfer.ClientLibrary,''Type=System.Net.Http.HttpRequestException,Message=An error occurred while sending the request.,Source=mscorlib,''Type=System.Net.WebException,Message=The underlying connection was closed: Could not establish trust relationship for the SSL/TLS secure channel.,Source=System,''Type=System.Security.Authentication.AuthenticationException,Message=The remote certificate is invalid according to the validation procedure.,Source=System,'

We have also tried using 2 different IR'S, for the source the self-hosted integration runtime and for the sink the managed virtual network. But it still produces the same error output. We are unable to determine a solution to this problem, we would greatly appreciate any assistance in resolving this issue.

Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
2,946 questions
Azure Blob Storage
Azure Blob Storage
An Azure service that stores unstructured data in the cloud as blobs.
2,644 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,204 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Amrinder Singh 4,910 Reputation points Microsoft Employee
    2024-07-29T13:25:11.31+00:00

    Hi YusufD - Thanks for reaching out over Q&A Forum.

    The below links talks about the issue being reported due to missing certification or some proxy being used resulting in change of the certificate.

    https://learn.microsoft.com/en-us/azure/data-factory/self-hosted-integration-runtime-troubleshoot-guide?tabs=data-factory#couldnt-establish-a-trust-relationship-for-the-ssltls-secure-channel

    There is also a below previous post wherein the issue was resolved after working with the support team by providing the required certificates.

    https://learn.microsoft.com/en-us/answers/questions/104654/integration-runtime-offline-the-underlying-connect

    Below is an additional link to review:

    https://learn.microsoft.com/en-us/azure/data-factory/create-self-hosted-integration-runtime?tabs=data-factory#tlsssl-certificate-requirements

    I would suggest to first follow the initial link for the action plan suggested to see if that helps. If not, you might need to raise support ticket further.

    Hope that helps!

    Please let me know if there are any further queries/concerns, will be glad to assist.

    Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.