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: [image] 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) Août 21, 2017, 8:49 2

Hi Thom!
Please check this post:

Sujet		Réponses	Vues
Error to execute store procedure Activities database , activities , question	1	516	Août 29, 2024
How can we increase SQL connecton time in uipath? Help database , activities	11	9009	Août 23, 2023
Command Timeout in Execute Query/Non Query activity Studio database , activities , completed	12	8887	Avril 25, 2019
Timeout error on UiPath Help database , activities	3	4573	Mai 14, 2018
uipath.Database.activities pack v1.4.0 Execute Query - timeout attribute is ignored Activities database , activities , question	0	949	Septembre 30, 2021

SQL Command Timeout

Sujets connexes