cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
New Member

Could not set the time out value when executing a sql server query task in a Power Automate

What we are trying to do: Since our SQL server query  task is taking more than 2 minutes we want to set the timeout to more than 2 minutes in our Power Automate. We are following the

instruction from this link -> https://docs.microsoft.com/en-us/power-automate/limits-and-config

We are setting the duration in the ISO 8601 format.

 

Issue: We have set the timeout settings to 30 minutes for Power Automate SQL Server query task. Still it keeps on failing when the execution exists in 2 minutes. Please see the below screen shot. The timeout is not taking effect. It still times out at 2 minutes.

 

subhashc_0-1597181659875.png

 

3 REPLIES 3
Advocate II
Advocate II

Hi,

 

I got the same issue and can't find a way to dissolve it.

Because this is the basic limited by Microsoft automate, below is the explanation:

Hope it's helpful to you.

https://docs.microsoft.com/en-us/power-automate/limits-and-config

 

Sql-lamited.PNG

ilu989

Frequent Visitor

Hi,

I have the same problem. Did you find a solution?

Thanks!

Regular Visitor

Hi subhashc, 

 

I unfortunately dont have a solution to your issue as I dont think it is possible as Stored Procedures seem to be executed synchronously and not asynchronous (as it would require for extending the timeout - see first table https://docs.microsoft.com/en-us/power-automate/limits-and-config). However, I was able to find 2 alternatives, which might be helpful for you.

1. If the stored procedures are run on a scheduled basis, you can instead use Azure's Automation with Powershell script running on a predefined schedule (https://global.hitachi-solutions.com/blog/azure-sql-databases-stored-procedure)

2. I was able to rewrite the Stored Procedure for my query, to take in the ID of the row it should use for the transformation, which speeds up the processing time and kept it under 2 minutes. 

 

I hope that they might help you but if you find a better way, please let me know.

 

 

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

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 (91,631)