SSRS E-mail Subscription Failures RRS feed

  • Question

  • Hello,

    I'm aware that there have been several discussions about E-mail Subscription Failures. My scenario is a little bit different. We developed a SSIS package that creates one-time subscriptions based on SQL server records. It works pretty well except sometimes certain subscriptions do not fire. No Error messages in SSRS log, or System Event Log, or on SMTP (we use Unix box for that) side. I'm not sure where to start my troubleshooting. It looks like something gets hung up.

    My questions:
    1) Has anyone experienced this?
    2) How to troubleshoot IIS WP in this situation? What settings I can change in IIS?
    3) Can SMTP Server Error cause entire subscription to fail?

    Any advice would be appreciated.




    Friday, March 13, 2009 6:16 PM