469,623 Members | 1,097 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,623 developers. It's quick & easy.

How to solve timeout problem?

BVM
Hi, All:

I have this error. It seems execution time is too long. Actually the execution time is about 30 seconds(I tested in Query analyzer). How do I solve this problem?

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
--- End of inner exception stack trace ---
Thanks,

Dennis Huang

Nov 15 '05 #1
1 5250
Hi,

I think, to solve such problem you could adjust "SQL Server Properties->Query time-out" value using SQL Server Enterprise Manager or 'sp_configure' system stored procedure. By default this value = 30 seconds.
Also, do not forget to set correct value for SqlCommand.CommandTimeout (again, the default value is 30 seconds).
--
Andrew Gnenny
X-Unity Test Studio
http://x-unity.miik.com.ua/teststudio.aspx
Bring the power of unit testing to VS .NET IDE
"BVM" <De*****@TBH.com.au> wrote in message news:uh**************@TK2MSFTNGP10.phx.gbl...
Hi, All:

I have this error. It seems execution time is too long. Actually the execution time is about 30 seconds(I tested in Query analyzer). How do I solve this problem?

System.Web.Services.Protocols.SoapException: System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlCommand.ExecuteReader(Com mandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
at System.Data.SqlClient.SqlCommand.System.Data.IDbCo mmand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
--- End of inner exception stack trace ---
Thanks,

Dennis Huang
Nov 15 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by BVM | last post: by
4 posts views Thread by Ratan | last post: by
1 post views Thread by ruca | last post: by
3 posts views Thread by Henke | last post: by
1 post views Thread by Hema S via DotNetMonster.com | last post: by
10 posts views Thread by greenb | last post: by
2 posts views Thread by Rajesh.jain25 | last post: by
6 posts views Thread by Russell Stevens | last post: by
reply views Thread by naveed | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.