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

settings.jpg

I have the same question (0)

All responses (4)

Answers (0)

v-xiaochen-msft on at

Like (0)

Report

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 (0)

Report

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 on at

Like (0)

Report

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 (0)

Report

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