Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2012 some mail subscriptions fail Expand / Collapse
Author
Message
Posted Monday, October 14, 2013 12:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 6:36 AM
Points: 40, Visits: 460
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
Post #1504323
Posted Tuesday, October 15, 2013 8:56 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 6:36 AM
Points: 40, Visits: 460
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
Post #1504800
Posted Wednesday, December 25, 2013 5:23 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 2, 2014 6:36 AM
Points: 40, Visits: 460
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/


__________________
MS-SQL / SSIS / SSRS junkie
Visit my blog at dba60k.net
Post #1525884
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse