Hi,
I am trying to execute Stored Procedure(SP) in Power Automate which takes 10 mins to complete but SP timeout after 2 minutes.
Even when the timeout is changed to 1 hour, somehow it is not using it
Hi @LeeHarris
I have the same problem and yes, my stored procedure does run perfectly well when executed in SQL. Mine takes just over 2 mins when executed directly in SQL. I suspect it has something to do with a second stored proc which I am triggering from inside the stored proc called from the flow. When that second (nested) stored proc takes over two minutes to run, then the flow times out. If that one runs under 2 mins, then flow is fine. Is that possible? Is there a workaround?
Regards
Lael
Date of posting: 01-14-2020 06:53 PM
Hi,
I have the same problem. Did you find a solution?
Thanks!
Hi @LeeHarris : The Stored procedure works fine in SQL
Hi @Anonymous
Does your Stored Procedure complete successfully without timing out when executed directly in SQL (assuming it also takes 10 minutes to execute)?
Tomac
986
Moderator
stampcoin
699
Super User 2025 Season 2
Riyaz_riz11
577
Super User 2025 Season 2