Insert WorkOrder called BulkInsert WorkOrder called Insert Requisition called Pull Requisition called Insert WorkOrder called BulkInsert WorkOrder called Pull Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Provide Fault: The underlying provider failed on Open. StackTrace :System.Data.Entity.Core.EntityException: The underlying provider failed on Open. ---> System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: TCP Provider, error: 0 - The wait operation timed out.) ---> System.ComponentModel.Win32Exception: The wait operation timed out --- End of inner exception stack trace --- at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderManager) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext](TTarget target, Action`2 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed) at System.Data.Entity.Infrastructure.Interception.DbConnectionDispatcher.Open(DbConnection connection, DbInterceptionContext interceptionContext) at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.<>c__DisplayClass2_0.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.EntityClient.EntityConnection.Open() --- End of inner exception stack trace --- at System.Data.Entity.Core.EntityClient.EntityConnection.Open() at System.Data.Entity.Core.Objects.ObjectContext.EnsureConnection(Boolean shouldMonitorTransactions) 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__DisplayClass186_0`1.b__0() at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQueryReliably[TElement](String commandText, String entitySetName, ExecutionOptions executionOptions, Object[] parameters) at System.Data.Entity.Core.Objects.ObjectContext.ExecuteStoreQuery[TElement](String commandText, ExecutionOptions executionOptions, Object[] parameters) at System.Data.Entity.Internal.LazyEnumerator`1.MoveNext() at System.Linq.Enumerable.FirstOrDefault[TSource](IEnumerable`1 source) at eTurnsMaster.DAL.EnterPriseUserMasterDAL.GetUserByIdForServiceNormal(Int64 Id) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsMaster.DAL\EnterPriseUserMasterDAL.cs:line 38 at eTurnsServices.Service1.GetAllItemWithLocation(Int64 RoomID, Int64 CompanyID, Int64 UserID) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Service1.svc.cs:line 107 at SyncInvokeGetAllItemWithLocation(Object , Object[] , Object[] ) at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs) at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc) at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage11(MessageRpc& rpc) at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet) Date :8/25/2026 9:03:20 AM ============================================================================= 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 ============================================================================= Enterprise : Border States Message : System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 12:29:39 PM ============================================================================= 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 ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 12:56:18 PM ============================================================================= Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 1:16:38 PM ============================================================================= 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 : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 2:21:26 PM ============================================================================= Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 2:24:30 PM ============================================================================= 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 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 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 Requisition called Insert Requisition called Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 3:54:32 PM ============================================================================= 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 ============================================================================= Enterprise : Comal Supply Message : System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 4:28:55 PM ============================================================================= Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Enterprise : Comal Supply Message : System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 4:42:55 PM ============================================================================= ============================================================================= Enterprise : Comal Supply Message : System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 4:44:00 PM ============================================================================= Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Enterprise : Comal Supply Message : System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 5:10:10 PM ============================================================================= ============================================================================= Enterprise : Martin Supply Message : System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 5:12:19 PM ============================================================================= 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 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 ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 7:10:05 PM ============================================================================= ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 7:10:05 PM ============================================================================= 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 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 : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 8:18:44 PM ============================================================================= 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 ============================================================================= Enterprise : Test HD Enterprise Message : System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 8:37:37 PM ============================================================================= Insert WorkOrder called BulkInsert WorkOrder called Insert WorkOrder called BulkInsert WorkOrder called ============================================================================= Message : Object reference not set to an instance of an object. StackTrace :System.NullReferenceException: Object reference not set to an instance of an object. at eTurnsServices.AlertHelper.SendDataRejectionMail(String ServiceName, DateTime RejectionDateTime, String EnterpriseName, String RejectionData, Exception& _Ex, String EnterpriseDBName, Boolean sendextramail) in D:\Projects\eTurns\Trunk\eTurns.TrackStock\eTurnsServices\Helper\AlertHelper.cs:line 1185 Date :8/25/2026 9:01:27 PM ============================================================================= 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 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