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

Increase gateway timeout for executing an action in Flow

We have a set of stored procedures in Azure database which needs to be run on daily basis, so we created a flow to run them and have set them in asynchronus pattern and Timeout as 60minutes (PT60M). One of the stored procedure needs around 20-30 minutes to complete its execution as it involves huge data manipulation.

But when flow is run, we are confronting 'Gateway Timeout' issue as below :
In Failure Summary :
"Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding"
and like this :

q2.png
Is there any way to increase the Gateway Timeout , so that execution of stored procedure could be allowed for specified timeout period ? Or any other way to resolve this issue. Any help is greatly appreciated.

 

9 REPLIES 9
Community Support Team
Community Support Team

Re: Increase gateway timeout for executing an action in Flow

Hi HemaR,

 

May you take this documentation on “Troubleshooting the On-Premises Data Gateway” for a reference:
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-tshoot/

 

It seems that you could try to determine the duration of a query.

 

Please check the doc for more details.


Best regards,
Mabel Mao

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

Re: Increase gateway timeout for executing an action in Flow

Hi Mabel,

 

Thank you for the reply. The documentation suggested was for on premises. But in our case database is in cloud , Azure SQL to be precise. How we can achieve to increase the query execution time for Azure SQL database ?

 

-Hema

 

tannerspaulding
Level: Power Up

Re: Increase gateway timeout for executing an action in Flow

I am facing the exact same issue and have not yet found a solution.  Have you had any luck since the last update? 

jmc
Level: Powered On

Re: Increase gateway timeout for executing an action in Flow

I've had the exact same issue for a couple weeks. I've tried everything I can think of... My sproc only takes about 5 minutes to run though and it still times out. 

DanielVillacis
Level: Power Up

Re: Increase gateway timeout for executing an action in Flow

Is there any news about this point?. I have a stored procedure in Azure SQL and it takes about 20 minutes to finish, but when I run the task in flow it onli last 10 minutes an the process stop.

saranya24
Level: Power Up

Re: Increase gateway timeout for executing an action in Flow

Hi ,

Facing similar issue. My query is very simple querying against Azure DB but takes lot of time and finally gives error message saying "connection timed out or server not responding"

Monkey_D_Luffy
Level: Power Up

Re: Increase gateway timeout for executing an action in Flow

It is 2019 now and I'm still having this 504 gateway timeout issue. When I use a dummy stored procedure for testing purpose, it has no such issue.

AlwasyMKT
Level: Powered On

Re: Increase gateway timeout for executing an action in Flow

Hi All,

 

Is there any updates about this issue? Please advise

 

Thank you.

Anonymous
Not applicable

Re: Increase gateway timeout for executing an action in Flow

Hi,

 

Is there some workaround for this? 120 seconds is a really low amount of time for bigger procedures!!

 

Thank you.

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

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

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

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!

Top Kudoed Authors (Last 30 Days)
Users online (6,615)