Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Insert Requisition called Insert Requisition called Insert Requisition called Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Insert Requisition called ============================================================================= Message : An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using SqlAzureExecutionStrategy. StackTrace :System.Data.Entity.Core.EntityException: An exception has been raised that is likely due to a transient failure. If you are connecting to a SQL Azure database consider using SqlAzureExecutionStrategy. ---> System.Data.SqlClient.SqlException: Transaction (Process ID 138) 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.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, 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.InternalExecuteNonQuery(TaskCompletionSource`1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.NonQuery(DbCommand command, DbCommandInterceptionContext interceptionContext) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreCommandInternal(String commandText, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess) at System.Data.Entity.Core.Objects.ObjectContext.<>c__DisplayClass174_0.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) --- End of inner exception stack trace --- at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at eTurns.DAL.ItemLocationQTYDAL.DeleteItemLocationsByItemAndBinId(Guid ItemGUID, Int64 BinID, Int64 RoomID, Int64 CompanyID) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurns.DAL\ItemLocationQTYDAL.cs:line 531 at eTurns.DAL.ItemLocationQTYDAL.Save(List`1 lstitem, String WhatWhereAction, Int64 SessionUserId) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurns.DAL\ItemLocationQTYDAL.cs:line 470 at eTurns.DAL.ItemLocationDetailsDAL.ItemLocationDetailsSaveForCreditPullnew(List`1 objData, String calledfrom, String RoomDateFormat, List`1& lstCreditGuids, Int64 SessionUserId, String PullAction, String WhatWhereAction) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurns.DAL\ItemLocationDetailsDAL.cs:line 3086 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Service1.svc.cs:line 302 Date :3/16/2022 4:00:40 AM ============================================================================= Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Delete WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert Requisition called Insert Requisition called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called