Cannot increase timeout for the SQL Server Gateway connection

(0) Share

Report

Posted on by skatzis

Hello,

I have a power automate flow that executes a database procedure to our sql server using a gateway connection.

This procedure when I run it manually it needs almost two minutes.

But when I run the flow, I have a timeout (which is 2 minutes).

I tried to increase this timeout but it seems that it's not working.

In the attached screenshot, you see the timeout settings and the output from the execution where it is obvious that 2 minutes timeout has not changed.

Am I doing anything wrong?

Thank you,

Nikos

Categories:

Using connectors

I have the same question (0)

All responses (4)

Answers (0)

Sort by

v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @skatzis ,

Please take a look at this doc.

https://learn.microsoft.com/en-us/azure/logic-apps/handle-long-running-stored-procedures-sql-connector

Best Regards,

Wearsky

Was this reply helpful? Yes No
skatzis 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Wearsky,

I read it and it's very complicated.
What I would like to know first is why PowerAutomate (or Gateway connector) ignores the timeout I have entered in the specific step of the flow.

Thank you for your reply,
Nikos

Was this reply helpful? Yes No
v-xiaochen-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @skatzis ,

I think it's a limitation.

https://learn.microsoft.com/en-us/connectors/sql/#general-known-issues-and-limitations

Best Regards,

Wearsky

Was this reply helpful? Yes No
skatzis 37 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello Wearsky,

If the timeout limit is 110 seconds and can't be changed then what is the meaning of the "Timeout" parameter in settings?
It's not working for a single query it says. Then how it works?

Thank you,
Nikos

Was this reply helpful? Yes No