We have migrated a SSRS 2008 report tot 2012. This report contains a data driven subscription and sends about 2.500 individual mails containing a PDF version of the report.
In SSRS 2008 this report was running OK, but in 2012 not all mails are sentm but SSRS says no error occurred. The recipients that don't receive their mails occur randomly. When we put the PDF's on a FileShare instead of mailing directly the number of PDF's is correct.
I am looking with a System Administrator to this problem and we think the problem is in our SMTP server.
emailextension!WindowsService_0!1218!10/11/2013-16:26:46:: e ERROR: Error sending email. Exception: System.Net.Mail.SmtpException: Exceeded storage allocation. The server response was: 4.3.1 Session size exceeds fixed maximum session size
at System.Net.Mail.DataStopCommand.CheckResponse(SmtpStatusCode statusCode, String serverResponse)
at System.Net.Mail.SmtpConnection.OnClose(Object sender, EventArgs args)
at System.Net.Mail.SmtpClient.Send(MailMessage message)
at Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider.Deliver(Notification notification)
We use a Windows SMTP server and increased the session size. Now there are no errors left in the LOG but still some mails fail.
I wonder if other people are experiencing the same problems and why this problem doesn't occur in SSRS 2008.
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net