I am executing a Query on a MySql server, using the Execute Query activity. The Query is expected to take up to a minute. Every other time, the Query is failing due to a timeout on the connection, with the following message: Could not kill query, aborting connection. Exception was Unable to read d…

Timeout while executing database query

Lucas.Pimenta (Lucas Pimenta) January 5, 2017, 1:21pm 3

Hello!

You just have to add ;Connect Timeout=5000 on the Connection String. The Timeout must be in Milliseconds.

Regards!

5 Likes

How can we increase SQL connecton time in uipath?

Command Timeout in Execute Query/Non Query activity

SQL Command Timeout

Bot Time Out Error(Execute Query)

Topic		Replies	Views
Change Database Query Timeout Help database , studio	11	8482	November 13, 2017
Execute Query : Execution timeout expired Help database	5	3158	October 15, 2019
Command Timeout in Execute Query/Non Query activity Studio database , activities , completed	12	8200	April 25, 2019
How can we increase SQL connecton time in uipath? Help database , activities	11	8417	August 23, 2023
The timeout period elapsed prior to completion of the operation or the server is not responding StudioX studiox , question	7	1703	August 15, 2023