StrataFrame Forum » Enterprise Server - V1 » Issues » ES Timeout

ES Timeout

Danny Doobay — Thu, 17 Oct 2013 15:46:31 GMT

I have a stored procedure in SQL server which will run for a while. When I call the stored procedure from the application ES returning "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding"

Dim SqlCommand As New SqlCommand

Try

SqlCommand.CommandText = "MyProcedure"

SqlCommand.CommandType = CommandType.StoredProcedure

Me.ExecuteNonQuery(SqlCommand)Catch ex As ExceptionApplicationEventLog.WriteException(ex, False)

End Try

What can I do?

RE: ES Timeout

Danny Doobay — Thu, 17 Oct 2013 15:46:31 GMT

Thanks guys.

RE: ES Timeout

StrataFrame Team — Thu, 17 Oct 2013 13:19:13 GMT

Edhy beat me to it by a few seconds.

RE: ES Timeout

StrataFrame Team — Thu, 17 Oct 2013 13:18:50 GMT

You can set the SqlCommand.Timeout. The default value is 30, which will cause the SQL Server connector to throw an exception if the command hasn't been completed in 30 seconds. You can set it to 0, which means "no timeout". Or you can set it to any number of seconds that you want.

RE: ES Timeout

Edhy Rijo — Thu, 17 Oct 2013 13:17:24 GMT

Hi Danny,

Set the timeout to the connection to 0 to allow your sp to run properly.

SqlCommand.Timeout = 0