Failure sending mail: Cannot access a closed Stream

Running Report Server SP2 and can't get reliable Subscription emails sent.
Keep getting the error"Failure sending mail: Cannot access a closed Stream"
As a test I subscribed to a report to run every 2 minutes and let it run all
night. Surprisingly, the email succeeded and was sent to me two times every
four hours and then would fail for another four hours. (Example emailed ok at
6:00pm and 6:02pm but then failed every two minutes until it was again
successful at 10:00pm and 10:02pm) This cycle continued all night.
I have seen multiple strings on this same error in other newsgroups and
google searches but never any solutions. Does anyone have anything I can try?
I am getting desperate. Thanks in advance.Any luck with finding a solution to this problem? We are also suffering
through the same situation. It seems to occur mainly with subscriptions that
have mulitple recipients listed. It also only occurs only every now and
then. Very hard to troubleshoot. It began after application of SP2.
"Dan Varozza" wrote:
> Running Report Server SP2 and can't get reliable Subscription emails sent.
> Keep getting the error"Failure sending mail: Cannot access a closed Stream"
> As a test I subscribed to a report to run every 2 minutes and let it run all
> night. Surprisingly, the email succeeded and was sent to me two times every
> four hours and then would fail for another four hours. (Example emailed ok at
> 6:00pm and 6:02pm but then failed every two minutes until it was again
> successful at 10:00pm and 10:02pm) This cycle continued all night.
> I have seen multiple strings on this same error in other newsgroups and
> google searches but never any solutions. Does anyone have anything I can try?
> I am getting desperate. Thanks in advance.|||No I have had no luck finding a solution. I too noticed that it was happening
with reports that had multiple subscriptions and recipients. My solution for
now was to delete all subscriptions and replace them with one subscription
that contains all the recipients. This subscription now runs fine once per
day and sends out the email to all the recipients. It seems the mail delivery
only has a problem when there are a lot a mail jobs occuring at different
times for a given report. Funny thing is that I see this error reproted on
other posts and never any answers. It's like nobody at Microsoft wants to
acknowledge this issue so I guess we have to live with it.
"John Marks" wrote:
> Any luck with finding a solution to this problem? We are also suffering
> through the same situation. It seems to occur mainly with subscriptions that
> have mulitple recipients listed. It also only occurs only every now and
> then. Very hard to troubleshoot. It began after application of SP2.
>
> "Dan Varozza" wrote:
> > Running Report Server SP2 and can't get reliable Subscription emails sent.
> > Keep getting the error"Failure sending mail: Cannot access a closed Stream"
> >
> > As a test I subscribed to a report to run every 2 minutes and let it run all
> > night. Surprisingly, the email succeeded and was sent to me two times every
> > four hours and then would fail for another four hours. (Example emailed ok at
> > 6:00pm and 6:02pm but then failed every two minutes until it was again
> > successful at 10:00pm and 10:02pm) This cycle continued all night.
> >
> > I have seen multiple strings on this same error in other newsgroups and
> > google searches but never any solutions. Does anyone have anything I can try?
> > I am getting desperate. Thanks in advance.