You’re offline. This is a read only version of the page.
13
I have a flow set up that copies files from an SFTP site to a local folder.
Most of the time it works, but sometimes I get a failure:
"message": "Unable to connect to the remote server '
During the flow process, it reads the list of files in the folder, then iterates through the list to get the file content and create a file in the new location with that content. I had connection to the server in order to read the name of the file. I had connection to the server in order to copy over the other dozen files. But one or two (non-sequential) iterations will give me a problem, then the flow will continue and the next file will work.
If I rerun the flow a bunch of times, it doesn't always happen on the same file. Sometimes A will work and B won't, but then the next run, A won't and B will.
Any ideas on why I might get this error sometimes, but not others?
Hi @SP8 ,
Could you share a screen shot of the flow?
How large the file size is? The maximum file size limit is 100 MB, however, not all APIs support the full 100 MB:
https://docs.microsoft.com/en-us/flow/limits-and-config
Further, from the doc on connector SFTP, “This operation copies a file to an SFTP server. If a file is being deleted/renamed on server right after it was copied, connector may return HTTP 404 error by it's design. Please use a delay for 1 minute before deleting or renaming newly created file”.
Please try to add Delay action in the flow to see if it will work.
Best regards,
Mabel
I only have the corporate antivirus which I can't do anything about, but it's the corporate SFTP and doesn't give me any kinds of errors with anything else. I'm using port 22 (per corporate IT) and it generally works.
Again, this is intermittent. It will literally work 56/60 times in the same run of the flow, then 48/60 the next, then 59/60...
Also, it used to always work.
Hi @SP8 ,
Have you checked your firewall settings?
Which port are you using to connect to the Server?
Do you have any antivirus? Please try to disable the antivirus to see if it will work.
Further, I have seen a blog on Microsoft (MS) Flow SFTP connector tips, tricks, and errors, please check it for a reference:
https://blog.neilsabol.site/post/microsoft-ms-flow-sftp-connector-tips-tricks-errors/
Best regards,
Mabel
#1
WarrenBelz
146,524
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,906
Most Valuable Professional
Share
Report
All responses (
Answers (
