RE: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
Hello Rick,
Thanks for Norman's suggestion.
I noticed the exception was raised by SqlCommand.ExecuteNonQuery() method.
Stack Trace:
...
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
Have you tried increasing the SqlCommand.Timeout property?
The default value of SqlCommand is 30 (30 seconds).
It seems this process need much more time to run. Maybe you should increase
the timeout of this command.
Hope this helps.
Best regards,
Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
.
Relevant Pages
- Connection Pooling Problem?
... The SqlCommand is currently busy Open, Fetching. ... Exception Details: System.InvalidOperationException: The SqlCommand is currently busy Open, ... Information regarding the origin and location of the exception can be identified using the exception stack trace below. ...
(microsoft.public.dotnet.general) - Re: The IListSource does not contain any data sources.
... The IListSource does not contain any data sources. ... Exception Details: System.Web.HttpException: The IListSource does not ... be identified using the exception stack trace below. ...
(microsoft.public.dotnet.framework.aspnet) - Re: Intermittant Server Error reading an MS Access DB
... Chuck ... > Dim i As Integer ... >> exception can be identified using the exception stack trace below. ...
(microsoft.public.dotnet.framework.aspnet) - Re: Timeout expired. The timeout period elapsed prior to completion of the operation or the server
... Ther are two types of timeout exception that could be raised by SqlClient objects: ... SqlCommand's Timeout decides how long time a command is given for the application that uses the SQlCommand to wait for SQL Server to finish the operation invoced by the SqlCommand. ... System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) ...
(microsoft.public.dotnet.framework.adonet) - Re: ASP.NET 2.0 Web Page Problem?
... Based on the stack trace you've shown the problem is when the Operations_HBMBlockStatus page's Repeater1 ItemCreated event is being raised. ... You sister site might be hiding the exception by logging it or ignoring them somehow, I'd need to see the code to say for sure. ... I have obtained a scripted database and compiled ASP.NET 2.0 application from a sister site that I'm trying to implement locally. ... An unhandled exception occurred during the execution of the current web request. ...
(microsoft.public.dotnet.framework.aspnet) |
|
