Time out problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Time out problem

Author

Topic

Amin.taheri
Starting Member

2 Posts

Posted - 2008-08-18 : 18:13:28

Hi all,
I'm trying to get a knowledgebase application working on my company's website but I'm getting a "Exception Type: System.Data.SqlClient.SqlException" Error.

This happens when I try to upload a large file (60MB) to the knowledgebase. I believe this is a time out error but I'm not sure how to solve it!

Here's my connection string:
<add key="InstantASP_ConnectionString" value="server=67.210.98.106;UID=plane53;PWD=******;database=InstantKB20;Connect Timeout=600; pooling='true'; Max Pool Size=300" />
I added "connect timeout, pooling and Max pool" to solve this problem but it didn't help at all.
I only have an end-user liscence for the knowledgebase software so I have no idea how it works.

I would really appreciate any pointers on this
thanks again
Amin Taheri
Here's the error message:
----------------------------------------------------------------------

The application encountered an unexpected problem.
----------------------------------------------------------------------

Unexpected Problem Occurred!
This error has been logged. If this problem persists please contact the web master.
More Information...
Detailed error information follows:

URL: http://planettogether.net/Support/Staff/StaffEditArticle50049.aspx?Update=1

NET Runtime version: 2.0.50727.1433
Application Domain: /LM/W3SVC/23054/Root/Support-2-

Exception Type: System.Data.SqlClient.SqlException

Exception Message: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Exception Source: .Net SqlClient Data Provider
Exception Target Site: OnError

---- Stack Trace ----
System.Data.SqlClient.SqlInternalConnection.OnError(exception As SqlException, breakConnection As Boolean)
(unknown file): N 800131
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(stateObj As TdsParserStateObject)
(unknown file): N 00186
System.Data.SqlClient.TdsParserStateObject.ReadSniError(stateObj As TdsParserStateObject, error As UInt32)
(unknown file): N 00556
System.Data.SqlClient.TdsParserStateObject.ReadSni(asyncResult As DbAsyncResult, stateObj As TdsParserStateObject)
(unknown file): N 00164
System.Data.SqlClient.TdsParserStateObject.ReadPacket(bytesExpected As Int32)
(unknown file): N 00034
System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
(unknown file): N 00044
System.Data.SqlClient.TdsParserStateObject.ReadByteArray(buff As Byte[], offset As Int32, len As Int32)
(unknown file): N 00259
System.Data.SqlClient.TdsParser.ReadSqlValue(value As SqlBuffer, md As SqlMetaDataPriv, length As Int32, stateObj As TdsParserStateObject)
(unknown file): N 725775
System.Data.SqlClient.SqlDataReader.ReadColumnData()
(unknown file): N 00088
System.Data.SqlClient.SqlDataReader.ReadColumnHeader(i As Int32)
(unknown file): N 00309
System.Data.SqlClient.SqlDataReader.ReadColumn(i As Int32, setTimeout As Boolean)
(unknown file): N 00134
System.Data.SqlClient.SqlDataReader.GetValueInternal(i As Int32)
(unknown file): N 00017
System.Data.SqlClient.SqlDataReader.GetValue(i As Int32)
(unknown file): N 00101
System.Data.SqlClient.SqlDataReader.get_Item(name As String)
(unknown file): N 00024
InstantASP.InstantKB.Components.Attachment.InitializeBasic(dr As IDataReader)
(unknown file): N 00649
InstantASP.InstantKB.Business.Attachments.GetAttachments(intEntityID As Int32, EnumAttachmentType As EnumAttachmentType, ForceDatabaseLookUp As Boolean)
(unknown file): N 00432
InstantASP.InstantKB.Business.Attachments.SelectAttachments(intEntityID As Int32, EnumAttachmentType As EnumAttachmentType, ForceDatabaseLookUp As Boolean)
(unknown file): N 00040
InstantASP.InstantKB.UI.Controls.ViewAttachments.BindData(ForceDataBaseLookUp As Boolean)
(unknown file): N 00076
InstantASP.InstantKB.UI.Controls.ViewAttachments.OnLoad(e As EventArgs)
(unknown file): N 00100
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00047
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Control.LoadRecursive()
(unknown file): N 00131
System.Web.UI.Page.ProcessRequestMain(includeStagesBeforeAsyncPoint As Boolean, includeStagesAfterAsyncPoint As Boolean)
(unknown file): N 01436

Amin Taheri
Application Consultant
PlanetTogether, LLC.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-18 : 18:34:39

You need to set the command timeout as the connect timeout is just for connections.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Amin.taheri
Starting Member

2 Posts

Posted - 2008-08-20 : 12:31:25

Thank you for your response Tara. I have been trying to fix this for a month now, and neither my hosting service nor the application vendor are helping me.
I have been reading on setting command timeout and it seems like this is something that needs to be defined in the application! Can I define the command timeout globally in my web.config or some other config file?
I don't have a developer liscence for the application so I think it would be hard to set it in there.
Thanks again for your help and sorry if I'm way off on these topics

Amin Taheri
Application Consultant
PlanetTogether, LLC.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-08-20 : 12:40:50

You can't globally set command timeout in web.config. You'll need to crack open the application code.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources