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: Subquery returned more than 1 value. This is not permitted when the subquery follows =, !=, <, <= , >, >= or when the subquery is used as an expression.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TrySetMetaData(_SqlMetaDataSet metaData, Boolean moreInfo)
at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
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.doLoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
--- End of inner exception stack trace ---
at Dea.Data.Database.doLoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
at Dea.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String[] tableNames)
at Dea.Data.Database.LoadDataSet(DbCommand command, DataSet dataSet, String tableName)
at Dea.Data.Database.ExecuteDataSet(DbCommand command)
at Dea.MasterCalendar.Events.EventsDatabase.GetCalendarData(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 isList, Boolean showPast, Boolean showUserOnly, Boolean rollupEmsReservation, Int32 TZID)
at Dea.Web.Sites.MasterCalendar.MasterCalendar.GetEvents()
at Dea.Web.Sites.MasterCalendar.MasterCalendar.LoadJsonData()
at Dea.Web.Sites.MasterCalendar.MasterCalendar.Page_Load(Object sender, 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: 202208260
ClientName:
Product:
SqlStatement: dbo.MC_Events_GetCalendarData
@StartDate: 3/24/2024 12:00:00 AM
@EndDate: 3/30/2024 11:59:00 PM
@EventId: -1
@GroupingId: 0
@EventTypeID:
@LocationID:
@SubLocationIds:
@DepartmentIds:
@CalendarIDs: 4
@UserID: -1
@SiteAdministrator: False
@SearchOn:
@PageSize: 30
@PageIndex: 0
@IsList: False
@UserTemplateID: -1
@Showpast: True
@ShowUserOnly: False
@RollUpEMSReservations: False
@SelectedTimeZoneID: 0