Error Message: An error occured attempting to execute the command against the database.
Stack Trace:
Dea.Data.DatabaseException: An error occured attempting to execute the command against the database. ---> System.Data.SqlClient.SqlException: A transport-level error has occurred when sending the request to the server. (provider: TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.)
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParserStateObject.WriteSni()
at System.Data.SqlClient.TdsParserStateObject.ExecuteFlush()
at System.Data.SqlClient.TdsParser.TdsExecuteRPC(_SqlRPC[] rpcArray, Int32 timeout, Boolean inSchema, SqlNotificationRequest notificationRequest, TdsParserStateObject stateObj, Boolean isCommandProc)
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.ExecuteDbDataReader(CommandBehavior behavior)
at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet)
at Dea.Data.Database.a(DbCommand A_0, DataSet A_1, String[] A_2)
--- End of inner exception stack trace ---
at Dea.Data.Database.a(DbCommand A_0, DataSet A_1, String[] A_2)
at Dea.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
at Dea.Data.Database.ExecuteDataSet(DbCommand command)
at Dea.MasterCalendar.Events.EventsDatabase.GetCalendarEventsData(DateTime startDate, DateTime endDate, Int32 eventId, String commaDelimitedCalendarIds, String SearchOn, Int32 datesOnly, Int32 groupingId, String eventTypeId, String locationIds, String subLocationIds, String departmentIds, Int32 pageSize, Int32 pageIndex, Int32 webUserId, Int32 userTemplateId, Boolean siteAdministrator, Boolean isDetailList, Boolean showPast, Boolean showUserOnly, Boolean rollupEmsReservation)
at MasterCalendar.Page_Load(Object sender, EventArgs e)
at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
at System.Web.UI.Control.OnLoad(EventArgs e)
at Dea.Web.Sites.MasterCalendar.BasePage.OnLoad(EventArgs e)
at System.Web.UI.Control.LoadRecursive()
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Additional Information
ErrorCaughtBy: MasterCalendar.aspx
PatchNumber: 7
ClientName:
Product:
SqlStatement: dbo.MC_BrowseEvents_LoadData
@StartDate: 4/24/2014 12:00:00 AM
@EndDate: 4/24/2014 11:59:00 PM
@EventId: -1
@GroupingId: 0
@EventTypeIds:
@LocationIds:
@SubLocationIds:
@DepartmentIds:
@intDatesOnly: 0
@CalendarIDs: 00000000
@UserID: -1
@SiteAdministrator: False
@SearchOn:
@PageSize: 30
@PageIndex: 0
@IsDetailedList: True
@UserTemplateID: -1
@Showpast: False
@ShowUserOnly: False
@RollUpEMSReservations: True
@Culture: en-US