SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SSRS 2012 some mail subscriptions fail


SSRS 2012 some mail subscriptions fail

Author
Message
peterjonk
peterjonk
SSC-Enthusiastic
SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)

Group: General Forum Members
Points: 119 Visits: 619
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
peterjonk
peterjonk
SSC-Enthusiastic
SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)

Group: General Forum Members
Points: 119 Visits: 619
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
peterjonk
peterjonk
SSC-Enthusiastic
SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)SSC-Enthusiastic (119 reputation)

Group: General Forum Members
Points: 119 Visits: 619
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search