=============================================================================
Enterprise : LIVES
Message : System.NullReferenceException: Object reference not set to an instance of an object.
   at eTurnsServices.EDIwebService.InsertPull(EDIPullDTO[] Items, String Enterprise) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\EDIwebService.svc.cs:line 4123
Date :4/8/2023 9:31:49 AM
=============================================================================


=============================================================================
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 373) 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.<ExecuteStoreCommand>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, Int64 EnterpriseId) 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, Int64 EnterpriseId, String PullAction, String WhatWhereAction) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurns.DAL\ItemLocationDetailsDAL.cs:line 3088
   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 303
Date :4/8/2023 4:00:58 AM
=============================================================================