Unanswered

GatewayTimeout error when running stored procedure

(0) Share

Report

Posted on by JoHacker

I am trying to create a flow which will run a stored procedure on an Azure database. When running the procedure on the server, it takes approximately 1 minute to complete. When I run it using either the SQL server or Azure Data Warehouse actions to Execute Stored Procedure, I get a timeout error.

Even though the settings say that the item is running asynchronously, it doesn't seem to have actually started the procedure as no data is updated on the server. I don't actually need a result set, so if it's possible to get it run truely async, that would do as a solution, or if I can get the timeout increased.

I have run a simple SQL statement (select getDate()) on the connection so there is no problem reaching or getting responses from the server.

Categories:

Using connectors

I have the same question (0)

All responses (5)

Answers (1)

v-bacao-msft on at

Like (0)

Report

Re: GatewayTimeout error when running stored procedure

Hi @JoHacker ,

Could you share the details of the Flow configuration?

I can't reproduce a similar issue on my side.

You could try to update the connection and check if a similar problem still exists.

Best Regards,

Was this reply helpful? Yes No
JoHacker 13 on at

Like (0)

Report

Re: GatewayTimeout error when running stored procedure

Sure. Here is what the flow itself looks like:

And here are the settings for the Execute stored procedure task:

When I've got the exec part working, the manual trigger will be replaced with a schedule, but for the moment, I just want to get this part working!

Was this reply helpful? Yes No
Verified answer

JoHacker 13 on at

Like (1)

Report

Re: GatewayTimeout error when running stored procedure

For anyone looking at this via Google, it turned out this was being caused by the Flow using a corrupted query plan that's not used by SSMS. To fix it, I switched to using an SQL query (rather than the exec stored proc task) and set the query to "set arithabort on; exec stored_proc_name;" and that worked like a charm.

Was this reply helpful? Yes No
srduval 1,760 Moderator on at

Like (0)

Report

Re: GatewayTimeout error when running stored procedure

@v-bacao-msft I'm having the same problem as the original poster. Using the execute stored procedure action, it runs forever before finally timing out with a gateway error. sp only takes a minute or two on the azure server directly

Was this reply helpful? Yes No
AdilAlhilali 2 on at

Like (0)

Report

Re: GatewayTimeout error when running stored procedure

in my case, There was an issue with the SQL stored procedure as it was returning more than 1 select statment (more than 1 table) which resulted in the exact errors mentioned in this post

Was this reply helpful? Yes No