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/21/2024 7: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.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/21/2024 7:01:29 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/21/2024 6:00:58 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/21/2024 6:01:50 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/21/2024 5:00:56 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.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/21/2024 5:00:56 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/21/2024 5:00:56 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/21/2024 5:01:25 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/21/2024 4:00:41 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/21/2024 4:00:54 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/21/2024 3:00:52 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/21/2024 3:01:50 AM
System.Threading.Tasks.TaskCanceledException
The request was canceled due to the configured HttpClient.Timeout of 100 seconds elapsing.
System.Threading.Tasks.TaskCanceledException: The request was canceled due to the configured HttpClient.Timeout of 100 seconds elapsing.
---> System.TimeoutException: The operation was canceled.
---> System.Threading.Tasks.TaskCanceledException: The operation was canceled.
---> System.IO.IOException: Unable to read data from the transport connection: The I/O operation has been aborted because of either a thread exit or an application request..
---> System.Net.Sockets.SocketException (995): The I/O operation has been aborted because of either a thread exit or an application request.
--- End of inner exception stack trace ---
at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.ThrowException(SocketErrorerror, CancellationTokencancellationToken)
at System.Net.Sockets.Socket.AwaitableSocketAsyncEventArgs.GetResult(Int16token)
at System.Net.Security.SslStream.ReadAsyncInternal[TIOAdapter](TIOAdapteradapter, Memory`1buffer)
at System.Net.Http.HttpConnection.SendAsyncCore(HttpRequestMessagerequest, Booleanasync, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
at System.Net.Http.HttpConnection.SendAsyncCore(HttpRequestMessagerequest, Booleanasync, CancellationTokencancellationToken)
at System.Net.Http.HttpConnectionPool.SendWithRetryAsync(HttpRequestMessagerequest, Booleanasync, BooleandoRequestAuth, CancellationTokencancellationToken)
at System.Net.Http.RedirectHandler.SendAsync(HttpRequestMessagerequest, Booleanasync, CancellationTokencancellationToken)
at Microsoft.Extensions.Http.Logging.LoggingHttpMessageHandler.SendAsync(HttpRequestMessagerequest, CancellationTokencancellationToken)
at Microsoft.Extensions.Http.Logging.LoggingScopeHttpMessageHandler.SendAsync(HttpRequestMessagerequest, CancellationTokencancellationToken)
at System.Net.Http.HttpClient.SendAsyncCore(HttpRequestMessagerequest, HttpCompletionOptioncompletionOption, Booleanasync, BooleanemitTelemetryStartStop, CancellationTokencancellationToken)
--- End of inner exception stack trace ---
--- End of inner exception stack trace ---
at System.Net.Http.HttpClient.SendAsyncCore(HttpRequestMessagerequest, HttpCompletionOptioncompletionOption, Booleanasync, BooleanemitTelemetryStartStop, CancellationTokencancellationToken)
at ClarityConnect.Connectors.CEF.CefIntegrationService.Digest[TModel,TRequest](TRequestrequest, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Connectors.CEF\IntegrationService\CefIntegrationService.cs:line 36
at ClarityConnect.Connectors.CEF.CefService.Digest(Schemasschema, Tablestable, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Connectors.CEF\Service\Implementations\CefService.cs:line 30
at ClarityConnect.Connectors.CEF.CefService.Digest(EntitySchemaschema, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Connectors.CEF\Service\Implementations\CefService.cs:line 23
at ClarityConnect.Connectors.CEF.CefService.DigestAccount(CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Connectors.CEF\Service\Implementations\CefService.Account.cs:line 20
at ClarityConnect.Clients.GLV.GLV.CustomerSync(PerformContextcontext, CancellationTokentoken) in C:\data\projects\GLV\STG\Connect-v3\ClarityConnect.Clients.GLV\Jobs\CustomerSync.cs:line 53
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Tasktask)
An exception occurred during performance of the job. More details...
6/21/2024 2:00:50 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/21/2024 2:01:20 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/21/2024 1: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/21/2024 1: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/21/2024 12: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.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/21/2024 12:01:16 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/20/2024 11:01:30 PM
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/20/2024 11:01:01 PM
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)