The timeout period elapsed prior to completion of the operation or the server is not responding

i always get error Run query: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. when in Run Query Activity. I already add connect timeout but still received this error.

here is my connection string.

Data Source=Server1;Initial Catalog=SampleDb;Integrated Security=True;Connect Timeout=1000000;Encrypt=False

@arthurang

If the timeout is set too short, you might need to increase the timeout value in the activity or method that is causing the error. This gives the operation more time to complete.

1 Like

hi @rlgandu thank you for your reply. so i still need to change my timeout value which is 1000000 already. what is the maximum value for the timeout. thank you.

@arthurang

There isn’t a strict “maximum” timeout value because it depends on the context of your automation and the operation you’re trying to perform

1 Like

thank you. @rlgandu i’ll get back to you once i successfully get the correct timeout value.

Hi @arthurang

Instead of giving timeout in the connection string try giving that in Run Query activity property it might solve the error. Set the value of the “TimeoutMS” property to a higher value, such as 60000 for 1 minute or even higher depending on the complexity of your query and the resources available.

Hope it helps!1

1 Like

@arthurang

If you find the solution for your query please mark it as solution to close the loop.

Happy Automation
Regards

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.