03-04-23 03:11 PM
Hi all,
I am attempting to run a delete SQL query on a DB in Blue Prism. I have my flow built, but I am getting:
'Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Operation cancelled by user. The statement has been terminated.'
I have found the following support article and modified the Open code stage in the SQL VBO object with the supplied code, but still get timeouts after 30 seconds:
Support Center | Blue Prism Portal
Blueprism | remove preview | ||||||
|
The database being connected to is an Azure hosted SQL DB, could this be part of the issue?
04-04-23 09:36 AM
Can't see the link Craig but I'm guessing it relates to specifying the timeout value. You can set this as part of the connection string, for example:
https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqlconnection.connectionstring?view=dotnet-plat-ext-7.0
04-04-23 09:51 AM
Hi John,
Looks like the forum consumed the link!
Tried your suggestion but still getting the 30 second timeout unfortunately.
04-04-23 10:14 AM
Hmm strange. Are you sure the flow is passing through one of the Set Connection calcs and both will set the timeout value?
04-04-23 10:36 AM
Yes, stepping through the process I can see it pass through the node with the Connection Timeout extra string above.
I am beginning to think it's perhaps something to do with the DB being Azure hosted and there is a setting overruling it there. I'll speak to our Azure admin to do some digging that side!
04-04-23 01:24 PM
cmd.CommandTimeout = Convert.ToInt32(timeout)
In this case, we created a "Timeout" parameter for the action that we can set to any value but you could hardcode a value (shameful) if you want.
------------------------------
Micheal Charron
Senior Manager
RBC
America/Toronto
------------------------------