Hi Guys When i execute an update query(Multiple rows) in Execute Non query tag. It is timing out and query is not getting executed. Please help me out

Does your update statement take more time ?? Try to put in a higher value in the TimeoutMS property. To identify the optimum timeout val , execute the update via Toad etc … Check the time taken for the update to complete. Add some buffer say 30 - 60 sec more to the actual time taken , and update th…

@Kamesh You may look into this post. I have given a sample code. [image] SQL Command Timeout Help 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. CallStoredP…

[quote=“krishnamak01, post:2, topic:34491”] ay 30 - 60 s [/quote]Thanks Krishna it actually takes 3-4 Minutes for the update to get completed

Hi @Kamesh , I had the same problem with “Execute Non Query” Activities. I solved it doing the Query for each row of the DT. [imagen] When I put the “Execute Non Query” outside of the “For each row” process failed with timingout error. But doing this, I solved the problem. Please share to me your …

How can I modify the CallStoredProcedure.xaml code to run a query with a long command timeout instead of a stored procedure?

Execute Non Query Issues

Help

Madhavi_Jaiswal (Madhavi Jaiswal) May 29, 2018, 9:55am 3

@Kamesh
You may look into this post. I have given a sample code.

Topic		Replies	Views
Execute non query - Not timing out Help orchestrator	3	1533	October 12, 2018
Command Timeout in Execute Query/Non Query activity Studio database , activities , completed	12	8835	April 25, 2019
Problem in Executing the Update statement in Database using Execute Non Query Activity Academy Feedback datatable , activities , studio	3	3113	August 8, 2019
Bot Time Out Error(Execute Query) Help activities	7	3346	October 16, 2019
SQL Command Timeout Help database , activities	4	7735	June 29, 2022

Execute Non Query Issues

Related topics