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 Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition 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 WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull 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 Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Insert Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull 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 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 Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Insert Requisition 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 Pull Requisition called Pull 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 Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder 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 WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull 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 Pull Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull 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 Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Insert Requisition called Pull Requisition called Pull 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 WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull 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 Pull Requisition 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 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 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 Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Pull Requisition called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Message : An error occurred while starting a transaction on the provider connection. See the inner exception for details. StackTrace :System.Data.Entity.Core.EntityException: An error occurred while starting a transaction on the provider connection. See the inner exception for details. ---> System.Data.SqlClient.SqlException: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. The request failed to run because the batch is aborted, this can be caused by abort signal sent from client, or another request is running in the same session, which makes the session busy. Operation cancelled by user. ---> 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.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.SqlInternalConnection.BeginSqlTransaction(IsolationLevel iso, String transactionName, Boolean shouldReconnect) at System.Data.SqlClient.SqlConnection.BeginTransaction(IsolationLevel iso, String transactionName) at System.Data.SqlClient.SqlConnection.BeginDbTransaction(IsolationLevel isolationLevel) 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.DbConnectionDispatcher.BeginTransaction(DbConnection connection, BeginTransactionInterceptionContext interceptionContext) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.EntityClient.EntityConnection.BeginDbTransaction(IsolationLevel isolationLevel) --- End of inner exception stack trace --- at System.Data.Entity.Core.EntityClient.EntityConnection.BeginDbTransaction(IsolationLevel isolationLevel) at System.Data.Entity.Core.EntityClient.EntityConnection.BeginTransaction() 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.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction) at System.Data.Entity.Internal.InternalContext.SaveChanges() at eTurns.DAL.eVMIPollHistoryDAL.Insert(eVMIPollHistoryDTO objDTO) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurns.DAL\eVMIPollHistoryDAL.cs:line 37 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 246 Date :8/7/2023 11:47:33 PM =============================================================================