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: [imagem] 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) Agosto 21, 2017, 8:49pm 2

Hi Thom!
Please check this post:

Tópico		Respostas	Visualizações
Error to execute store procedure Activities database , activities , question	1	515	29 de Agosto de 2024
How can we increase SQL connecton time in uipath? Help database , activities	11	9009	23 de Agosto de 2023
Command Timeout in Execute Query/Non Query activity Studio database , activities , completed	12	8886	25 de Abril de 2019
Timeout error on UiPath Help database , activities	3	4573	14 de Maio de 2018
uipath.Database.activities pack v1.4.0 Execute Query - timeout attribute is ignored Activities database , activities , question	0	949	30 de Setembro de 2021

SQL Command Timeout

Tópicos relacionados