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: Procedure or function MC_Events_GetCalendarData has too many arguments specified.
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.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.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.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 MasterCalendar.GetEvents()
at MasterCalendar.LoadJsonData()
at 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: 201704210
ClientName:
Product:
SqlStatement: dbo.MC_Events_GetCalendarData
@StartDate: 11/1/2019 12:00:00 AM
@EndDate: 11/30/2019 11:59:00 PM
@EventId: -1
@GroupingId: 0
@EventTypeID: 1
@LocationID:
@SubLocationIds:
@DepartmentIds:
@CalendarIDs: 15
@UserID: -1
@SiteAdministrator: False
@SearchOn:
@PageSize: 30
@PageIndex: 0
@IsList: True
@UserTemplateID: -1
@Showpast: True
@ShowUserOnly: False
@RollUpEMSReservations: True
@SelectedTimeZoneID: 0