Failed jobs do not become expired to allow you to re-queue them without any
time pressure. You should re-queue or delete them manually, or apply AutomaticRetry(OnAttemptsExceeded = AttemptsExceededAction.Delete)
attribute to delete them automatically.
An exception occurred during performance of the job. Fewer details...
6/27/2024 9:00:47 AM
System.InvalidOperationException
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at Microsoft.Data.Common.ADP.ExceptionWithStackTrace(Exceptione)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.InventorySync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\InventorySync.cs:line 62
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 9:01:00 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext_, Booleanresult)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1source)
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 8:00:45 AM
System.InvalidOperationException
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at Microsoft.Data.Common.ADP.ExceptionWithStackTrace(Exceptione)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.InventorySync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\InventorySync.cs:line 62
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 8:00:59 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext_, Booleanresult)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1source)
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 7:00:44 AM
System.InvalidOperationException
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at Microsoft.Data.Common.ADP.ExceptionWithStackTrace(Exceptione)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.InventorySync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\InventorySync.cs:line 62
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 7:00:57 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext_, Booleanresult)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1source)
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 6:00:42 AM
System.InvalidOperationException
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at Microsoft.Data.Common.ADP.ExceptionWithStackTrace(Exceptione)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.InventorySync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\InventorySync.cs:line 62
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 6:00:55 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext_, Booleanresult)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1source)
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 5:00:53 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.ProductSync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\ProductSync.cs:line 65
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 5:00:53 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.PricingSync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\PricingSync.cs:line 44
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 5:00:53 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.InventorySync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\InventorySync.cs:line 62
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 5:01:22 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext_, Booleanresult)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1source)
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 4:00:51 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.InventorySync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\InventorySync.cs:line 62
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 4:01:21 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext_, Booleanresult)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1source)
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 3:00:36 AM
System.InvalidOperationException
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at Microsoft.Data.Common.ADP.ExceptionWithStackTrace(Exceptione)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.InventorySync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\InventorySync.cs:line 62
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 3:00:49 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext_, Booleanresult)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1source)
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 2:00:34 AM
System.InvalidOperationException
Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at Microsoft.Data.Common.ADP.ExceptionWithStackTrace(Exceptione)
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.InventorySync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\InventorySync.cs:line 62
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 2:00:47 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext_, Booleanresult)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1source)
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 1:00:46 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnectionowningConnection, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnectionouterConnection, DbConnectionFactoryconnectionFactory, TaskCompletionSource`1retry, DbConnectionOptionsuserOptions)
at Microsoft.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1retry, SqlConnectionOverridesoverrides)
at Microsoft.Data.SqlClient.SqlConnection.Open(SqlConnectionOverridesoverrides)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternal(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.Open(BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReader(RelationalCommandParameterObjectparameterObject)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.InitializeReader(DbContext_, Booleanresult)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.Execute[TState,TResult](TStatestate, Func`3operation, Func`3verifySucceeded)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.Enumerator.MoveNext()
at System.Collections.Generic.List`1..ctor(IEnumerable`1collection)
at System.Linq.Enumerable.ToList[TSource](IEnumerable`1source)
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/27/2024 1:00:46 AM
Microsoft.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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Microsoft.Data.SqlClient.SqlException (0x80131904): 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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
---> System.ComponentModel.Win32Exception (53): The network path was not found.
at Microsoft.Data.SqlClient.SqlInternalConnection.OnError(SqlExceptionexception, BooleanbreakConnection, Action`1wrapCloseInAction)
at Microsoft.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObjectstateObj, BooleancallerHasConnectionLock, BooleanasyncClose)
at Microsoft.Data.SqlClient.TdsParser.Connect(ServerInfoserverInfo, SqlInternalConnectionTdsconnHandler, BooleanignoreSniOpenTimeout, Int64timerExpire, Booleanencrypt, BooleantrustServerCert, BooleanintegratedSecurity, BooleanwithFailover, SqlAuthenticationMethodauthType)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanignoreSniOpenTimeout, TimeoutTimertimeout, BooleanwithFailover)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfoserverInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringconnectionOptions, SqlCredentialcredential, TimeoutTimertimeout)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimertimeout, SqlConnectionStringconnectionOptions, SqlCredentialcredential, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance)
at Microsoft.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentityidentity, SqlConnectionStringconnectionOptions, SqlCredentialcredential, ObjectproviderInfo, StringnewPassword, SecureStringnewSecurePassword, BooleanredirectedUserInstance, SqlConnectionStringuserConnectionOptions, SessionDatareconnectSessionData, BooleanapplyTransientFaultHandling, StringaccessToken, DbConnectionPoolpool)
at Microsoft.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, ObjectpoolGroupProviderInfo, DbConnectionPoolpool, DbConnectionowningConnection, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPoolpool, DbConnectionowningObject, DbConnectionOptionsoptions, DbConnectionPoolKeypoolKey, DbConnectionOptionsuserOptions)
at Microsoft.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnectionowningObject, DbConnectionOptionsuserOptions, DbConnectionInternaloldConnection)
at Microsoft.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnectionowningObject, UInt32waitForMultipleObjectsTimeout, BooleanallowCreate, BooleanonlyOneCheckConnection, DbConnectionOptionsuserOptions, DbConnectionInternal&connection)
at Microsoft.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location ---
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenInternalAsync(BooleanerrorsExpected, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Storage.RelationalConnection.OpenAsync(CancellationTokencancellationToken, BooleanerrorsExpected)
at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteReaderAsync(RelationalCommandParameterObjectparameterObject, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.InitializeReaderAsync(DbContext_, Booleanresult, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.SqlServer.Storage.Internal.SqlServerExecutionStrategy.ExecuteAsync[TState,TResult](TStatestate, Func`4operation, Func`4verifySucceeded, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.Query.Internal.SingleQueryingEnumerable`1.AsyncEnumerator.MoveNextAsync()
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at Microsoft.EntityFrameworkCore.EntityFrameworkQueryableExtensions.ToListAsync[TSource](IQueryable`1source, CancellationTokencancellationToken)
at ClarityConnect.Clients.GLV.GLV.InventorySync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\InventorySync.cs:line 62
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)