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
=============================================================================
Message : The underlying provider failed on Commit.
StackTrace :System.Data.EntityException: The underlying provider failed on Commit. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
Cannot continue the execution because the session is in the kill state.
A transport-level error has occurred when receiving results from the server. (provider: Session Provider, error: 19 - Physical connection is not usable)
Remote harden of transaction 'user_transaction' (ID 0x0000000001593209 0000:27037fdc) started at Dec 29 2019 10:26PM in database '10077_145ACE8A-67FF-4D8C-A277-86D0F984DBD2' at LSN (235168:94628:3) failed. ---> System.ComponentModel.Win32Exception: The wait operation timed out
   --- End of inner exception stack trace ---
   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.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
   at System.Data.SqlClient.TdsParserStateObject.ReadSniSyncOverAsync()
   at System.Data.SqlClient.TdsParserStateObject.TryReadNetworkPacket()
   at System.Data.SqlClient.TdsParserStateObject.TryPrepareBuffer()
   at System.Data.SqlClient.TdsParserStateObject.TryReadByte(Byte& value)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.TdsExecuteTransactionManagerRequest(Byte[] buffer, TransactionManagerRequestType request, String transactionName, TransactionManagerIsolationLevel isoLevel, Int32 timeout, SqlInternalTransaction transaction, TdsParserStateObject stateObj, Boolean isDelegateControlRequest)
   at System.Data.SqlClient.SqlInternalConnectionTds.ExecuteTransactionYukon(TransactionRequest transactionRequest, String transactionName, IsolationLevel iso, SqlInternalTransaction internalTransaction, Boolean isDelegateControlRequest)
   at System.Data.SqlClient.SqlInternalTransaction.Commit()
   at System.Data.SqlClient.SqlTransaction.Commit()
   at System.Data.EntityClient.EntityTransaction.Commit()
   --- End of inner exception stack trace ---
   at System.Data.EntityClient.EntityTransaction.Commit()
   at System.Data.Objects.ObjectContext.SaveChanges(SaveOptions options)
   at eTurns.DAL.PollAllHistoryDAL.Insert(PollAllHistoryDTO objDTO)
   at eTurnsServices.Service1.ItemLocationWisePollAll(List`1 objItemVMIDTOs, Int64 UserID, Int64 RoomID, Int64 CompanyID, String ActionType)
Date :12/29/2019 10:26:47 PM
=============================================================================