none
Getting duplicate emails from SharePoint Report Library subscription.

    Question

  • Getting duplicate emails from SharePoint Report Library subscription.

    Users are subscribed for each item in Report Library and it is scheduled to send email at 3 PM every day.

    But, intermittently users are getting duplicate emails.

    Please let me know on how to troubleshoot...

    Thursday, December 12, 2013 2:33 PM

Answers

All replies

  • If you have Exchange, you can track the email from there to see if that yields any value. You can also turn up the diagnostic logging in Central Admin -> Monitoring -> Configure diagnostic logging -> SQL Server Reporting Services, and selecting:

    Report Server Email Extension

    Report Server Schedule

    Report Server Subscription

    Turn them up to Verbose in the Trace log, then monitor the ULS log when you identify a user who has received duplicate emails.


    Trevor Seward, MCC

    Follow or contact me at...
      

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Thursday, December 12, 2013 3:36 PM
  • Thanks Trevor.

    Will check with verbose logging.

    ---

    Abhilash

    Thursday, December 12, 2013 4:10 PM
  • Hi Trevor,

    I don't see Report Server Email Extension, Report Server Schedule, Report Server Subscription option in diagnostic logging to enabled verbose...

    Thanks,
    Abhilash

    Friday, December 13, 2013 2:28 PM
  • Hi Abilash, do you see "SQL Server Reporting Services" as a category under diagnostic logging?

    Dimitri Ayrapetov (MCSE: SharePoint)

    Friday, December 13, 2013 2:29 PM
  • Hi Dimitri,

    Yes, there is SQL Server Reporting Services category with following options

    Configuration Pages
    HTTP Redirector
    Local Mode Processing
    Local Mode Rendering
    SOAP Client Proxy
    UI Pages

    Friday, December 13, 2013 3:26 PM
  • Check if the emails are stuck at exchange triggered twice while retrying to relay it


    Mark ANSWER if this reply resolves your query, If helpful then VOTE HELPFUL
    INSQLSERVER.COM Mohammad Nizamuddin

    Friday, December 13, 2013 3:56 PM
  • Did not get any useful info after turning on Verbose...

    I am yet to check on exchange side asi dont have access to it. Any other ideas?

    Thanks,
    Abhilash

    Thursday, December 19, 2013 8:05 AM
  • You'll want to check the Exchange server. I would contact those who operate it.

    Trevor Seward, MCC

    Follow or contact me at...
      

    This post is my own opinion and does not necessarily reflect the opinion or view of Microsoft, its employees, or other MVPs.

    Thursday, December 19, 2013 4:42 PM
  • Check this link something similar issue:

    http://stackoverflow.com/questions/8477847/ssrs-subscriptions-duplicating-email



    Mark ANSWER if this reply resolves your query, If helpful then VOTE HELPFUL
    INSQLSERVER.COM Mohammad Nizamuddin

    Friday, December 20, 2013 1:19 AM