Reporting Services Subscriptions Stop arbitrarily

Hi,
periodically, our Reporting Service seems to fall over with respect to
Subscriptions (visiting subscriptions reveal they are in a state of
pending). We then restart the SQL Agent and the reporting services service
which seems to resolve the problem until it falls over again. Sometimes
this happens several times in a day, other times it may be a week.
Can anyone gives us suggestions as to what might be the cause of this?
thanks
MattYou best bet is to look in the log files and see if there is anything in
there that might lead you to the cause of the problem.
Is the report your rendering a large report? Perhaps it is using up all of
the available machine resources and causing RS to shut down. You may need
to look into using report execution snapshots for the report to lessen the
load on RS.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Matt" <NoSpam:Matthew.Moran@.Computercorp.com.au> wrote in message
news:OWUT%23qs8EHA.3700@.tk2msftngp13.phx.gbl...
> Hi,
> periodically, our Reporting Service seems to fall over with respect to
> Subscriptions (visiting subscriptions reveal they are in a state of
> pending). We then restart the SQL Agent and the reporting services
> service
> which seems to resolve the problem until it falls over again. Sometimes
> this happens several times in a day, other times it may be a week.
> Can anyone gives us suggestions as to what might be the cause of this?
> thanks
> Matt
>

Reporting Services Error after Install

Hi,
I seem to be seeing the below error after having setup reporting
services and visiting report manager. I'm not sure why it gives this
particular message. In IIS, the virtual folder is pointing towards the
C:\program files\microsoft sql server\... folder as is the default.
For some reason it is trying to look for this file in the below path
and I really have no idea why. The only thing I can think of is the
fact that this is the default inetpub path. I didn't do anything
fancy or special with the install so I'm not sure why this is
happening. Is there some config entry somewhere where this can be
changed?
Thanks,
Bill
Could not find file "d:\inetpub\wwwroot\ReportService2005.asmx".To add a little bit more information to this, all pages under
/reports/pages is producing this error. All pages in /ReportServer
render just fine.
Thanks,
Bill
zinck74 wrote:
> Hi,
> I seem to be seeing the below error after having setup reporting
> services and visiting report manager. I'm not sure why it gives this
> particular message. In IIS, the virtual folder is pointing towards the
> C:\program files\microsoft sql server\... folder as is the default.
> For some reason it is trying to look for this file in the below path
> and I really have no idea why. The only thing I can think of is the
> fact that this is the default inetpub path. I didn't do anything
> fancy or special with the install so I'm not sure why this is
> happening. Is there some config entry somewhere where this can be
> changed?
> Thanks,
> Bill
>
> Could not find file "d:\inetpub\wwwroot\ReportService2005.asmx".