---------------------------------------- Timestamp: 4/5/2018 5:27:43 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Cannot find table 0. StackTrace - at System.Data.DataTableCollection.get_Item(Int32 index) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderProperty(String ClientID, String workOrderIdentity, String PropertyAliasName) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) ---------------------------------------- ---------------------------------------- Timestamp: 4/5/2018 10:57:43 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) at BOS_DAMSServiceLayer.BOS_DAMSServiceLayer.PermanentDeleteAsset(EditParameters inputParameters) InnerException - LogUtility.CustomApplicationException: SQLException ---> System.Data.SqlClient.SqlException: Transaction (Process ID 61) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 123 123 at System.Data.SqlClient.SqlConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) --- End of inner exception stack trace --- at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) ---------------------------------------- ---------------------------------------- Timestamp: 4/5/2018 10:58:14 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) at BOS_DAMSServiceLayer.BOS_DAMSServiceLayer.PermanentDeleteAsset(EditParameters inputParameters) InnerException - LogUtility.CustomApplicationException: SQLException ---> System.Data.SqlClient.SqlException: Transaction (Process ID 62) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 123 123 at System.Data.SqlClient.SqlConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) --- End of inner exception stack trace --- at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) ---------------------------------------- ---------------------------------------- Timestamp: 4/5/2018 10:58:19 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) at BOS_DAMSServiceLayer.BOS_DAMSServiceLayer.PermanentDeleteAsset(EditParameters inputParameters) InnerException - LogUtility.CustomApplicationException: SQLException ---> System.Data.SqlClient.SqlException: Transaction (Process ID 63) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 123 123 at System.Data.SqlClient.SqlConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) --- End of inner exception stack trace --- at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) ---------------------------------------- ---------------------------------------- Timestamp: 4/5/2018 10:58:22 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) at BOS_DAMSServiceLayer.BOS_DAMSServiceLayer.PermanentDeleteAsset(EditParameters inputParameters) InnerException - LogUtility.CustomApplicationException: SQLException ---> System.Data.SqlClient.SqlException: Transaction (Process ID 60) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 123 123 at System.Data.SqlClient.SqlConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) --- End of inner exception stack trace --- at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) ---------------------------------------- ---------------------------------------- Timestamp: 4/5/2018 10:58:23 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) at BOS_DAMSServiceLayer.BOS_DAMSServiceLayer.PermanentDeleteAsset(EditParameters inputParameters) InnerException - LogUtility.CustomApplicationException: SQLException ---> System.Data.SqlClient.SqlException: Transaction (Process ID 64) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 123 123 at System.Data.SqlClient.SqlConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) --- End of inner exception stack trace --- at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) ---------------------------------------- ---------------------------------------- Timestamp: 4/5/2018 10:58:24 AM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - GenericException StackTrace - at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) at BOS_DAMSServiceLayer.BOS_DAMSServiceLayer.PermanentDeleteAsset(EditParameters inputParameters) InnerException - LogUtility.CustomApplicationException: SQLException ---> System.Data.SqlClient.SqlException: Transaction (Process ID 65) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction. 123 123 at System.Data.SqlClient.SqlConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) --- End of inner exception stack trace --- at BOS_DAMSDataAccessLayer.DAMSDataAccessLayer.UpdateAsset(EditParameters inputParameters, String xml, String Operation) ---------------------------------------- ---------------------------------------- Timestamp: 4/5/2018 3:54:59 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Cannot find table 0. StackTrace - at System.Data.DataTableCollection.get_Item(Int32 index) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderProperty(String ClientID, String workOrderIdentity, String PropertyAliasName) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) ---------------------------------------- ---------------------------------------- Timestamp: 4/5/2018 11:43:55 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Transaction (Process ID 61) was deadlocked on lock | communication buffer resources with another process and has been chosen as the deadlock victim. Rerun the transaction. StackTrace - at System.Data.SqlClient.SqlConnection.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.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean asyncWrite) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at BOS_CommonUtility.CommonUtility.IsTokenValid(String tokenID) ---------------------------------------- ---------------------------------------- Timestamp: 4/5/2018 11:51:37 PM Message: Priority: -1 EventId: 0 Severity: Error Extended Properties: ErrorCode - Cannot find table 0. StackTrace - at System.Data.DataTableCollection.get_Item(Int32 index) at Grid_API.DataAccessLayer.Grid_APIDataAccessLayer.FetchWorkOrderProperty(String ClientID, String workOrderIdentity, String PropertyAliasName) at Grid_API.ServiceLayer.GridAPIService.FetchWorkOrderProperty(String ClientID, String tokenID, String workOrderIdentity, String PropertyAliasName) ----------------------------------------