none
erver Error in '/USER' Application. Timeout expired. The timeout period elapsed prior to completion of the operation or th RRS feed

  • Question

  •  

    Hi,

     

    We have an user application ( I have changed the name of the application to USER here) developed in ASP.NET for our reporting services. We have this as part of SQL Server 2005 reporting which provides users some capability of setting filters to the data what they want to see.

     

    there is also standard SQL Server reporting part on this server and the architechture is

     

    reporting server + IIS on one server and source databases are on a different server. The problem is frequently users see the below error while trying to use the asp.net application

     

     

    Server Error in '/Expedient' Application.

    ________________________________

     

     

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

    Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

    Exception Details: System.Data.SqlClient.SqlException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    Source Error:

     

    An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

    Stack Trace:

     

    [SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.]

    System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) +862234

    System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +739110

    System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188

    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1956

    System.Data.SqlClient.SqlDataReader.SetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo) +812203

    System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1647

    System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +31

    System.Data.SqlClient.SqlDataReader.get_MetaData() +62

    System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) +297

    System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) +903

    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +132

    System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32

    System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +122

    System.Data.SqlClient.SqlCommand.ExecuteReader() +84

    Common.GetData(String spName, Hashtable Settings, DataTable Parameters) +179

    Common.FillListBox(Hashtable Settings, String AppKey, Control BoxtoFill) +661

    Filters.Page_Load(Object sender, EventArgs e) +818

    System.Web.UI.Control.OnLoad(EventArgs e) +99

    System.Web.UI.Control.LoadRecursive() +47

    System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1061

    ________________________________

    Version Information: Microsoft .NET Framework Version:2.0.50727.832; ASP.NET Version:2.0.50727.832

     

     

     

     

     

    The other SQL Server reports do timeout some times but they does not throw the above error. its only seen with the ASP.NET application webpage.

     

    Any help in finding out the reason would be greatly appreciated. Below are some more details about the environment

     

    sql server: Version is 2005 with SP2. time out value is 0. Memory is 14gb and sql server is restricted to use 10gb.

     


    Thanks,

    Phani

     

     

     

     

     

     

     

     

     

     

     

     

    Tuesday, September 18, 2007 8:52 PM