Try to sending email not working with suscription in Reporting Services

Amin 1

Try to sending email not working with suscription in Reporting Services, the error is :

emailextension!WindowsService_29!475c!12/20/2021-07:00:08:: e ERROR: Error sending email. Exception: System.AggregateException: One or more errors occurred. ---> System.Net.Mail.SmtpException: The server committed a protocol violation The server response was:
at System.Net.Mail.SendMailAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpClient.SendMailCallback(IAsyncResult result)
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task.ThrowIfExceptional(Boolean includeTaskCanceledExceptions)
at System.Threading.Tasks.Task.Wait(Int32 millisecondsTimeout, CancellationToken cancellationToken)
at System.Threading.Tasks.Task.Wait(TimeSpan timeout)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
---> (Inner Exception #0) System.Net.Mail.SmtpException: The server committed a protocol violation The server response was:
at System.Net.Mail.SendMailAsyncResult.End(IAsyncResult result)
at System.Net.Mail.SmtpClient.SendMailCallback(IAsyncResult result)<---
. Additional Information: SmtpException StatusCode:GeneralFailure
notification!WindowsService_29!475c!12/20/2021-07:00:08:: e ERROR: Error occurred processing subscription d218375a-a99f-4b7a-98e5-4bbcb6f4b6d2: Failure sending mail: One or more errors occurred.Mail will not be resent.

is any idea to solven the error?

Best regards

Chandrika Ramisetti 6 Reputation points

2022-01-04T08:34:18.837+00:00

Hii Mexman, is your issue resolved? If so kindly share us what you have done. We are also facing the similar issue
Ashish Sinha 1 Reputation point

2022-01-06T22:20:39.737+00:00

I had exactly the same error and it was too random. i.e. The SSRS was able to complete the timed subscription successfully and fail randomly with no further hints in the logs.
The only thing which was a suspect was the SMTP server itself. The error happened as we were using smtp.office365.com
The office365 smtp server was the real culprit because after reading some blogs I changed the SMTP server from office365 to AuthSMTP and it fixed the problem straightaway.

AuthSMTP is a SMTP relay service but you can use any other SMTP relay server depending on your need and usage.

Hope it helps other users!

13 answers

Amin 1 Reputation point

2021-12-21T16:53:26.797+00:00

Thanks for the answers.

I have configure the subscription with office 365 in cloud, we have around 970 subscriptions enabled.
I investigated that Microsft have restrictios with STMP sending emails it's 30 emails each minute.

Some subscriptions are sent but others are not random. Every day I have about 300 errors for mailing.

Could is the root issue?

Best regards
Please sign in to rate this answer.
04147834 6 Reputation points

2021-12-21T17:00:31.483+00:00

We are sending no-where near this limit so I doubt that is the issue. The other odd part...I have a second report server that so far is having zero problems sending through the same Office 365 STMP server.

GlockByte 161 Reputation points

2022-01-06T19:12:26.763+00:00

I do not believe that is related. As per Microsoft it appears any excess will simply be queued, not denied

Additional throttling limits for the SMTP Authentication protocol are:

30 messages per minute
Recipient rate limit of 10,000 recipients per day
Exceeding these limits will cause the following issues:

Exceeding the per minute limit causes email delivery delays, any excess in message submission will be throttled and successively carried over to the following minutes.

Exceeding the per day limit causes the following error message:

554 5.2.0 STOREDRV.Submission.Exception:SubmissionQuotaExceededException
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Ilan Myers-Prudhomme 1 Reputation point

2021-12-29T17:21:47.31+00:00

I had this exact same issue. Looking into it, there seems to be a limit in sending emails to the same person within a given timeframe (milliseconds to seconds). I had the error only sending two emails through the subscription if the sendTo was the same email address.

So if there are duplicate emails in your subscriptions, and you are using Microsoft365 for SMTP, you might be running into this limit as well. I was getting the error every time, then I changed one of the email addresses to a different address and everything went through successfully and has since. No other changes were needed.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Joshua Pries 1 Reputation point

2021-12-31T19:03:31.997+00:00

I am having the same issue. However we are just starting up our report server and only have 7 active subscriptions. Still with these 7 we have a random amount (usually about half) failing every day. The error log looks exactly like the one Mexman posted with SMTP being setup through port 587 on office 365. There aren't any duplicate recipients in the subscriptions that are set to send at the same time. Does anyone have any other leads on what might be causing this?
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
04147834 6 Reputation points

2022-01-04T11:43:05.92+00:00

If it is of any assistance...I don't believe the problem is with the SMTP server. I tried switching the SMTP server and it too resulted in the error. The second SMTP server did not register any login attempts or appear to have any activity from the SSRS server. Also, this SSRS server only has four subscriptions that run once per day being sent to one email address - doesn't seem to be a sending limit.
Please sign in to rate this answer.
Amin 1 Reputation point

2022-01-04T15:26:02.263+00:00

Hi,

Is on premise or cloud SMTP service?

04147834 6 Reputation points

2022-01-04T15:26:57.59+00:00

Cloud service (postmark.com, which shows detailed logs for successful and failed transactions).
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Mike (Elcee) 6 Reputation points

2022-01-05T11:34:55.857+00:00

We are too facing this issue since recently! Using SRSS and Exchange Online/Office365
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Try to sending email not working with suscription in Reporting Services

13 answers

Your answer