Skip to content

Instantly share code, notes, and snippets.

@apikyanrobert
Created November 8, 2019 10:33
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save apikyanrobert/d14c472f4e8e598ac4bac7a7edf39ccb to your computer and use it in GitHub Desktop.
Save apikyanrobert/d14c472f4e8e598ac4bac7a7edf39ccb to your computer and use it in GitHub Desktop.
System.Data.SqlClient.SqlException (0x80131904): The EXECUTE permission was denied on the object 'sp_send_dbmail', database 'msdb', schema 'dbo'.
Cannot insert the value NULL into column 'SentEmailID', table '@SentEmails'; column does not allow nulls. INSERT fails.
The statement has been terminated.
at System.Data.SqlClient.SqlCommand.<>c.<ExecuteDbDataReaderAsync>b__126_0(Task`1 result)
at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2.InnerInvoke()
at System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state)
--- End of stack trace from previous location where exception was thrown ---
at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread)
--- End of stack trace from previous location where exception was thrown ---
at Dapper.SqlMapper.QueryAsync[T](IDbConnection cnn, Type effectiveType, CommandDefinition command) in C:\projects\dapper\Dapper\SqlMapper.Async.cs:line 419
at TradeCloud.Data.MailRepository.SendMail(IEnumerable`1 containers, String subject, String profileName, String attachedFiles) in /src/src/TradeCloud.Data/MailRepository.cs:line 40
at TradeCloud.Services.MailService.SendMail(IEnumerable`1 containers, String subject, String profileName, IEnumerable`1 attachedFiles) in /src/src/TradeCloud.Services/MailService.cs:line 35
at TradeCloud.AuthenticationServer.ResourceOwnerPasswordValidator.ValidateAsync(ResourceOwnerPasswordValidationContext context) in /src/src/TradeCloud.AuthenticationServer/ResourceOwnerPasswordValidator.cs:line 413
at IdentityServer4.Validation.TokenRequestValidator.ValidateResourceOwnerCredentialRequestAsync(NameValueCollection parameters)
at IdentityServer4.Validation.TokenRequestValidator.RunValidationAsync(Func`2 validationFunc, NameValueCollection parameters)
at IdentityServer4.Validation.TokenRequestValidator.ValidateRequestAsync(NameValueCollection parameters, ClientSecretValidationResult clientValidationResult)
at IdentityServer4.Endpoints.TokenEndpoint.ProcessTokenRequestAsync(HttpContext context)
at IdentityServer4.Endpoints.TokenEndpoint.ProcessAsync(HttpContext context)
at IdentityServer4.Hosting.IdentityServerMiddleware.Invoke(HttpContext context, IEndpointRouter router, IUserSession session, IEventService events)
at IdentityServer4.Hosting.IdentityServerMiddleware.Invoke(HttpContext context, IEndpointRouter router, IUserSession session, IEventService events)
at IdentityServer4.Hosting.MutualTlsTokenEndpointMiddleware.Invoke(HttpContext context, IAuthenticationSchemeProvider schemes)
at Microsoft.AspNetCore.Authentication.AuthenticationMiddleware.Invoke(HttpContext context)
at IdentityServer4.Hosting.BaseUrlMiddleware.Invoke(HttpContext context)
at Microsoft.AspNetCore.Diagnostics.DeveloperExceptionPageMiddleware.Invoke(HttpContext context)
ClientConnectionId:91714878-a073-4b9a-8746-aa85d7581b07
Error Number:229,State:5,Class:14
HEADERS
=======
Cache-Control: no-cache
Content-Type: multipart/form-data; boundary=--------------------------083593659405332144078648
Accept: */*
Accept-Encoding: gzip, deflate
Host: auth.tce.local
User-Agent: PostmanRuntime/7.19.0
Content-Length: 777
X-Request-ID: 2273b5552ba7f316a49e17c0aa689086
X-Real-IP: 10.44.0.0
X-Forwarded-For: 10.44.0.0
X-Forwarded-Host: auth.tce.local
X-Forwarded-Port: 80
X-Forwarded-Proto: http
X-Original-URI: /connect/token
X-Scheme: http
Postman-Token: 44cace02-30b5-4c4a-8816-f0fb1ecf8d05
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment