Showing posts with label subscription. Show all posts
Showing posts with label subscription. Show all posts

Friday, February 24, 2012

Failure writing file

I get "Failure writing file" ... when my subscription runs? Does any one know
how to fix it?Can you post the error message in the ReportServerService<date>.log file.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"AbiBaby" <AbiBaby@.discussions.microsoft.com> wrote in message
news:17C09CC5-47F8-447A-B185-34143ABDAE2C@.microsoft.com...
> I get "Failure writing file" ... when my subscription runs? Does any one
know
> how to fix it?|||you should give to you network user the right to access (write) the folder
where you report are delivred.
"AbiBaby" wrote:
> I get "Failure writing file" ... when my subscription runs? Does any one know
> how to fix it?|||It has all Rights, i eneabled everyone. I wrote my own subscription service.
And it works!
"Tino [Securitas.fr]" wrote:
> you should give to you network user the right to access (write) the folder
> where you report are delivred.
> "AbiBaby" wrote:
> > I get "Failure writing file" ... when my subscription runs? Does any one know
> > how to fix it?

Sunday, February 19, 2012

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.

Failure Sending Mail

Hello all,
I have a particular problem with subscriptions when the subscription is
created by a user who is not an administrator. The problem points to a
permissions issue but I've tried several ways to resolve this without any
luck.
If the subscription is run only selecting a link to the report the
subscription works fine. I've gave the user the same role based permissions
as myself within the report server and set them up with Read & Execute, List
Folder Content and Read access on the Reports and ReportServer within IIS and
the folders are set to use Integrated Windows authentication.
The user can run the report OK and export to any of teh available options
from the list. Any help with this would be much appreciated.
Regards
MikeOn Feb 8, 6:52 am, MikeD <M...@.discussions.microsoft.com> wrote:
> Hello all,
> I have a particular problem with subscriptions when the subscription is
> created by a user who is not an administrator. The problem points to a
> permissions issue but I've tried several ways to resolve this without any
> luck.
> If the subscription is run only selecting a link to the report the
> subscription works fine. I've gave the user the same role based permissions
> as myself within the report server and set them up with Read & Execute, List
> Folder Content and Read access on the Reports and ReportServer within IIS and
> the folders are set to use Integrated Windows authentication.
> The user can run the report OK and export to any of teh available options
> from the list. Any help with this would be much appreciated.
> Regards
> Mike
I had an application that would create a subscription, and what I
found was this:
To create a subscription programmatically the user you are using to
create the subscription must have Content Manager permissions. This
is a System level role that is available under Site Settings on the
Home page, as opposed to the standard roles on the folders.|||Thanks for the info. The user in question has Content Manager role set but
the subscription is not being set programatically, the user is creating the
subscription via the Report Manager web page. As mentioned it only fails when
an attachment is done, it works OK when only a link to th report is included.
"DMcM" wrote:
> On Feb 8, 6:52 am, MikeD <M...@.discussions.microsoft.com> wrote:
> > Hello all,
> >
> > I have a particular problem with subscriptions when the subscription is
> > created by a user who is not an administrator. The problem points to a
> > permissions issue but I've tried several ways to resolve this without any
> > luck.
> >
> > If the subscription is run only selecting a link to the report the
> > subscription works fine. I've gave the user the same role based permissions
> > as myself within the report server and set them up with Read & Execute, List
> > Folder Content and Read access on the Reports and ReportServer within IIS and
> > the folders are set to use Integrated Windows authentication.
> >
> > The user can run the report OK and export to any of teh available options
> > from the list. Any help with this would be much appreciated.
> >
> > Regards
> >
> > Mike
> I had an application that would create a subscription, and what I
> found was this:
> To create a subscription programmatically the user you are using to
> create the subscription must have Content Manager permissions. This
> is a System level role that is available under Site Settings on the
> Home page, as opposed to the standard roles on the folders.
>