Faculty Access for the Web is slow and takes a long time to log in or returns the error: Server Error in '/FAWeb7' Application. Timeout expired. The timeout elapsed prior to completion of the operation or the server is not responding.

When trying to run progress reports for advisees, the following error is returned:
 
Server Error in '/FAWeb7' 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) +1950890
 
   System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +4846875
 
   System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +194
 
   System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2392
 
   System.Data.SqlClient.SqlDataReader.ConsumeMetaData() +33
 
   System.Data.SqlClient.SqlDataReader.get_MetaData() +83
 
   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) +954
 
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) +162
 
   System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) +32
 
   System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) +141
 
   System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior) +12
 
   System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior) +10
 
   System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +130
 
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) +287
 
   System.Data.Common.DbDataAdapter.Fill(DataSet dataSet) +94
 
   Blackbaud.Web.FE.NCFAWebLib.DataLibHelper.GetDataSet(SqlConnection oConnection, String sSQL, SqlParameter[] oParamArray, Int32 iTimeout, Boolean bGetSchema) +77
 
   Blackbaud.Web.FE.NCFAWebLib.DataLibHelper.GetDataTable(SqlConnection oConnection, String sSQL, SqlParameter[] oParamArray, Int32 iTimeout, Boolean bGetSchema) +25
 
   Blackbaud.Web.FE.NCFAWebLib.FAWebDataLib.GetAdviseesForReport(Int32 iAdvisorID, Int32 iAcademicYearTEID, String sMCIDs, Boolean bIncludeClassesInResultSet, Boolean bIncludeClassName, Boolean bCheckingForLower, String sCheckingForGradesLowerThan, Int32 iNumDecimals, Int32 iSchoolId, Boolean bSortByClass, Boolean bSingleSchool, Int32 iSessionID, String sSelStudents) +1328
 
   Blackbaud.Web.FE.FAWEB.ProgressReportStudents.SetupSelectedStudents() +797
 
   Blackbaud.Web.FE.FAWEB.ProgressReportStudents.Setupform() +312
 
   Blackbaud.Web.FE.FAWEB.ProgressReportStudents.Page_Load(Object sender, EventArgs e) +108
 
   System.EventHandler.Invoke(Object sender, EventArgs e) +0
 
   System.Web.UI.Control.OnLoad(EventArgs e) +99
 
   System.Web.UI.Control.LoadRecursive() +50
 
   System.Web.UI.Control.AddedControl(Control control, Int32 index) +265
 
   System.Web.UI.ControlCollection.Add(Control child) +80
 
   Blackbaud.Web.FE.FAWEB.FAWebShell.LoadCurrentControl() +348
 
   Blackbaud.Web.FE.FAWEB.FAWebShell.myMenuId_ItemClick(Object sender, MenuItemClickEventArgs e) +123
 
   Blackbaud.Web.FE.FAWEB.FAWebMenu.FAWebMenu_ItemClick(Object sender, MenuItemClickEventArgs e) +50
 
   Blackbaud.Web.Core.Controls.Menu.BBMenu.OnItemClick(MenuItemClickEventArgs e) +36
 
   Blackbaud.Web.Core.Controls.Menu.BBMenu.RaisePostBackEvent(String eventArgument) +38
 
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +13
 
   Blackbaud.Web.Core.Forms.BBWebForm.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +88
 
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +175
 
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1565
 
 
 
Version Information: Microsoft .NET Framework Version:2.0.50727.3634; ASP.NET Version:2.0.50727.3634
Edit the web.config file with the following information. The default path for the file is C:\Program Files (x86)\Blackbaud\FAWeb7
1. <add key="CommandTimeout" value="1000" />
     This should be added after this line in the appSettings portion of the file: 
     <add key="CacheCheckInterval" value="60" />     
     <!-- How often (in seconds) should we check to make sure the cache is up to date -->
 
2. executionTimeout="1000"
     This should be added to the httpRuntime line in the middle of the file below the <!-- This is the max upload limit for the files for downloadable docs.... > line.  The whole line looks like this: 
     <httpRuntime maxRequestLength="12288" executionTimeout="1000" /> 


Download and install the latest patch, which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch. 

Environment

 7.82.104, patch 35
 7.87.164, patch 2

Was this article helpful?