October 14, 2013 at 12:06 am
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.ClosableStream.Close()
at System.Net.Mail.MailWriter.Close()
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
October 15, 2013 at 8:56 am
Just some additional info.
No mails are missing when using CSV as Render method. The message size is about 1 MB per mail when using PDF and seems to be a problem? However we checked our SMTP server and there are no restrictions on sizes applied. Also the log file does not contain any errors.
In SSRS 2008 everything seems to work OK. It seems to be an SSRS 2012 bug.
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
December 25, 2013 at 5:23 am
I know this is an old topic, but I have the proposed solution. I have contacted Microsoft about this issue and we figured out the solution for this problem.
Install the following update on the SQL2012 SP1 installation.
http://support.microsoft.com/kb/2894115
When using Windows SMTP server. Get rid of the SMTP limits "Limit Session Size KB" and "Limit number of messages by connection to"
(my SMTP server was running on Windows 2008-R2. )
Read the entire solution below.
http://dba60k.net/index.php/2013/12/23/ssrs-2012-mails-missing-when-using-data-driven-subscriptions-and-bulk-mail/[/url]
__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply