ReportServer: newly published reports and/or folders - how to remove the "!NEW" in gre

I am heavily using ReportServer to disseminate reports around my company, but I cannot get rid of the "!NEW" message in green beside each newly published item.
Help is appreciated, thanks.

You cannot remove it manually. It will go away automatically after 2 days (currently this value cannot be configured).

Obviously, you set the system time of the report server to a date in the past, publish the reports, and then set the system time to present time ...

-- Robert

ReportServer: newly published reports and/or folders - how to remove the "!NEW" in

I am heavily using ReportServer to disseminate reports around my company, but I cannot get rid of the "!NEW" message in green beside each newly published item.
Help is appreciated, thanks.

You cannot remove it manually. It will go away automatically after 2 days (currently this value cannot be configured).

Obviously, you set the system time of the report server to a date in the past, publish the reports, and then set the system time to present time ...

-- Robert

sql

ReportServer works, but ReportManager raises "Unable to connect" e

When I open reports from the ReportManager, the parameter list and the
reporting toolbar seem to be missing the normal style, and I get an "unable
to connect to the remote server The attempted operation is not supported for
the type of object referenced" error.
I can successfully execute reports from Visual Studio 'Run' or by browsing
"http://localhost/ReportServer/Pages/...".
BTW, this is a completely fresh XP and SQL2005 install, and I've seen the
same problem on another machine. Which probably means I made the same
mistake on both machines. ;-)
Thanks in advance,
TomDid you ever get this to work properly? What did it take to resolve?
"SQL2005_rocks" wrote:
> When I open reports from the ReportManager, the parameter list and the
> reporting toolbar seem to be missing the normal style, and I get an "unable
> to connect to the remote server The attempted operation is not supported for
> the type of object referenced" error.
> I can successfully execute reports from Visual Studio 'Run' or by browsing
> "http://localhost/ReportServer/Pages/...".
> BTW, this is a completely fresh XP and SQL2005 install, and I've seen the
> same problem on another machine. Which probably means I made the same
> mistake on both machines. ;-)
> Thanks in advance,
> Tom|||Nope.
Microsoft Developer Support has been investigating for two weeks. I'll post
when I know more.
"Audie Wright" wrote:
> Did you ever get this to work properly? What did it take to resolve?|||I actually got mine to work. I had SQL2K5 Developer installed on my
workstation (XP).
I reviewed what I had changed in the past week, and traced it to an
installation of Norton Privacy Service. I de-installed it, and it worked
properly.
It appeared to be an issue with how the winsock is controlled.
You could try a netsh winsock reset, reboot, and try it.
"SQL2005_rocks" wrote:
> Nope.
> Microsoft Developer Support has been investigating for two weeks. I'll post
> when I know more.
>
> "Audie Wright" wrote:
> > Did you ever get this to work properly? What did it take to resolve?
>

ReportServer windows service starting and stopping

I'm having a problem with my subscriptions running because it looks like the
ReportServer windows service is stopping and starting. I get a message a few
times a day in the application log stating that the service is starting so
I'm assuming it is shutting down for some reason. Is there a way to stop
this?You need to look in the reportserverservice_<timestamp>.log file to try and
see why the service is restarting. It should not be doing that.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:F7E9A059-1D15-4392-8B6D-E8D0465E34EC@.microsoft.com...
> I'm having a problem with my subscriptions running because it looks like
> the
> ReportServer windows service is stopping and starting. I get a message a
> few
> times a day in the application log stating that the service is starting so
> I'm assuming it is shutting down for some reason. Is there a way to stop
> this?|||I checked the log files. I don't get too much detail of why it's stopping. It
looks like it does 2 cleanup cycles and it stops. It looks like it will
start when I go to the report manager and stops after doing the cleanup. The
problem is that when a report is scheduled to run, the service doesn't
startup. so they don't run. Each log file ends with lines like:
y!108c!4/28/2005-09:18:49:: i INFO: Cleaned 0 batch records, 0 policies, 0
sessions, 0 cache entries, 4 snapshots, 18 chunks, 0 running jobs
w3wp!library!1660!4/28/2005-09:28:49:: i INFO: Cleaned 0 batch records, 0
policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
w3wp!webserver!1668!4/28/2005-09:29:12:: i INFO: Reporting Web Server stopped
"Daniel Reib (MSFT)" wrote:
> You need to look in the reportserverservice_<timestamp>.log file to try and
> see why the service is restarting. It should not be doing that.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Brian" <Brian@.discussions.microsoft.com> wrote in message
> news:F7E9A059-1D15-4392-8B6D-E8D0465E34EC@.microsoft.com...
> > I'm having a problem with my subscriptions running because it looks like
> > the
> > ReportServer windows service is stopping and starting. I get a message a
> > few
> > times a day in the application log stating that the service is starting so
> > I'm assuming it is shutting down for some reason. Is there a way to stop
> > this?
>
>|||You are looking at the wrong log files, there should be some called
ReportServerService_<timestamp> you might also look at
ReportserverService__main_<timestamp>.log files for information.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Brian" <Brian@.discussions.microsoft.com> wrote in message
news:85B4763F-FA14-4EA1-A58F-8272E1ED6765@.microsoft.com...
>I checked the log files. I don't get too much detail of why it's stopping.
>It
> looks like it does 2 cleanup cycles and it stops. It looks like it will
> start when I go to the report manager and stops after doing the cleanup.
> The
> problem is that when a report is scheduled to run, the service doesn't
> startup. so they don't run. Each log file ends with lines like:
> y!108c!4/28/2005-09:18:49:: i INFO: Cleaned 0 batch records, 0 policies, 0
> sessions, 0 cache entries, 4 snapshots, 18 chunks, 0 running jobs
> w3wp!library!1660!4/28/2005-09:28:49:: i INFO: Cleaned 0 batch records, 0
> policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running
> jobs
> w3wp!webserver!1668!4/28/2005-09:29:12:: i INFO: Reporting Web Server
> stopped
>
>
> "Daniel Reib (MSFT)" wrote:
>> You need to look in the reportserverservice_<timestamp>.log file to try
>> and
>> see why the service is restarting. It should not be doing that.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Brian" <Brian@.discussions.microsoft.com> wrote in message
>> news:F7E9A059-1D15-4392-8B6D-E8D0465E34EC@.microsoft.com...
>> > I'm having a problem with my subscriptions running because it looks
>> > like
>> > the
>> > ReportServer windows service is stopping and starting. I get a message
>> > a
>> > few
>> > times a day in the application log stating that the service is starting
>> > so
>> > I'm assuming it is shutting down for some reason. Is there a way to
>> > stop
>> > this?
>>

ReportServer Website

Ok, I have this up and running thanks to the help of lots of users in this forum (Thank You again)

I deployed some reports, and everything looks fine, however to add another twist to this, I would like the website to look prettier, by adding something like a welcome page,and some folders and such.

Does anyone have any ideas on how to do that ? DO you have any material or a website, where I can get some info ?

Thanks

Which site? The Report Manager? It supports limited costomization through CSS styles (see C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportManager\Styles)

ReportServer Web Service Problem

Hi,
We're getting some really odd behavior from ReportServer calls (e.g.
CreateReport, CreateDataSource). They all complete successfully, but
SOMETIMES create no objects! (at least they are not visible in the Report
Manager and Report Server). It looks like something must "committed" in order
to make changes permanent, I don't know. The behavior is really strange,
because it happens only from time to time, maybe every 5th run in a row (just
by running the same code multiple times and deleting objects between runs).
This is on SQL Express 2005 (haven't tried on other editions, because we
need the free one).
The sequence is as follows:
ReportServer.CreateFolder("test", "/", null);
ReportServer.CreateDataSource("testds", "/test", true, dsdef, null);
ReportServer.CreateReport("testrep", "/test", true, binaryRdl, null);
Report server calls are made through the stub generated from WSDL file taken
from the same server.
Any ideas why this could happen? Maybe servers transactions must be
committed somehow? Or do we need to close report server connection, or call
Logoff method?
Thanks,
MikeMore info on this issue. When I hit refresh in IE in the Report Manager, the
newly created item is not listed, but when I hit F5 multiple times, it
sometimes dumps the following: The item '/test' cannot be found.
(rsItemNotFound). "/test" - is the object that is "half-created" through
CreateFolder call. Looks like a bug in SRS, right?|||Looks like SRS maintains a sort of internal cache for deleted objects and all
management functions (Create*) get stuck on this cache. The workaround for
the issue I explained above is to wait "a little bit" (like 30-50 seconds),
until deleted objects finally "disappear". Microsoft should address this
issue in their future releases.

ReportServer virtual directory doubt...

Can a reportserver/reportmanager virtual directory be configured to run inside another virtual directory.

say...http://mymachine/web/reports

Thanks

Samuel

That should not be an issue. I have done this in the past ... Is there a specific reason why you want to do this?|||

i have report server running under my website......do i have to create another virtual directory and point it to what the main reportserver directory is pointing too.

this we need to do as we are publishing a host of application under /web/ virtual directory in ISA. and from my applications the call goes to

from internet http://domainname/web/reportserver

from LAN http://website/reportserver

reportserver2005,IIS6.0,win2003 server.

t

|||

Thats easy,

All you have to do is go to teh actual folder's properties under websharing.

you should see in the top list box, if you have multiple websites on the server. you should all of them listed in a dropdown list box. just select the preferred one.

sql

Reportserver virtual directory

On my web hosting server the inetpub/wwwroot folder is located on D: drive, and the web hosting company configured it that way.

When i have installed the sql server 2005 it created the virtual directory under c:\inetpub\wwwroot which is not a default website location on that server.

could you please tell me how to switch the virtual directory path from c:\inetpub\wwwroot

to

d:\inetpub\wwwroot

Please any help would be greatly appreciated.

Thank you very much.

I'm not quite sure how you mean. When RS installs it doesn't place any files in c:\inetpub\wwwroot. The standard location will be

C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer

Note that the drive letter and the number after the MSSQL. part may vary depending on the choices made during setup and the SQL Server components selected.

The using the configuration tool, it creates 2 virtual directories beneath the default website i.e. the one on port 80 called "reportserver" and "reports" and these are just pointers to the physical directories located int he above install path.

Please can you clarify the issue you seem to be having?

ReportServer URL Access : French language problem for parameters (dates) after installing SQL 20

Hello,

We are using ReportServer URL Access. The parameters aren't pass into the URL, they have a default value and it's possible to change them by the "parameter toolbar". We are using datetime parameters with the very usefull calendar...

We are using a French version of : Windows (XP or W2K3), SQL2005+SP1 and VS2005 + SP1. It works fine, the calendar (for datetime parameter) is in French.

After installing the French SP2, the calendar is in English (w2k3 + VS2005 SP1). On a new installation (XP), with SQLExpress SP2 Advanced + Toolkit (in French), we have the same problem.

With this URL (solution 1), the calendar is in English (it was in French before the SP2):

http://localhost/Reportserver$SQLExpress?%2fProjet+de+rapport1%2fReport1&rs:Command=Render

But with this URL (solution 2), the calendar is in French :

http://localhost/ReportServer$SQLExpress/Pages/ReportViewer.aspx?%2fProjet+de+rapport1%2fReport1&rs%3aCommand=Render

In the documentation, we have to use solution 1 (but we have a problem). Is the solution 2 a possible "alternative" ?

Thanks for your help,

Frederic

I'm having the same problem using SQL Server 2005 Standard Edition, and I'm using the same workaround (my local language is spanish, but the ReportServer doesn't pay much attention to neither the report language nor the browser language).

I hope someone answers your question. According to the documentation it shouldn′t be necessary.

Alfonso

ReportServer URL Access : French language problem for parameters (dates) after installing SQL 20

Hello,

We are using ReportServer URL Access. The parameters aren't pass into the URL, they have a default value and it's possible to change them by the "parameter toolbar". We are using datetime parameters with the very usefull calendar...

We are using a French version of : Windows (XP or W2K3), SQL2005+SP1 and VS2005 + SP1. It works fine, the calendar (for datetime parameter) is in French.

After installing the French SP2, the calendar is in English (w2k3 + VS2005 SP1). On a new installation (XP), with SQLExpress SP2 Advanced + Toolkit (in French), we have the same problem.

With this URL (solution 1), the calendar is in English (it was in French before the SP2):

http://localhost/Reportserver$SQLExpress?%2fProjet+de+rapport1%2fReport1&rs:Command=Render

But with this URL (solution 2), the calendar is in French :

http://localhost/ReportServer$SQLExpress/Pages/ReportViewer.aspx?%2fProjet+de+rapport1%2fReport1&rs%3aCommand=Render

In the documentation, we have to use solution 1 (but we have a problem). Is the solution 2 a possible "alternative" ?

Thanks for your help,

Frederic

I'm having the same problem using SQL Server 2005 Standard Edition, and I'm using the same workaround (my local language is spanish, but the ReportServer doesn't pay much attention to neither the report language nor the browser language).

I hope someone answers your question. According to the documentation it shouldn′t be necessary.

Alfonso

reportserver url - get Directory Listing Denied

I have two servers, basically identical on which reporting services is installed.

On one when i go to the /reportserver url i get to a listing of report directories/reports o the server.

On the 2nd, I get the IIS error:

Directory Listing Denied

I've checked and all of the settings i can verify (in report server, Iis etc.) are identical on both.

What might cause this?

thx.

r-

The reportserver virtual root should be configured to map all extensions to aspnet_isapi.dll. It sounds like this is not the case. If you are using Report Server 2005, you might want to recreate the virtual root using the Report Server Config Tool.

ReportServer Site error

Hi, i installed SQL Server with Reporting Services... when i try to access the ReportServer website i get this error. Can someone help me?

Server Error in '/ReportServer' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.

Source Error:

[No relevant source lines]

Source File: c:\inetpub\wwwroot\web.config Line: 0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

If you see, it says that the source file is "c:\inetpub\wwwroot\web.config" but my ReportServer document root is in other place, i've tried coping the web.config file to wwwroot, but nothing.

I guess you need to add permissions to your root folder which is wwwroot. Right click on the folder and in the Security tab, add MachineName\ASPNET user to the list and give all permission to that user.

Shyam

|||i've done what you sayed, but everything stayed the same... The report server service is runing under Local System account, also gave it permission but still nothing happend... i really need help since i've to install Microsoft CRM and it needs a running Report Server|||

I guess this link will be helpful for you:

http://blog.devstone.com/Aaron/archive/2004/12/03/359.aspx

Shyam

|||did that with some differences since i'm at a domain controller... nothing happened... thanks for the fast answer...|||So, is your problem solved? Can the post be marked as answer?|||i still have the same problem.... i followed the page you posted me but nothing happened...|||

Then try the last resort, which is to restart the machine. I'm sorry for this cliche in the Microsoft community.

Shyam

|||sorry, i've tried, and sorry if i wait 'till the mornings to answer, but the only time i've got to try to fix this problem is at nights when there aren't users, thanks for all your help but, the problem is still there sql

ReportServer Site error

Hi, i installed SQL Server with Reporting Services... when i try to access the ReportServer website i get this error. Can someone help me?

Server Error in '/ReportServer' Application.

---

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: An error occurred loading a configuration file: Failed to start monitoring changes to 'c:\inetpub\wwwroot\web.config' because access is denied.

Source Error:

[No relevant source lines]

Source File: c:\inetpub\wwwroot\web.config Line: 0

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

If you see, it says that the source file is "c:\inetpub\wwwroot\web.config" but my ReportServer document root is in other place, i've tried coping the web.config file to wwwroot, but nothing.

I guess you need to add permissions to your root folder which is wwwroot. Right click on the folder and in the Security tab, add MachineName\ASPNET user to the list and give all permission to that user.

Shyam

|||i've done what you sayed, but everything stayed the same... The report server service is runing under Local System account, also gave it permission but still nothing happend... i really need help since i've to install Microsoft CRM and it needs a running Report Server|||

I guess this link will be helpful for you:

http://blog.devstone.com/Aaron/archive/2004/12/03/359.aspx

Shyam

|||did that with some differences since i'm at a domain controller... nothing happened... thanks for the fast answer...|||So, is your problem solved? Can the post be marked as answer?|||i still have the same problem.... i followed the page you posted me but nothing happened...|||

Then try the last resort, which is to restart the machine. I'm sorry for this cliche in the Microsoft community.

Shyam

|||sorry, i've tried, and sorry if i wait 'till the mornings to answer, but the only time i've got to try to fix this problem is at nights when there aren't users, thanks for all your help but, the problem is still there

ReportServer service won't start, and gettign website error

Hi.
I';ve had an installation of reporting services running fine for months
now. This morning, I started getting the following error when trying to
access the report manager:
"Unable to communicate with report server. Please verify that the
report server is operational"
Also, the ReportServer service won't start. I get an error back saying
that "the service did not return an error", which is nice and helpful.
Any ideas what would cause this?Go to IIS make sure no one deleted the folder called ReportServer

ReportServer Service will not start

Hi, im running reporting service 2000 on a sql 2000 server. Everything worked fine last week, now i cannont access the reporting services. I tried manually starting the service but it will not start. Any help would be appcreciated.

Thanks

Have you checked the Windows event log or the Reporting Services logs for some guidance as to what the problem is?

Jarret

|||Yeah, i checked there, it shows nothing.. this is what i get when i try to access it.. not sure if this would help. And now for somereason its working.. after a week, it just started working... hmmm... thats odd.. thanks anyway

ReportServer service terminated unexpectedly

The Report Server service is failing, almost on a daily basis.
Description:
The ReportServer service terminated unexpectedly. It has done this 39
time(s). The following corrective action will be taken in 60000
milliseconds: Restart the service.
Sometimes the service is unable to restart and I get the following error.
Timeout (30000 milliseconds) waiting for the ReportServer service to connect.
Then I get ..
The ReportServer service failed to start due to the following error:
The service did not respond to the start or control request in a timely
fashion.
Google returns nothing on how to troublshoot this problem,
Can someone please point me in the right direction on how to resolve this.
Your Help is much Apprieciated.I have the same problem and it is not memory or dasd on the server!
Not only that Visual Studio - hangs all the time in 2005 --
Reports that work perfectly - then migrated to 2005 do not work the same !
This is starting to become a waste of time joke!
Where are all of the MS people that touted RS 2005 - CAN WE HAVE SOME
ANSWERS - or to busy at trade shows?
"D1p4k" wrote:
> The Report Server service is failing, almost on a daily basis.
> Description:
> The ReportServer service terminated unexpectedly. It has done this 39
> time(s). The following corrective action will be taken in 60000
> milliseconds: Restart the service.
> Sometimes the service is unable to restart and I get the following error.
> Timeout (30000 milliseconds) waiting for the ReportServer service to connect.
> Then I get ..
> The ReportServer service failed to start due to the following error:
> The service did not respond to the start or control request in a timely
> fashion.
> Google returns nothing on how to troublshoot this problem,
> Can someone please point me in the right direction on how to resolve this.
> Your Help is much Apprieciated.|||Since MS started the web based forums that is where all the Microsoft people
are. I suggest taking one by one your issues and asking there. I haven't see
the issues but that is at least partly due to the fact I am not doing much
with graphs (reading your posts it seems like a lot has to do with that).
Same could be with VS. I never see it hang. Ever.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"code_slayer_bkk" <codeslayerbkk@.discussions.microsoft.com> wrote in message
news:282A44D1-C5CA-4EA4-8302-535800E17D8C@.microsoft.com...
>I have the same problem and it is not memory or dasd on the server!
> Not only that Visual Studio - hangs all the time in 2005 --
> Reports that work perfectly - then migrated to 2005 do not work the same !
> This is starting to become a waste of time joke!
> Where are all of the MS people that touted RS 2005 - CAN WE HAVE SOME
> ANSWERS - or to busy at trade shows?
>
> "D1p4k" wrote:
>> The Report Server service is failing, almost on a daily basis.
>> Description:
>> The ReportServer service terminated unexpectedly. It has done this 39
>> time(s). The following corrective action will be taken in 60000
>> milliseconds: Restart the service.
>> Sometimes the service is unable to restart and I get the following error.
>> Timeout (30000 milliseconds) waiting for the ReportServer service to
>> connect.
>> Then I get ..
>> The ReportServer service failed to start due to the following error:
>> The service did not respond to the start or control request in a timely
>> fashion.
>> Google returns nothing on how to troublshoot this problem,
>> Can someone please point me in the right direction on how to resolve
>> this.
>> Your Help is much Apprieciated.|||Bruce, Just to clarify. The NT Service is failing.
The EventLog is being logged with the following error.
The ReportServer service terminated unexpectedly. It has done this 39
time(s). The following corrective action will be taken in 60000
milliseconds: Restart the service.
Please note 39 in the number of times it was failed.
I would like to understand the general steps involved in the resolution of
this problem.
Hope you can help !
"Bruce L-C [MVP]" wrote:
> Since MS started the web based forums that is where all the Microsoft people
> are. I suggest taking one by one your issues and asking there. I haven't see
> the issues but that is at least partly due to the fact I am not doing much
> with graphs (reading your posts it seems like a lot has to do with that).
> Same could be with VS. I never see it hang. Ever.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "code_slayer_bkk" <codeslayerbkk@.discussions.microsoft.com> wrote in message
> news:282A44D1-C5CA-4EA4-8302-535800E17D8C@.microsoft.com...
> >I have the same problem and it is not memory or dasd on the server!
> >
> > Not only that Visual Studio - hangs all the time in 2005 --
> >
> > Reports that work perfectly - then migrated to 2005 do not work the same !
> >
> > This is starting to become a waste of time joke!
> >
> > Where are all of the MS people that touted RS 2005 - CAN WE HAVE SOME
> > ANSWERS - or to busy at trade shows?
> >
> >
> >
> > "D1p4k" wrote:
> >
> >> The Report Server service is failing, almost on a daily basis.
> >>
> >> Description:
> >> The ReportServer service terminated unexpectedly. It has done this 39
> >> time(s). The following corrective action will be taken in 60000
> >> milliseconds: Restart the service.
> >>
> >> Sometimes the service is unable to restart and I get the following error.
> >> Timeout (30000 milliseconds) waiting for the ReportServer service to
> >> connect.
> >>
> >> Then I get ..
> >> The ReportServer service failed to start due to the following error:
> >> The service did not respond to the start or control request in a timely
> >> fashion.
> >>
> >> Google returns nothing on how to troublshoot this problem,
> >>
> >> Can someone please point me in the right direction on how to resolve
> >> this.
> >>
> >> Your Help is much Apprieciated.
>
>|||Nor me. Till now no problem with both VS and reporting services. Hey Just
because of this you cant call MS and that's why DF is provided and still you
dont get any solutions, you can always log a call with MS.
Coming to your problem, why dont you install your patch again or may be try
to see what you have installed recently in your NT.there may be a clash with
SSRS. If possible, you read it right "If Possible". try installing SSRS again.
Amarnath.
"Bruce L-C [MVP]" wrote:
> Since MS started the web based forums that is where all the Microsoft people
> are. I suggest taking one by one your issues and asking there. I haven't see
> the issues but that is at least partly due to the fact I am not doing much
> with graphs (reading your posts it seems like a lot has to do with that).
> Same could be with VS. I never see it hang. Ever.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "code_slayer_bkk" <codeslayerbkk@.discussions.microsoft.com> wrote in message
> news:282A44D1-C5CA-4EA4-8302-535800E17D8C@.microsoft.com...
> >I have the same problem and it is not memory or dasd on the server!
> >
> > Not only that Visual Studio - hangs all the time in 2005 --
> >
> > Reports that work perfectly - then migrated to 2005 do not work the same !
> >
> > This is starting to become a waste of time joke!
> >
> > Where are all of the MS people that touted RS 2005 - CAN WE HAVE SOME
> > ANSWERS - or to busy at trade shows?
> >
> >
> >
> > "D1p4k" wrote:
> >
> >> The Report Server service is failing, almost on a daily basis.
> >>
> >> Description:
> >> The ReportServer service terminated unexpectedly. It has done this 39
> >> time(s). The following corrective action will be taken in 60000
> >> milliseconds: Restart the service.
> >>
> >> Sometimes the service is unable to restart and I get the following error.
> >> Timeout (30000 milliseconds) waiting for the ReportServer service to
> >> connect.
> >>
> >> Then I get ..
> >> The ReportServer service failed to start due to the following error:
> >> The service did not respond to the start or control request in a timely
> >> fashion.
> >>
> >> Google returns nothing on how to troublshoot this problem,
> >>
> >> Can someone please point me in the right direction on how to resolve
> >> this.
> >>
> >> Your Help is much Apprieciated.
>
>

ReportServer Service stopping

I have the ReportServer service set to automatic, but on a daily basis it
seems to stop. This causes my report subscriptions to not fire. My log file
ends with the following:
aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-17:42:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-17:52:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-18:02:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!925d4!5/25/2005-18:12:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-18:22:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-18:32:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-18:42:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-18:52:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-19:02:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-19:12:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-19:22:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-19:32:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!925d4!5/25/2005-19:42:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-19:52:52:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!8b1bc!5/25/2005-20:02:52:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!925d4!5/25/2005-20:12:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!library!87b78!5/25/2005-20:22:53:: i INFO: Cleaned 0 batch
records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
running jobs
aspnet_wp!webserver!925d4!5/25/2005-20:24:17:: i INFO: Reporting Web Server
stopped
Any help is appreciated.
--
---
Yes, I searched first :)This is the web service log file and has no effect on subscriptions. You
should look at the reportserverservice_<datetime>.log file to see why the
service is stopping.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
news:4F34A986-C0B6-476A-A591-F96AFA27871F@.microsoft.com...
>I have the ReportServer service set to automatic, but on a daily basis it
> seems to stop. This causes my report subscriptions to not fire. My log
> file
> ends with the following:
> aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-17:42:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-17:52:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-18:02:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!925d4!5/25/2005-18:12:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-18:22:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-18:32:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-18:42:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-18:52:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-19:02:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-19:12:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-19:22:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-19:32:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!925d4!5/25/2005-19:42:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-19:52:52:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!8b1bc!5/25/2005-20:02:52:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!925d4!5/25/2005-20:12:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!library!87b78!5/25/2005-20:22:53:: i INFO: Cleaned 0 batch
> records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> running jobs
> aspnet_wp!webserver!925d4!5/25/2005-20:24:17:: i INFO: Reporting Web
> Server
> stopped
> Any help is appreciated.
>
> --
> ---
> Yes, I searched first :)|||Your right, here is the right log file, i think.
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__05_25_2005_00_04_07.log</Path>
<SystemName>FINC01</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!library!87ad8!5/25/2005-00:04:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a7c!5/25/2005-00:14:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-00:24:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!91f2c!5/25/2005-00:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a84!5/25/2005-00:44:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87ad8!5/25/2005-00:54:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a88!5/25/2005-01:04:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!91e00!5/25/2005-01:14:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a70!5/25/2005-01:24:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!8b3d4!5/25/2005-01:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-01:44:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87b3c!5/25/2005-01:54:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
Expiring old execution log entries
ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
Expiration of old execution log entries is complete. Removed 333 entries.
ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
Cleaned 0 broken snapshots, 0 chunks
ReportingServicesService!runningjobs!922c8!5/25/2005-01:59:58:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 86401 seconds
ReportingServicesService!library!928a0!5/25/2005-02:04:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!9225c!5/25/2005-02:14:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-02:24:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a70!5/25/2005-02:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87abc!5/25/2005-02:44:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-02:54:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!91e78!5/25/2005-03:04:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a88!5/25/2005-03:14:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a4c!5/25/2005-03:24:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a70!5/25/2005-03:34:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a4c!5/25/2005-03:44:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a70!5/25/2005-03:54:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-04:04:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87ab8!5/25/2005-04:14:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!928a0!5/25/2005-04:24:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!928a0!5/25/2005-04:34:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87ad8!5/25/2005-04:44:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87abc!5/25/2005-04:54:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a84!5/25/2005-05:04:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922c8!5/25/2005-05:14:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!92288!5/25/2005-05:24:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!91f2c!5/25/2005-05:34:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!921c0!5/25/2005-05:44:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922ec!5/25/2005-05:54:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!92684!5/25/2005-06:04:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a6c!5/25/2005-06:14:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a40!5/25/2005-06:24:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!8713c!5/25/2005-06:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!ba4!5/25/2005-06:44:06:: i INFO: Cleaned 0
batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!922ec!5/25/2005-06:54:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!87a7c!5/25/2005-07:04:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!92454!5/25/2005-07:14:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!library!92510!5/25/2005-07:24:06:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
processing item bf3cd500-c643-4e1e-a361-393feb7bd186
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
processing item 086b53d0-4731-4880-9d56-0ff48ebf487b
ReportingServicesService!schedule!92510!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
finished processing item bf3cd500-c643-4e1e-a361-393feb7bd186
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
finished processing item 086b53d0-4731-4880-9d56-0ff48ebf487b
ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
processing item 1693d373-4b84-4579-a5b6-d0c043a6a514
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
processing item 7bdd7502-38bb-4bce-9359-ece8dd584da4
ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
processing 2 more items. 2 Total items in internal queue.
ReportingServicesService!schedule!92510!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
finished processing item 1693d373-4b84-4579-a5b6-d0c043a6a514
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
finished processing item 7bdd7502-38bb-4bce-9359-ece8dd584da4
ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
processing 1 more items. 1 Total items in internal queue.
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
processing item a50aa298-495f-4aa3-bd15-33b73f6e21e3
ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
event schedule fired that does not exists in the report server database
ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
finished processing item a50aa298-495f-4aa3-bd15-33b73f6e21e3
ReportingServicesService!library!8d1ec!5/25/2005-07:34:07:: i INFO: Cleaned
0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
chunks, 0 running jobs
I don't see any clues here? The only thing i know is the service stops
itself.
--
---
Yes, I searched first :)
"Daniel Reib (MSFT)" wrote:
> This is the web service log file and has no effect on subscriptions. You
> should look at the reportserverservice_<datetime>.log file to see why the
> service is stopping.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
> news:4F34A986-C0B6-476A-A591-F96AFA27871F@.microsoft.com...
> >I have the ReportServer service set to automatic, but on a daily basis it
> > seems to stop. This causes my report subscriptions to not fire. My log
> > file
> > ends with the following:
> > aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-17:42:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-17:52:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-18:02:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!925d4!5/25/2005-18:12:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-18:22:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-18:32:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-18:42:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-18:52:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-19:02:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-19:12:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-19:22:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-19:32:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!925d4!5/25/2005-19:42:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-19:52:52:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!8b1bc!5/25/2005-20:02:52:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!925d4!5/25/2005-20:12:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!library!87b78!5/25/2005-20:22:53:: i INFO: Cleaned 0 batch
> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0
> > running jobs
> > aspnet_wp!webserver!925d4!5/25/2005-20:24:17:: i INFO: Reporting Web
> > Server
> > stopped
> >
> > Any help is appreciated.
> >
> >
> > --
> > ---
> > Yes, I searched first :)
>
>|||Running Anti-Virus (and who wouldn't right?) on the server? There was an
issue with AV software causing re-starts of the service, not sure if it's
been fixed or not. Might want to consider excluding the RS directories from
AV scans.
"Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
news:BB72CE5D-837E-4856-B1E4-145B2E08C8C7@.microsoft.com...
> Your right, here is the right log file, i think.
>
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Eastern Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__05_25_2005_00_04_07.log</Path>
> <SystemName>FINC01</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> ReportingServicesService!library!87ad8!5/25/2005-00:04:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a7c!5/25/2005-00:14:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-00:24:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!91f2c!5/25/2005-00:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a84!5/25/2005-00:44:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87ad8!5/25/2005-00:54:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a88!5/25/2005-01:04:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!91e00!5/25/2005-01:14:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a70!5/25/2005-01:24:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!8b3d4!5/25/2005-01:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-01:44:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87b3c!5/25/2005-01:54:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
> Expiring old execution log entries
> ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
> Expiration of old execution log entries is complete. Removed 333 entries.
> ReportingServicesService!dbcleanup!922c8!5/25/2005-01:59:58:: i INFO:
> Cleaned 0 broken snapshots, 0 chunks
> ReportingServicesService!runningjobs!922c8!5/25/2005-01:59:58:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 86401 seconds
> ReportingServicesService!library!928a0!5/25/2005-02:04:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!9225c!5/25/2005-02:14:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-02:24:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a70!5/25/2005-02:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87abc!5/25/2005-02:44:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-02:54:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!91e78!5/25/2005-03:04:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a88!5/25/2005-03:14:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a4c!5/25/2005-03:24:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a70!5/25/2005-03:34:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a4c!5/25/2005-03:44:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a70!5/25/2005-03:54:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-04:04:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87ab8!5/25/2005-04:14:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!928a0!5/25/2005-04:24:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!928a0!5/25/2005-04:34:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87ad8!5/25/2005-04:44:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87abc!5/25/2005-04:54:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a84!5/25/2005-05:04:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922c8!5/25/2005-05:14:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!92288!5/25/2005-05:24:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!91f2c!5/25/2005-05:34:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!921c0!5/25/2005-05:44:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922ec!5/25/2005-05:54:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!92684!5/25/2005-06:04:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a6c!5/25/2005-06:14:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a40!5/25/2005-06:24:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!8713c!5/25/2005-06:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!ba4!5/25/2005-06:44:06:: i INFO: Cleaned
> 0
> batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!922ec!5/25/2005-06:54:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!87a7c!5/25/2005-07:04:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!92454!5/25/2005-07:14:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!library!92510!5/25/2005-07:24:06:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
> ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
> processing 2 more items. 2 Total items in internal queue.
> ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
> processing item bf3cd500-c643-4e1e-a361-393feb7bd186
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> processing item 086b53d0-4731-4880-9d56-0ff48ebf487b
> ReportingServicesService!schedule!92510!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
> finished processing item bf3cd500-c643-4e1e-a361-393feb7bd186
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> finished processing item 086b53d0-4731-4880-9d56-0ff48ebf487b
> ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
> processing item 1693d373-4b84-4579-a5b6-d0c043a6a514
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> processing item 7bdd7502-38bb-4bce-9359-ece8dd584da4
> ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
> processing 2 more items. 2 Total items in internal queue.
> ReportingServicesService!schedule!92510!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!dbpolling!92510!5/25/2005-07:25:06:: EventPolling
> finished processing item 1693d373-4b84-4579-a5b6-d0c043a6a514
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> finished processing item 7bdd7502-38bb-4bce-9359-ece8dd584da4
> ReportingServicesService!dbpolling!c68!5/25/2005-07:25:06:: EventPolling
> processing 1 more items. 1 Total items in internal queue.
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> processing item a50aa298-495f-4aa3-bd15-33b73f6e21e3
> ReportingServicesService!schedule!921d8!5/25/2005-07:25:06:: w WARN: An
> event schedule fired that does not exists in the report server database
> ReportingServicesService!dbpolling!921d8!5/25/2005-07:25:06:: EventPolling
> finished processing item a50aa298-495f-4aa3-bd15-33b73f6e21e3
> ReportingServicesService!library!8d1ec!5/25/2005-07:34:07:: i INFO:
> Cleaned
> 0 batch records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
> chunks, 0 running jobs
>
> I don't see any clues here? The only thing i know is the service stops
> itself.
> --
> ---
> Yes, I searched first :)
>
> "Daniel Reib (MSFT)" wrote:
>> This is the web service log file and has no effect on subscriptions. You
>> should look at the reportserverservice_<datetime>.log file to see why the
>> service is stopping.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "Kmistic" <Kmistic@.discussions.microsoft.com> wrote in message
>> news:4F34A986-C0B6-476A-A591-F96AFA27871F@.microsoft.com...
>> >I have the ReportServer service set to automatic, but on a daily basis
>> >it
>> > seems to stop. This causes my report subscriptions to not fire. My log
>> > file
>> > ends with the following:
>> > aspnet_wp!library!925d4!5/25/2005-17:32:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-17:42:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-17:52:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 1 snapshots, 5
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-18:02:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!925d4!5/25/2005-18:12:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-18:22:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-18:32:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-18:42:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-18:52:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-19:02:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-19:12:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-19:22:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-19:32:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!925d4!5/25/2005-19:42:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-19:52:52:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!8b1bc!5/25/2005-20:02:52:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!925d4!5/25/2005-20:12:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!library!87b78!5/25/2005-20:22:53:: i INFO: Cleaned 0 batch
>> > records, 0 policies, 0 sessions, 0 cache entries, 0 snapshots, 0
>> > chunks, 0
>> > running jobs
>> > aspnet_wp!webserver!925d4!5/25/2005-20:24:17:: i INFO: Reporting Web
>> > Server
>> > stopped
>> >
>> > Any help is appreciated.
>> >
>> >
>> > --
>> > ---
>> > Yes, I searched first :)
>>

ReportServer Service Issue

We have multiple reports that are rendered in pdf format and delivered using
the email extension. We have started experiencing a rendering error that
stops the reports form rendering/delivery and only seems to be fixed after
restarting the ReportServer service. Could this be a timing issue? We have
multiple reports kicking off at the same time that render in pdf format. Any
help would be greatly appreciated.
Thanks,
SteveThe first thing to do is to go to the Logs for Report Server, generally under
MSSQL.3 directory of your install... Look there for clues...
Wayne Snyder MCDBA, SQL Server MVP
Mariner, Charlotte, NC
I support the Professional Association for SQL Server ( PASS) and it''s
community of SQL Professionals.
"Steve Bennett" wrote:
> We have multiple reports that are rendered in pdf format and delivered using
> the email extension. We have started experiencing a rendering error that
> stops the reports form rendering/delivery and only seems to be fixed after
> restarting the ReportServer service. Could this be a timing issue? We have
> multiple reports kicking off at the same time that render in pdf format. Any
> help would be greatly appreciated.
> Thanks,
> Steve
>
>|||This is the first exception in the log file, a generic GDI+ error and then
it cascades from there...
ReportingServicesService!reportrendering!524!01/30/2006-04:00:13:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Runtime.InteropServices.ExternalException: A generic
error occurred in GDI+.
at System.Drawing.Graphics.MeasureString(String text, Font font, SizeF
layoutArea, StringFormat stringFormat)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasFont.LineHeight(Graphics
graphics, SizeF maxSizeF)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasBase.LineHeight(CanvasFont
font)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.CalculateItemMeasurement(Orientation
orientation)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItem.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!524!01/30/2006-04:00:13:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!notification!524!01/30/2006-04:00:13:: Notification
4a595bbc-4073-48ac-ac3c-e39b1aa50018 completed. Success: False, Status:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Printer Delivery Sample, Report: TMP
ExceptionConformance Report, Attempt 1
ReportingServicesService!dbpolling!524!01/30/2006-04:00:13::
NotificationPolling finished processing item
4a595bbc-4073-48ac-ac3c-e39b1aa50018
ReportingServicesService!reportrendering!1210!01/30/2006-04:00:18:: e ERROR:
Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. -->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --> System.Runtime.InteropServices.ExternalException: A generic
error occurred in GDI+.
at System.Drawing.Graphics.MeasureString(String text, Font font, SizeF
layoutArea, StringFormat stringFormat)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasFont.LineHeight(Graphics
graphics, SizeF maxSizeF)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.CanvasBase.LineHeight(CanvasFont
font)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.TextBox.CalculateItemMeasurement(Orientation
orientation)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItem.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.RenderingItemContainer.CalculatePage(Orientation
orientation, Boolean repeatableParent, Boolean canDelete, Double&
minimumCoordinate, Double& distance)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.ProcessPages(CompositionBase
theComposition, Report theReport, Boolean needTotalPages, Int32 startPage,
Int32 endPage, Boolean render)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport.RenderReport(Report
report, NameValueCollection deviceInfo, EvaluateHeaderFooterExpressions
evaluateHeaderFooterExpressions, CreateAndRegisterStream
createAndRegisterStreamCallback)
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
-- End of inner exception stack trace --
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime
A_0, GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
-- End of inner exception stack trace --
ReportingServicesService!library!1210!01/30/2006-04:00:18:: i INFO:
Initializing EnableExecutionLogging to 'True' as specified in Server system
properties.
ReportingServicesService!notification!1210!01/30/2006-04:00:18::
Notification d1ffd955-b678-4a68-83d2-dddfffa5fe9e completed. Success:
False, Status: Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., DeliveryExtension: Printer Delivery Sample, Report: GWD
ExceptionConformance Report, Attempt 1
Sorry, the first reply went to the wrong message...
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:687E1061-75DB-400E-BB7A-5975FE043A9B@.microsoft.com...
> The first thing to do is to go to the Logs for Report Server, generally
> under
> MSSQL.3 directory of your install... Look there for clues...
>
> --
> Wayne Snyder MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> I support the Professional Association for SQL Server ( PASS) and it''s
> community of SQL Professionals.
>
> "Steve Bennett" wrote:
>> We have multiple reports that are rendered in pdf format and delivered
>> using
>> the email extension. We have started experiencing a rendering error that
>> stops the reports form rendering/delivery and only seems to be fixed
>> after
>> restarting the ReportServer service. Could this be a timing issue? We
>> have
>> multiple reports kicking off at the same time that render in pdf format.
>> Any
>> help would be greatly appreciated.
>> Thanks,
>> Steve
>>

ReportServer Service Is Filling Up Log Files

I saw this header from back in April, but it has since been expired from
Microsoft's news server. Anywho, for some reason, my trace log file for the
ReportingServices Service is filling up at about 1 Mb per minute. I have dropped
the trace level down to 2 for now, but this does not fix the core issue. It
seems that the "Execution Log Entry Expiration" task, or whatever it is, is
running and will not stop, thus generating tons of trace log entries. Can
somebody please help with this?
Here is the warning message:
ReportingServicesService!runningjobs!22c8!6/22/2005-09:15:09:: w WARN: Previous
request for Execution Log Entry Expirationstill executing, skipping...
Here is the info message:
ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO: Expiring
old execution log entries
ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO: Expiration
of old execution log entries is complete. Removed 0 entries.
ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO: Cleaned 0
broken snapshots, 0 chunks
ReportingServicesService!runningjobs!1a4c!6/22/2005-10:06:03:: i INFO: Execution
Log Entry Expiration timer enabled: Cycle: 57236 seconds
Also, is there any way to change the location of the trace log files?This is fixed in SP2. There's also a hotfix available if you need to stay on
SP1 for some reason. What I used to do is just have a scheduled task that
ran a vbscript to delete the older log files if the size of the log folder >
300 MB
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Darrell" <Darrell.Wright.nospam@.okc.gov> wrote in message
news:u7aJg5zdFHA.688@.TK2MSFTNGP14.phx.gbl...
>I saw this header from back in April, but it has since been expired from
>Microsoft's news server. Anywho, for some reason, my trace log file for the
>ReportingServices Service is filling up at about 1 Mb per minute. I have
>dropped the trace level down to 2 for now, but this does not fix the core
>issue. It seems that the "Execution Log Entry Expiration" task, or whatever
>it is, is running and will not stop, thus generating tons of trace log
>entries. Can somebody please help with this?
> Here is the warning message:
> ReportingServicesService!runningjobs!22c8!6/22/2005-09:15:09:: w WARN:
> Previous request for Execution Log Entry Expirationstill executing,
> skipping...
> Here is the info message:
> ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO:
> Expiring old execution log entries
> ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO:
> Expiration of old execution log entries is complete. Removed 0 entries.
> ReportingServicesService!dbcleanup!1a4c!6/22/2005-10:06:03:: i INFO:
> Cleaned 0 broken snapshots, 0 chunks
> ReportingServicesService!runningjobs!1a4c!6/22/2005-10:06:03:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 57236 seconds
> Also, is there any way to change the location of the trace log files?

ReportServer Service bringing down my DB !!!

hi,

I have reporting service 2000 . it has started to make queries to database (my datasource), those queries are NOT my report server queries ..i do not know why its querying database for no reason :-(

any idea ? please help,

-blue

well..i fixed it...someone had created subscription with duration of 5 minutes ...it was creating major performance problems ..

fixed it