Execute Non Query Issues


#1

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


#2

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…


#3

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


#4

[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


#5

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

Best regards :mage:,
Pablo


#6

Thanks Pablo will try


#7

Your welcome @Kamesh