Execute Non Query Issues

[Kamesh]

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

[sai.kiran]

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 that in TimeoutMS…

[Madhavi_Jaiswal]

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

SQL Command Timeout

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)

[Kamesh]

[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

[Pablo_Sanchez (Pablo Sánchez Hernández)]

Hi @Kamesh, I had the same problem with “Execute Non Query” Activities. I solved it doing the Query for each row of the DT.

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 results, I hope it helps.

Best regards ,
Pablo

[Kamesh]

Thanks Pablo will try

[Pablo_Sanchez (Pablo Sánchez Hernández)]

Your welcome @Kamesh

[mfrater (Mark Frater)]

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