When selecting Attendance in FAWeb and selecting All Dates in the Show Field, the stack trace error occurs. An error is displayed in both a pop up window and in FAWeb. The full errors are:
A Page Error occurred\r\nURL: http://WEBSITE\r\nSource:.Net SqlClient Data Provider\r\nError Message:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.\r\nStack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)\r\n at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)\r\n at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)\r\n at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)\r\n at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()\r\n at System.Data.SqlClient.SqlDataReader.get_MetaData()\r\n at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)\r\n at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)\r\n at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)\r\n at System.Data.SqlClient.SqlCommand.ExecuteReader()\r\n at Blackbaud.Web.FE.SPWrap.EA7FAWebGetAttendanceInfo.WrapperRoutines.ExecuteSP(SqlConnection conn, Int32 ilFacultyID, Int32 ilAttendenceType, Int32 ilClassTermsID, Int32 ilTermsID, Int32 ilSessionsID, Int32 ilAcademicYearID, Int32 ibIncludeAllDates, DateTime dStartDate, DateTime dEndDate, Int32 ibIncludeWithdrawnStudents, String ssStudentNameForma…
---------------------------
OK
---------------------------
A Page Error occurred URL: http://WEBSITE Source:.Net SqlClient Data Provider Error Message:Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding. Stack Trace: at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method) at System.Data.SqlClient.SqlCommand.ExecuteReader() at Blackbaud.Web.FE.SPWrap.EA7FAWebGetAttendanceInfo.WrapperRoutines.ExecuteSP(SqlConnection conn, Int32 ilFacultyID, Int32 ilAttendenceType, Int32 ilClassTermsID, Int32 ilTermsID, Int32 ilSessionsID, Int32 ilAcademicYearID, Int32 ibIncludeAllDates, DateTime dStartDate, DateTime dEndDate, Int32 ibIncludeWithdrawnStudents, String ssStudentNameFormat, Int32 iClassID, Int32& iReturnValue) at Blackbaud.Web.FE.SPWrap.EA7FAWebGetAttendanceInfo.WrapperRoutines.ExecuteSP(String sConnString, Int32 ilFacultyID, Int32 ilAttendenceType, Int32 ilClassTermsID, Int32 ilTermsID, Int32 ilSessionsID, Int32 ilAcademicYearID, Int32 ibIncludeAllDates, DateTime dStartDate, DateTime dEndDate, Int32 ibIncludeWithdrawnStudents, String ssStudentNameFormat, Int32 iClassID, Int32& iReturnValue) at Blackbaud.Web.FE.FAWEB.Attendance.CreateDataSource(Boolean bUseViewState, ResultRow[]& oStudentAttendance, ResultRow1[]& oAttendanceColumns) at Blackbaud.Web.FE.FAWEB.Attendance.SetUpGridEx(Boolean bRefreshAfterSave) at Blackbaud.Web.FE.FAWEB.Attendance.LoadRemainingPage(Boolean bSkipClasses) at Blackbaud.Web.FE.FAWEB.Attendance.mcDateSelector_DateRangeChanged(Object sender, EventArgs e