A Page Error occurred\r\nURL: http://WEBSITEr\nSource:.Net SqlClient Data Provider\r\nError Message:Timeout expired.

 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
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. 

Alternative Solution:

In the Show Field, select Today, This week's attendance, This month's attendance, or Specific dates.

OR

Log into FAWEB as Supervisor and clear the server cache. 

Environment

 FAWeb 7.83.0.31
 FAWeb 7.83.0.34

Was this article helpful?