============================================================================= Message : An error occurred while updating the entries. See the inner exception for details. StackTrace :System.Data.UpdateException: An error occurred while updating the entries. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Transaction (Process ID 92) 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.SqlDataReader.TryConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() 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.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.Mapping.Update.Internal.DynamicUpdateCommand.Execute(UpdateTranslator translator, EntityConnection connection, Dictionary`2 identifierValues, List`1 generatedValues) at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) --- End of inner exception stack trace --- at System.Data.Mapping.Update.Internal.UpdateTranslator.Update(IEntityStateManager stateManager, IEntityAdapter adapter) at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options) at eTurns.DAL.PullDetailsDAL.Insert(PullDetailsDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullDetailsDAL.cs:line 280 at eTurns.DAL.PullMasterDAL.AddtoPullDetail(ItemLocationDetailsDTO itemlocationdetail, Nullable`1 PullGUID, Nullable`1 ProjectSpendGUID, Nullable`1 ItemCost, Nullable`1 UserID, Double loopCurrentTakenCustomer, Double loopCurrentTakenConsinment) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 2878 at eTurns.DAL.PullMasterDAL.UpdatePullDataForService(PullMasterViewDTO objDTO, Int32 IsCreditPullNothing, Int64 RoomID, Int64 CompanyID, String& ItemLocationMSG, Boolean IsProjectSpendAllowed, Boolean& IsPSLimitExceed) in D:\Projects\eTurns\Trunk\eTurns5050\eTurns.DAL\PullMasterDAL.cs:line 4309 at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType) in D:\Projects\eTurns\Trunk\eTurns5050\eTurnsServices\Service1.svc.cs:line 289 Date :8/31/2015 11:00:08 AM =============================================================================