cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SP8
Level: Powered On

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
Community Support Team
Community Support Team

Re: Intermittent 404 error

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
Level: Powered On

Re: Intermittent 404 error

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.

Community Support Team
Community Support Team

Re: Intermittent 404 error

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
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Users online (4,486)