Share via

Pipeline with Source (using self hosted IR) and Target(using Auto Resolve) is getting failed

kks8589 96 Reputation points
2020-09-28T07:08:57.29+00:00

Hi Team
I have a Source ADLS which is a vnet(created a linked service with self hosted IR)
I have a Target SFTP server.Linked service is created with Autoresolved intruntime.
Both linked services connections are successful

When i run the pipeline , the pipeline is getting failed with below error
ErrorCode=SftpNetworkIssue,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Meet network issue when connect to Sftp server 'xxxxxxxxx', SocketErrorCode: 'ConnectionReset'.,Source=Microsoft.DataTransfer.ClientLibrary.SftpConnector,''Type=System.Net.Sockets.SocketException,Message=An existing connection was forcibly closed by the remote host,Source=System

Could you please help on this issue

Thanks

Azure Virtual Network
Azure Virtual Network
An Azure networking service that is used to provision private networks and optionally to connect to on-premises datacenters.
2,219 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,845 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. KranthiPakala-MSFT 46,427 Reputation points Microsoft Employee
    2020-09-28T22:55:32.96+00:00

    Hi @kks8589 ,

    Welcome to Microsoft Q&A platform and thanks for your query.

    You issue seems to similar to this: SFTP Connection Issue
    Since your test connections are successful and failing only when you ran pipeline, it could be a networking issue on your SHIR hosted machine. Please validate your SHIR hosted machine network settings to allow connection to your sink SFTP server.

    Helpful info: Copy operation determining which IR to use

    28981-image.png

    Hope this helps. Let us know if you have further query.

    Thanks you
    Looking forward to your confirmation.