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

Send file from Azure Blob Storage to SSH-SFTP takes too long

Hi, I have a flow which sends files created in azure blob storage to SFTP.

Flow works good, but takes too long to upload file to SFTP (between 10 minutes to 20).

When I look at the run history, the SFTP block says it has 2 retries, and the status is BADGATEWAY. But, as I said, the process ends up correctly (after more than 10 minutes)

Is this by design or am I doing something wrong?

Also, how can I get notified if file was not uploaded? Currently my flow notifies me success termination, but in future I would rather have it doing the opposite: notifying me a failure to upload to SFTP.

 

This is the flow:

112233

 
1 ACCEPTED SOLUTION

Accepted Solutions

@Astur_Iano 

 

When you are using this action, there is a throttling limits for SSH-SFTP.

1.JPG

For more information, you can check https://docs.microsoft.com/en-us/connectors/sftpwithssh/

 

Throttling is always an import factor plays in the performance of the flow. 

 

Due to throttling, you are observing multiple re-tries. Only 150 calls per connection and it renews the connection every 60 seconds. I am not surprised with this throttling limits, your process is taking time.

 

Also, I came across the following discussion lots of people had similar issue and there are some workaround discussed:

https://github.com/Microsoft/azure-pipelines-tasks/issues/3485

 

I hope my replies helped you. If they did, can you please mark the reply as Accepted Solution.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

 

 

 

 

View solution in original post

3 REPLIES 3
Super User II
Super User II

@Astur_Iano 

 

There are many blogs on exception handling in Power Automate.

 

After your create file, you can create a Scope action and place any number of actions. Right click on 3 dots in the scope action to set "Configure to run after" and select on failure of Create File action.

 

Here are couple of blogs:

https://flow.microsoft.com/en-us/blog/error-handling/

https://poszytek.eu/en/microsoft-en/office-365-en/powerautomate-en/try-catch-pattern-in-microsoft-fl...

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

 

Thank you @rsaikrishna I have checked those links and they are very valuable for checking failures.

About my first question (long time to upload), any suggestions?

Thanks.

@Astur_Iano 

 

When you are using this action, there is a throttling limits for SSH-SFTP.

1.JPG

For more information, you can check https://docs.microsoft.com/en-us/connectors/sftpwithssh/

 

Throttling is always an import factor plays in the performance of the flow. 

 

Due to throttling, you are observing multiple re-tries. Only 150 calls per connection and it renews the connection every 60 seconds. I am not surprised with this throttling limits, your process is taking time.

 

Also, I came across the following discussion lots of people had similar issue and there are some workaround discussed:

https://github.com/Microsoft/azure-pipelines-tasks/issues/3485

 

I hope my replies helped you. If they did, can you please mark the reply as Accepted Solution.

 

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted SolutionMarking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

 

 

 

 

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (7,083)