cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SP8
Frequent Visitor

Intermittent 404 error

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?

3 REPLIES 3
v-yamao-msft
Community Support
Community Support

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
SP8
Frequent Visitor

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.

v-yamao-msft
Community Support
Community Support

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

 

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (1,850)