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

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.

 

10 REPLIES 10
Highlighted
Community Support
Community Support

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.
Highlighted
Regular Visitor

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

 

Highlighted
New Member

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? 

Highlighted
Regular Visitor

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. 

Highlighted
New Member

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.

Highlighted
New Member

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"

Highlighted
New Member

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.

Highlighted
Frequent Visitor

Re: Increase gateway timeout for executing an action in Flow

Hi All,

 

Is there any updates about this issue? Please advise

 

Thank you.

Highlighted
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.

Highlighted
Helper I
Helper I

Re: Increase gateway timeout for executing an action in Flow

Hi all,

 

today I managed to change Time out and Retry Settings in my Flow. Hope this could help you:

 

timeout 1.PNGtimeout 2.PNG

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (6,184)