SSRS 2012 some mail subscriptions fail

  • 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

  • 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/%5B/url%5D

    __________________
    MS-SQL / SSIS / SSRS junkie
    Visit my blog at dba60k.net

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply