Sftp connection failing in ADF

Question

Hi,

We have created a dataflow which has sftp as source and Azure SQL as sink. This data flow will be executed in ADF pipeline. Till yesterday 4PM pipeline execution is successful but after that execution was failing with error 'job failed due to reason source session is down'. Then we have tried testing linked service of SFTP and test connection failed with error 'Failed to connect SFTP server'. This issue is happening in both non prod and prod subscription. Can anyone please suggest on this issue.

Answer 1

Hi

Thanks for reaching out to Microsoft Q&A.

Check with the source if there is any firewall block or session timeout has been set recently. If you see your connection worked fine few days ago but not now there are chances that some changes would have been taken place, pls check with the source sftp provider once.

Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.

Answer 2

Hello @Dande, Venkata Subhashini
Just checking if we are still connected on this discussion? Please let us know if you need to add more info so that we better assist you!

It might be an intermittent error, please try again from your side and do let us know if you face any further errors!!! happy to help you further, please send us an email or comment in the below section and we will help you!