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: Transaction (Process ID 55) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
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: search.js
PatchNumber: 201805210
ClientName:
Product:
SqlStatement: dbo.MC_Events_GetCalendarData
@StartDate: 3/31/2024 12:00:00 AM
@EndDate: 5/4/2024 11:59:00 PM
@EventId: -1
@GroupingId: 0
@EventTypeID:
@LocationID:
@SubLocationIds:
@DepartmentIds:
@CalendarIDs: 1
@UserID: -1
@SiteAdministrator: False
@SearchOn:
@PageSize: 5
@PageIndex: 0
@IsList: False
@UserTemplateID: -1
@Showpast: True
@ShowUserOnly: False
@RollUpEMSReservations: True
@SelectedTimeZoneID: 0
Error Logging Exeception:
Logging Error Message: Access to the path 'C:\inetpub\ems\MasterCalendar\LogFiles\ErrorLog_04292024.txt' is denied.
Logging Stack Trace:
System.UnauthorizedAccessException: Access to the path 'C:\inetpub\ems\MasterCalendar\LogFiles\ErrorLog_04292024.txt' is denied.
at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost)
at System.IO.StreamWriter.CreateFile(String path, Boolean append, Boolean checkHost)
at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize, Boolean checkHost)
at System.IO.StreamWriter..ctor(String path, Boolean append)
at System.IO.File.CreateText(String path)
at e.a(String A_0, Boolean A_1)
at Dea.ExceptionHandling.Loggers.DefaultLogger.Log(Exception exception, NameValueCollection additionalInfo, NameValueCollection configSettings)
at Dea.ExceptionHandling.ExceptionHandler.a(Exception A_0, NameValueCollection A_1)
at Dea.ExceptionHandling.ExceptionHandler.Log(Exception exception, NameValueCollection additionalInfo)
at Dea.ExceptionHandling.ExceptionPrep.LogError(Exception caughtError, String caughtBy, String simpleErrorMessage, NameValueCollection additionalInfo)