We are receiving the following Uipath error when we run a stored procedure. It only occurs when the result set takes over 30 seconds to return. We have checked SQL timeout settings, execution etc. and they are set as expected. Error and stack trace below. E:\CQRbot\Bots>ECHO — SAMPLE Change the at…

Hi Thom! Please check this post: [Bild] Timeout while executing database query Help Hello! You just have to add ;Connect Timeout=5000 on the Connection String. The Timeout must be in Milliseconds. Regards!

Connect Timeout is only for the connection. In this case, this is command Timeout that should be increase, but it is not possible in the connection string nor in the Execute Query activity…

You will have to specify the command time out period explicitly for the SPs running for long time. Use below code to build the connection and run a stored proc. CallStoredProcedure.xaml (10.6 KB)

[Capture] Timeout property not working for Execute Query activity…Can anyone help…

SQL Command Timeout

Help

ovi (Viorela Preda) 21. August 2017 um 20:49 2

Hi Thom!
Please check this post:

Thema		Antworten	Aufrufe
Error to execute store procedure Activities database , activities , question	1	515	29. August 2024
How can we increase SQL connecton time in uipath? Help database , activities	11	9009	23. August 2023
Command Timeout in Execute Query/Non Query activity Studio database , activities , completed	12	8886	25. April 2019
Timeout error on UiPath Help database , activities	3	4573	14. Mai 2018
uipath.Database.activities pack v1.4.0 Execute Query - timeout attribute is ignored Activities database , activities , question	0	949	30. September 2021

SQL Command Timeout

Verwandte Themen