// Id: #9371927
using Inpart.Integracao.GerenciadorJobs.Services;
var jobVerificaIPExternoExterno = Activate<JobVerificaIPExternoExterno>();
await jobVerificaIPExternoExterno.Execute();
| CurrentCulture | |
| RecurringJobId | |
| RetryCount | |
| Time | |
Exceeded the maximum number of retry attempts.
System.Exception: Erro ao abrir conexão com banco de dados. ---> System.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: TCP Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.Open() at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 30 ClientConnectionId:00000000-0000-0000-0000-000000000000 --- End of inner exception stack trace --- at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 36 at Inpart.Communication.Domain.Email.InsertQueueEmail(DtoCommunication msg) in /src/Inpart.Communication/Domain/Email.cs:line 20 at Inpart.Communication.Domain.Communication.SendEmaiGridl(DtoCommunication msg) in /src/Inpart.Communication/Domain/Communication.cs:line 56 at Inpart.Communication.Controllers.CommunicationController.CommunicationEmailGrid(DtoCommunication communication) in /src/Inpart.Communication/Controllers/CommunicationController.cs:line 28 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider) at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context) HEADERS ======= Accept: application/json, text/json, text/x-json, text/javascript, application/xml, text/xml Host: inpart-hml-communication.azurewebsites.net User-Agent: RestSharp/110.2.0.0 Accept-Encoding: gzip, deflate, br Content-Type: application/json; charset=utf-8 Max-Forwards: 10 Request-Id: |dc4b4781b61b85309b22259e9dda4a3f.ba7f6efb5165f7df. traceparent: 00-dc4b4781b61b85309b22259e9dda4a3f-ba7f6efb5165f7df-00 Content-Length: 188 X-ARR-LOG-ID: 2fa9bfa7-43c6-4760-965d-c0ad459e3bfa CLIENT-IP: 191.234.200.86:15078 DISGUISED-HOST: inpart-hml-communication.azurewebsites.net X-SITE-DEPLOYMENT-ID: inpart-hml-communication WAS-DEFAULT-HOSTNAME: inpart-hml-communication.azurewebsites.net X-Forwarded-Proto: https X-AppService-Proto: https X-ARR-SSL: 2048|256|CN=Microsoft TLS G2 RSA CA OCSP 10, O=Microsoft Corporation, C=US|CN=*.azurewebsites.net, O=Microsoft Corporation, L=Redmond, S=WA, C=US X-Forwarded-TlsVersion: 1.3 X-Forwarded-For: 191.234.200.86:15078 X-Original-URL: /Communication/SendEmailGrid X-WAWS-Unencoded-URL: /Communication/SendEmailGrid X-Client-IP: 191.234.200.86 X-Client-Port: 15078
An exception occurred during performance of the job.
System.Exception: Erro ao abrir conexão com banco de dados. ---> System.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: TCP Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.Open() at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 30 ClientConnectionId:00000000-0000-0000-0000-000000000000 --- End of inner exception stack trace --- at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 36 at Inpart.Communication.Domain.Email.InsertQueueEmail(DtoCommunication msg) in /src/Inpart.Communication/Domain/Email.cs:line 20 at Inpart.Communication.Domain.Communication.SendEmaiGridl(DtoCommunication msg) in /src/Inpart.Communication/Domain/Communication.cs:line 56 at Inpart.Communication.Controllers.CommunicationController.CommunicationEmailGrid(DtoCommunication communication) in /src/Inpart.Communication/Controllers/CommunicationController.cs:line 28 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider) at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context) HEADERS ======= Accept: application/json, text/json, text/x-json, text/javascript, application/xml, text/xml Host: inpart-hml-communication.azurewebsites.net User-Agent: RestSharp/110.2.0.0 Accept-Encoding: gzip, deflate, br Content-Type: application/json; charset=utf-8 Max-Forwards: 10 Request-Id: |dc4b4781b61b85309b22259e9dda4a3f.ba7f6efb5165f7df. traceparent: 00-dc4b4781b61b85309b22259e9dda4a3f-ba7f6efb5165f7df-00 Content-Length: 188 X-ARR-LOG-ID: 2fa9bfa7-43c6-4760-965d-c0ad459e3bfa CLIENT-IP: 191.234.200.86:15078 DISGUISED-HOST: inpart-hml-communication.azurewebsites.net X-SITE-DEPLOYMENT-ID: inpart-hml-communication WAS-DEFAULT-HOSTNAME: inpart-hml-communication.azurewebsites.net X-Forwarded-Proto: https X-AppService-Proto: https X-ARR-SSL: 2048|256|CN=Microsoft TLS G2 RSA CA OCSP 10, O=Microsoft Corporation, C=US|CN=*.azurewebsites.net, O=Microsoft Corporation, L=Redmond, S=WA, C=US X-Forwarded-TlsVersion: 1.3 X-Forwarded-For: 191.234.200.86:15078 X-Original-URL: /Communication/SendEmailGrid X-WAWS-Unencoded-URL: /Communication/SendEmailGrid X-Client-IP: 191.234.200.86 X-Client-Port: 15078
System.Exception: System.Exception: Erro ao abrir conexão com banco de dados. ---> System.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: TCP Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.Open() at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 30 ClientConnectionId:00000000-0000-0000-0000-000000000000 --- End of inner exception stack trace --- at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 36 at Inpart.Communication.Domain.Email.InsertQueueEmail(DtoCommunication msg) in /src/Inpart.Communication/Domain/Email.cs:line 20 at Inpart.Communication.Domain.Communication.SendEmaiGridl(DtoCommunication msg) in /src/Inpart.Communication/Domain/Communication.cs:line 56 at Inpart.Communication.Controllers.CommunicationController.CommunicationEmailGrid(DtoCommunication communication) in /src/Inpart.Communication/Controllers/CommunicationController.cs:line 28 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider) at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context) HEADERS ======= Accept: application/json, text/json, text/x-json, text/javascript, application/xml, text/xml Host: inpart-hml-communication.azurewebsites.net User-Agent: RestSharp/110.2.0.0 Accept-Encoding: gzip, deflate, br Content-Type: application/json; charset=utf-8 Max-Forwards: 10 Request-Id: |dc4b4781b61b85309b22259e9dda4a3f.ba7f6efb5165f7df. traceparent: 00-dc4b4781b61b85309b22259e9dda4a3f-ba7f6efb5165f7df-00 Content-Length: 188 X-ARR-LOG-ID: 2fa9bfa7-43c6-4760-965d-c0ad459e3bfa CLIENT-IP: 191.234.200.86:15078 DISGUISED-HOST: inpart-hml-communication.azurewebsites.net X-SITE-DEPLOYMENT-ID: inpart-hml-communication WAS-DEFAULT-HOSTNAME: inpart-hml-communication.azurewebsites.net X-Forwarded-Proto: https X-AppService-Proto: https X-ARR-SSL: 2048|256|CN=Microsoft TLS G2 RSA CA OCSP 10, O=Microsoft Corporation, C=US|CN=*.azurewebsites.net, O=Microsoft Corporation, L=Redmond, S=WA, C=US X-Forwarded-TlsVersion: 1.3 X-Forwarded-For: 191.234.200.86:15078 X-Original-URL: /Communication/SendEmailGrid X-WAWS-Unencoded-URL: /Communication/SendEmailGrid X-Client-IP: 191.234.200.86 X-Client-Port: 15078 at Inpart.Integracao.GerenciadorJobs.Helper.RequestHttp.Notification(DtoCommunication notification) in /src/Inpart.Integracao.GerenciadorJobs/Helper/RequestHttp.cs:line 27 at Inpart.Integracao.GerenciadorJobs.Services.JobVerificaIPExternoExterno.Execute() in /src/Inpart.Integracao.GerenciadorJobs/Services/JobVerificaIPExternoExterno.cs:line 25 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by DelayedJobScheduler
Retry attempt 1 of 1: System.Exception: Erro ao abrir conexão com banco…
An exception occurred during performance of the job.
System.Exception: Erro ao abrir conexão com banco de dados. ---> System.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: TCP Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.Open() at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 30 ClientConnectionId:00000000-0000-0000-0000-000000000000 --- End of inner exception stack trace --- at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 36 at Inpart.Communication.Domain.Email.InsertQueueEmail(DtoCommunication msg) in /src/Inpart.Communication/Domain/Email.cs:line 20 at Inpart.Communication.Domain.Communication.SendEmaiGridl(DtoCommunication msg) in /src/Inpart.Communication/Domain/Communication.cs:line 56 at Inpart.Communication.Controllers.CommunicationController.CommunicationEmailGrid(DtoCommunication communication) in /src/Inpart.Communication/Controllers/CommunicationController.cs:line 28 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider) at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context) HEADERS ======= Accept: application/json, text/json, text/x-json, text/javascript, application/xml, text/xml Host: inpart-hml-communication.azurewebsites.net User-Agent: RestSharp/110.2.0.0 Accept-Encoding: gzip, deflate, br Content-Type: application/json; charset=utf-8 Max-Forwards: 10 Request-Id: |fd6e495830c95cba64b4837f069d43ca.10dbe45f394f5e4d. traceparent: 00-fd6e495830c95cba64b4837f069d43ca-10dbe45f394f5e4d-00 Content-Length: 188 X-ARR-LOG-ID: 0ac3e072-9893-47d5-a28f-6f68994641c5 CLIENT-IP: 191.234.200.86:34148 DISGUISED-HOST: inpart-hml-communication.azurewebsites.net X-SITE-DEPLOYMENT-ID: inpart-hml-communication WAS-DEFAULT-HOSTNAME: inpart-hml-communication.azurewebsites.net X-Forwarded-Proto: https X-AppService-Proto: https X-ARR-SSL: 2048|256|CN=Microsoft TLS G2 RSA CA OCSP 10, O=Microsoft Corporation, C=US|CN=*.azurewebsites.net, O=Microsoft Corporation, L=Redmond, S=WA, C=US X-Forwarded-TlsVersion: 1.3 X-Forwarded-For: 191.234.200.86:34148 X-Original-URL: /Communication/SendEmailGrid X-WAWS-Unencoded-URL: /Communication/SendEmailGrid X-Client-IP: 191.234.200.86 X-Client-Port: 34148
System.Exception: System.Exception: Erro ao abrir conexão com banco de dados. ---> System.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: TCP Provider, error: 40 - Could not open a connection to SQL Server) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, Boolean applyTransientFaultHandling, String accessToken) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.Open() at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 30 ClientConnectionId:00000000-0000-0000-0000-000000000000 --- End of inner exception stack trace --- at Inpart.Communication.Data.ContextSql.Connection(String nomeInstancia) in /src/Inpart.Communication/Data/ContextSql.cs:line 36 at Inpart.Communication.Domain.Email.InsertQueueEmail(DtoCommunication msg) in /src/Inpart.Communication/Domain/Email.cs:line 20 at Inpart.Communication.Domain.Communication.SendEmaiGridl(DtoCommunication msg) in /src/Inpart.Communication/Domain/Communication.cs:line 56 at Inpart.Communication.Controllers.CommunicationController.CommunicationEmailGrid(DtoCommunication communication) in /src/Inpart.Communication/Controllers/CommunicationController.cs:line 28 at Microsoft.AspNetCore.Mvc.Infrastructure.ActionMethodExecutor.TaskOfIActionResultExecutor.Execute(ActionContext actionContext, IActionResultTypeMapper mapper, ObjectMethodExecutor executor, Object controller, Object[] arguments) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeActionMethodAsync>g__Logged|12_1(ControllerActionInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeNextActionFilterAsync>g__Awaited|10_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Rethrow(ActionExecutedContextSealed context) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.Next(State& next, Scope& scope, Object& state, Boolean& isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ControllerActionInvoker.<InvokeInnerFilterAsync>g__Awaited|13_0(ControllerActionInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeFilterPipelineAsync>g__Awaited|20_0(ResourceInvoker invoker, Task lastTask, State next, Scope scope, Object state, Boolean isCompleted) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Mvc.Infrastructure.ResourceInvoker.<InvokeAsync>g__Logged|17_1(ResourceInvoker invoker) at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context) at Microsoft.AspNetCore.Authorization.AuthorizationMiddleware.Invoke(HttpContext context) at Swashbuckle.AspNetCore.SwaggerUI.SwaggerUIMiddleware.Invoke(HttpContext httpContext) at Swashbuckle.AspNetCore.Swagger.SwaggerMiddleware.Invoke(HttpContext httpContext, ISwaggerProvider swaggerProvider) at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddlewareImpl.Invoke(HttpContext context) HEADERS ======= Accept: application/json, text/json, text/x-json, text/javascript, application/xml, text/xml Host: inpart-hml-communication.azurewebsites.net User-Agent: RestSharp/110.2.0.0 Accept-Encoding: gzip, deflate, br Content-Type: application/json; charset=utf-8 Max-Forwards: 10 Request-Id: |fd6e495830c95cba64b4837f069d43ca.10dbe45f394f5e4d. traceparent: 00-fd6e495830c95cba64b4837f069d43ca-10dbe45f394f5e4d-00 Content-Length: 188 X-ARR-LOG-ID: 0ac3e072-9893-47d5-a28f-6f68994641c5 CLIENT-IP: 191.234.200.86:34148 DISGUISED-HOST: inpart-hml-communication.azurewebsites.net X-SITE-DEPLOYMENT-ID: inpart-hml-communication WAS-DEFAULT-HOSTNAME: inpart-hml-communication.azurewebsites.net X-Forwarded-Proto: https X-AppService-Proto: https X-ARR-SSL: 2048|256|CN=Microsoft TLS G2 RSA CA OCSP 10, O=Microsoft Corporation, C=US|CN=*.azurewebsites.net, O=Microsoft Corporation, L=Redmond, S=WA, C=US X-Forwarded-TlsVersion: 1.3 X-Forwarded-For: 191.234.200.86:34148 X-Original-URL: /Communication/SendEmailGrid X-WAWS-Unencoded-URL: /Communication/SendEmailGrid X-Client-IP: 191.234.200.86 X-Client-Port: 34148 at Inpart.Integracao.GerenciadorJobs.Helper.RequestHttp.Notification(DtoCommunication notification) in /src/Inpart.Integracao.GerenciadorJobs/Helper/RequestHttp.cs:line 27 at Inpart.Integracao.GerenciadorJobs.Services.JobVerificaIPExternoExterno.Execute() in /src/Inpart.Integracao.GerenciadorJobs/Services/JobVerificaIPExternoExterno.cs:line 25 at InvokeStub_TaskAwaiter.GetResult(Object, Object, IntPtr*) at System.Reflection.MethodBaseInvoker.InvokeWithNoArgs(Object obj, BindingFlags invokeAttr)
Triggered by recurring job scheduler