Showing posts with label log. Show all posts
Showing posts with label log. Show all posts

Friday, March 23, 2012

ReportServerTempDB log full regularly

My ReportServerTempDB is full regularly .I had to shirink the database on regular interval though i schedule for shirinking on 30 minutes.But as soon there is any exception due to scripting the log is full and my all report manaer throws error.

After shirinking the ReportServerTempDB the reports starts working fine.

Please Help me to remove this frequent error.

It's more than likely the chunkdata table. That table stores the session cache and cached instances of your reports. The information is stored in an intermediary format (pre-rendering) which means that it contains data, too.

Each time a report is run with a different query parameter, a new cached instance is created. That can add up and quickly grow your ReportServerTempDb database.

One technique to minimize this is to create a rather generic query that returns a superset of the data needed so that only one copy of the report is cached. You can then apply filters to that cached instance.

You can also adjust the cache expiration policies.

There's good document on SSRS scalability here.
download.microsoft.com/download/1/3/4/134644fd-05ad-4ee8-8b5a-0aed1c18a31e/rs_scalability.doc

HTH...

Joe

ReportServerTempDB log full regularly

My ReportServerTempDB is full regularly .I had to shirink the database on regular interval though i schedule for shirinking on 30 minutes.But as soon there is any exception due to scripting the log is full and my all report manaer throws error.

After shirinking the ReportServerTempDB the reports starts working fine.

Please Help me to remove this frequent error.

It's more than likely the chunkdata table. That table stores the session cache and cached instances of your reports. The information is stored in an intermediary format (pre-rendering) which means that it contains data, too.

Each time a report is run with a different query parameter, a new cached instance is created. That can add up and quickly grow your ReportServerTempDb database.

One technique to minimize this is to create a rather generic query that returns a superset of the data needed so that only one copy of the report is cached. You can then apply filters to that cached instance.

You can also adjust the cache expiration policies.

There's good document on SSRS scalability here.
download.microsoft.com/download/1/3/4/134644fd-05ad-4ee8-8b5a-0aed1c18a31e/rs_scalability.doc

HTH...

Joe

ReportServerTempDB cannot unexpected log file growth

Hi,
ReportServerTempDB db log file cannot be shrunk. I'm not sure how, but in
sys.databases, the log_reuse_wait_desc field contains REPLICATION for both
the ReportServer and ReportServerTempDB records. I believe this should read
Nothing. I believe this may be our problem. Has anyone seen this or have any
suggestions.
Thanks!I ended up finding a workaround. Re-enabled the database for replication,
added a publication, then drop the publication, and remove replication.
Still don't know what may have caused this to happen.
"clutch" wrote:
> Hi,
> ReportServerTempDB db log file cannot be shrunk. I'm not sure how, but in
> sys.databases, the log_reuse_wait_desc field contains REPLICATION for both
> the ReportServer and ReportServerTempDB records. I believe this should read
> Nothing. I believe this may be our problem. Has anyone seen this or have any
> suggestions.
> Thanks!

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 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?

Wednesday, March 21, 2012

ReportServer - http://localhost/ReportServer - Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

And my ReportServer log:

<Header>

<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>

<Locale>en-US</Locale>

<TimeZone>Pacific Standard Time</TimeZone>

<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__03_24_2006_16_45_06.log</Path>

<SystemName>USPROFILING</SystemName>

<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>

<OSVersion>5.2.3790.65536</OSVersion>

</Header>

w3wp!webserver!1!3/24/2006-16:45:06:: i INFO: Reporting Web Server started

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing ConnectionType to '1'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsSchedulingService to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsNotificationService to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsEventService to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsWebServiceEnabled to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing ProcessRecycleOptions to '0'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonFlags to '1064'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing SecureConnectionLevel to '0'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DisplayErrorLink to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'as specified in Configuration file.

w3wp!resourceutilities!1!3/24/2006-16:45:06:: i INFO: Reporting Services starting SKU: Enterprise

w3wp!resourceutilities!1!3/24/2006-16:45:06:: i INFO: Evaluation copy: 0 days left

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds.Cycle: 600 seconds

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.Cycle: 60 seconds

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.Cycle: 60 seconds

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.Cycle: 60 seconds

w3wp!library!1!03/24/2006-16:45:06:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()

at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()

at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()

at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)

End of inner exception stack trace

w3wp!library!1!03/24/2006-16:45:09:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson

w3wp!library!1!03/24/2006-16:45:11:: i INFO: Catalog SQL Server Edition = Enterprise

w3wp!library!1!03/24/2006-16:45:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()

at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()

at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)

End of inner exception stack trace

w3wp!library!1!03/24/2006-16:45:14:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson

Any help would be appreciated:

System 2003 Server IIS6 and Sql2005 enterprise all housed on Virtual Server. all housed locally.

Check whether your ReportServer\web.config file has an XML namespace in it. SRS doesn't expect one to be present, but some tools from VS2005 web projects will add one in some cases.

If there is a namespace present, you can safely remove it.

Hope that helps,

Tudor

|||

Thanks here is my webconfig file:

<?xml version="1.0" encoding="utf-8" ?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<configSections>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics" />
</configSections>
<system.diagnostics>
<switches>
<!-- 1 = error, 2 = warning, 3 = info, 4 = verbose -->
<add name="DefaultTraceSwitch" value="3" />
</switches>
<assert assertuienabled="false" />
</system.diagnostics>
<RStrace>
<add name="FileName" value="ReportServer_" />
<add name="FileSizeLimitMb" value="32" />
<add name="KeepFilesForDays" value="14" />
<add name="Prefix" value="tid, time" />
<add name="TraceListeners" value="debugwindow, file" />
<add name="TraceFileMode" value="unique" />
<add name="Components" value="all,RunningJobs:3,SemanticQueryEngine:2,SemanticModelGenerator:2" />
</RStrace>
<system.web>
<customErrors mode="On" defaultRedirect="http://usprofiling/ReportCustomErrorPage.htm" />
<pages validateRequest="false" />
<authentication mode="Windows" />
<identity userName="" password="" impersonate="true" />
<compilation defaultLanguage="c#" debug="false">
<assemblies>
<clear />
<add assembly="ReportingServicesWebServer" />
</assemblies>
</compilation>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<sessionState mode="Off" />
<httpHandlers>
<add verb="*" path="Reserved.ReportServer" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" />
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</httpHandlers>
<httpModules></httpModules>
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
<httpRuntime executionTimeout="9000" />
<securityPolicy>
<trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
</securityPolicy>
<trust level="RosettaSrv" originUrl="" />


</system.web>
<runtime>
<legacyImpersonationPolicy enabled="true"/>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces"
publicKeyToken="89845dcd8080cc91"
culture="neutral" />
<bindingRedirect oldVersion="8.0.242.0"
newVersion="9.0.242.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>

Ant this has been working for the past month suddenly stopped. I removed the xmlns per request and it works now, so when using vs2005 it adds this tag?

|||

Hi,

I have the same problem and deleted the xmlns in the web.config:

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

But then another error happens: rsServerConfigurationError. The log indicates the following:

aspnet_wp!library!1!12/07/2006-10:06:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details., Could not load Authorization extension;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!07/12/2006-10:07:40:: i INFO: Catalog SQL Server Edition = Developer
aspnet_wp!library!1!12/07/2006-10:08:47:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details., Could not load Authorization extension;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details.

Any idea? Help will be much appreciated, thanks a lot! :)

|||

Look in the ReportManager\web.config and ReportServer\web.config files, you should have the authentication mode set to "Windows".

<system.web>

<pages validateRequest="false" />

<authentication mode="Windows" />

<identity impersonate="true" />

This should be enough to solve your problem.

Greets.

|||Thanks, that was the solution for me!|||

.. so close to resolving my problem - but I'm still getting error 'Object reference not set to an instance of an object'.

I have checked out all of the above - but my Reporting Manager is still not my friend - anymore. Something must have happened ...

Subscribtions from Reporting Manager are still working, when I'm sending file (pdf e.g.)

Web.config is on both RepMan and RepServ =

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>

--

<system.web>
<pages validateRequest="false" />
<authentication mode="Windows" />
<identity impersonate="true" />
<compilation defaultLanguage="c#" debug="false">
<assemblies>
<clear />

SQL server 2005 is installed on MS server 2003 Stand ed., SP1

Is there any good souls who can help me find a solution to this problem?

ReportServer - http://localhost/ReportServer - Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

Object reference not set to an instance of an object.

And my ReportServer log:

<Header>

<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>

<Locale>en-US</Locale>

<TimeZone>Pacific Standard Time</TimeZone>

<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__03_24_2006_16_45_06.log</Path>

<SystemName>USPROFILING</SystemName>

<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>

<OSVersion>5.2.3790.65536</OSVersion>

</Header>

w3wp!webserver!1!3/24/2006-16:45:06:: i INFO: Reporting Web Server started

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing ConnectionType to '1'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsSchedulingService to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsNotificationService to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsEventService to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsWebServiceEnabled to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing ProcessRecycleOptions to '0'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonFlags to '1064'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing SecureConnectionLevel to '0'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DisplayErrorLink to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'as specified in Configuration file.

w3wp!resourceutilities!1!3/24/2006-16:45:06:: i INFO: Reporting Services starting SKU: Enterprise

w3wp!resourceutilities!1!3/24/2006-16:45:06:: i INFO: Evaluation copy: 0 days left

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds.Cycle: 600 seconds

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.Cycle: 60 seconds

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.Cycle: 60 seconds

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.Cycle: 60 seconds

w3wp!library!1!03/24/2006-16:45:06:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()

at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()

at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()

at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)

End of inner exception stack trace

w3wp!library!1!03/24/2006-16:45:09:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson

w3wp!library!1!03/24/2006-16:45:11:: i INFO: Catalog SQL Server Edition = Enterprise

w3wp!library!1!03/24/2006-16:45:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()

at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()

at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)

End of inner exception stack trace

w3wp!library!1!03/24/2006-16:45:14:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson

Any help would be appreciated:

System 2003 Server IIS6 and Sql2005 enterprise all housed on Virtual Server. all housed locally.

Check whether your ReportServer\web.config file has an XML namespace in it. SRS doesn't expect one to be present, but some tools from VS2005 web projects will add one in some cases.

If there is a namespace present, you can safely remove it.

Hope that helps,

Tudor

|||

Thanks here is my webconfig file:

<?xml version="1.0" encoding="utf-8" ?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<configSections>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics" />
</configSections>
<system.diagnostics>
<switches>
<!-- 1 = error, 2 = warning, 3 = info, 4 = verbose -->
<add name="DefaultTraceSwitch" value="3" />
</switches>
<assert assertuienabled="false" />
</system.diagnostics>
<RStrace>
<add name="FileName" value="ReportServer_" />
<add name="FileSizeLimitMb" value="32" />
<add name="KeepFilesForDays" value="14" />
<add name="Prefix" value="tid, time" />
<add name="TraceListeners" value="debugwindow, file" />
<add name="TraceFileMode" value="unique" />
<add name="Components" value="all,RunningJobs:3,SemanticQueryEngine:2,SemanticModelGenerator:2" />
</RStrace>
<system.web>
<customErrors mode="On" defaultRedirect="http://usprofiling/ReportCustomErrorPage.htm" />
<pages validateRequest="false" />
<authentication mode="Windows" />
<identity userName="" password="" impersonate="true" />
<compilation defaultLanguage="c#" debug="false">
<assemblies>
<clear />
<add assembly="ReportingServicesWebServer" />
</assemblies>
</compilation>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<sessionState mode="Off" />
<httpHandlers>
<add verb="*" path="Reserved.ReportServer" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" />
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</httpHandlers>
<httpModules></httpModules>
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
<httpRuntime executionTimeout="9000" />
<securityPolicy>
<trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
</securityPolicy>
<trust level="RosettaSrv" originUrl="" />


</system.web>
<runtime>
<legacyImpersonationPolicy enabled="true"/>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces"
publicKeyToken="89845dcd8080cc91"
culture="neutral" />
<bindingRedirect oldVersion="8.0.242.0"
newVersion="9.0.242.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>

Ant this has been working for the past month suddenly stopped. I removed the xmlns per request and it works now, so when using vs2005 it adds this tag?

|||

Hi,

I have the same problem and deleted the xmlns in the web.config:

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

But then another error happens: rsServerConfigurationError. The log indicates the following:

aspnet_wp!library!1!12/07/2006-10:06:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details., Could not load Authorization extension;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!07/12/2006-10:07:40:: i INFO: Catalog SQL Server Edition = Developer
aspnet_wp!library!1!12/07/2006-10:08:47:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details., Could not load Authorization extension;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details.

Any idea? Help will be much appreciated, thanks a lot! :)

|||

Look in the ReportManager\web.config and ReportServer\web.config files, you should have the authentication mode set to "Windows".

<system.web>

<pages validateRequest="false" />

<authentication mode="Windows" />

<identity impersonate="true" />

This should be enough to solve your problem.

Greets.

|||Thanks, that was the solution for me!|||

.. so close to resolving my problem - but I'm still getting error 'Object reference not set to an instance of an object'.

I have checked out all of the above - but my Reporting Manager is still not my friend - anymore. Something must have happened ...

Subscribtions from Reporting Manager are still working, when I'm sending file (pdf e.g.)

Web.config is on both RepMan and RepServ =

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>

--

<system.web>
<pages validateRequest="false" />
<authentication mode="Windows" />
<identity impersonate="true" />
<compilation defaultLanguage="c#" debug="false">
<assemblies>
<clear />

SQL server 2005 is installed on MS server 2003 Stand ed., SP1

Is there any good souls who can help me find a solution to this problem?

ReportServer - http://localhost/ReportServer - Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help Object reference not set to an instance of an object.

And my ReportServer log:

<Header>

<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>

<Locale>en-US</Locale>

<TimeZone>Pacific Standard Time</TimeZone>

<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServer__03_24_2006_16_45_06.log</Path>

<SystemName>USPROFILING</SystemName>

<OSName>Microsoft Windows NT 5.2.3790 Service Pack 1</OSName>

<OSVersion>5.2.3790.65536</OSVersion>

</Header>

w3wp!webserver!1!3/24/2006-16:45:06:: i INFO: Reporting Web Server started

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing ConnectionType to '1'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsSchedulingService to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsNotificationService to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsEventService to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing IsWebServiceEnabled to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing ProcessRecycleOptions to '0'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonFlags to '1064'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing SecureConnectionLevel to '0'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing DisplayErrorLink to 'True'as specified in Configuration file.

w3wp!library!1!3/24/2006-16:45:06:: i INFO: Initializing WebServiceUseFileShareStorage to 'False'as specified in Configuration file.

w3wp!resourceutilities!1!3/24/2006-16:45:06:: i INFO: Reporting Services starting SKU: Enterprise

w3wp!resourceutilities!1!3/24/2006-16:45:06:: i INFO: Evaluation copy: 0 days left

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Database Cleanup (Web Service) timer enabled: Next Event: 600 seconds.Cycle: 600 seconds

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds.Cycle: 60 seconds

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds.Cycle: 60 seconds

w3wp!runningjobs!1!3/24/2006-16:45:06:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds.Cycle: 60 seconds

w3wp!library!1!03/24/2006-16:45:06:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()

at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()

at Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()

at Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object sender, EventArgs e)

End of inner exception stack trace

w3wp!library!1!03/24/2006-16:45:09:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson

w3wp!library!1!03/24/2006-16:45:11:: i INFO: Catalog SQL Server Edition = Enterprise

w3wp!library!1!03/24/2006-16:45:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details., ;

Info: Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException: An internal error occurred on the report server. See the error log for more details. > System.NullReferenceException: Object reference not set to an instance of an object.

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetWebConfigAuthenticationAttribute(String attrName)

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.GetAuthenticationType()

at Microsoft.ReportingServices.Diagnostics.WebConfigUtil.get_UsingWindowsAuth()

at Microsoft.ReportingServices.WebServer.Global.EnableAntiDos()

at Microsoft.ReportingServices.WebServer.Global.Application_EndRequest(Object sender, EventArgs e)

End of inner exception stack trace

w3wp!library!1!03/24/2006-16:45:14:: i INFO: Exception dumped to: C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles flags= ReferencedMemory, AllThreads, SendToWatson

Any help would be appreciated:

System 2003 Server IIS6 and Sql2005 enterprise all housed on Virtual Server. all housed locally.

Check whether your ReportServer\web.config file has an XML namespace in it. SRS doesn't expect one to be present, but some tools from VS2005 web projects will add one in some cases.

If there is a namespace present, you can safely remove it.

Hope that helps,

Tudor

|||

Thanks here is my webconfig file:

<?xml version="1.0" encoding="utf-8" ?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<configSections>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics" />
</configSections>
<system.diagnostics>
<switches>
<!-- 1 = error, 2 = warning, 3 = info, 4 = verbose -->
<add name="DefaultTraceSwitch" value="3" />
</switches>
<assert assertuienabled="false" />
</system.diagnostics>
<RStrace>
<add name="FileName" value="ReportServer_" />
<add name="FileSizeLimitMb" value="32" />
<add name="KeepFilesForDays" value="14" />
<add name="Prefix" value="tid, time" />
<add name="TraceListeners" value="debugwindow, file" />
<add name="TraceFileMode" value="unique" />
<add name="Components" value="all,RunningJobs:3,SemanticQueryEngine:2,SemanticModelGenerator:2" />
</RStrace>
<system.web>
<customErrors mode="On" defaultRedirect="http://usprofiling/ReportCustomErrorPage.htm" />
<pages validateRequest="false" />
<authentication mode="Windows" />
<identity userName="" password="" impersonate="true" />
<compilation defaultLanguage="c#" debug="false">
<assemblies>
<clear />
<add assembly="ReportingServicesWebServer" />
</assemblies>
</compilation>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" />
<sessionState mode="Off" />
<httpHandlers>
<add verb="*" path="Reserved.ReportServer" type="Microsoft.ReportingServices.WebServer.ReportServiceHttpHandler, ReportingServicesWebServer" />
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebServer, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
</httpHandlers>
<httpModules></httpModules>
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
<httpRuntime executionTimeout="9000" />
<securityPolicy>
<trustLevel name="RosettaSrv" policyFile="rssrvpolicy.config" />
</securityPolicy>
<trust level="RosettaSrv" originUrl="" />


</system.web>
<runtime>
<legacyImpersonationPolicy enabled="true"/>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces"
publicKeyToken="89845dcd8080cc91"
culture="neutral" />
<bindingRedirect oldVersion="8.0.242.0"
newVersion="9.0.242.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>

Ant this has been working for the past month suddenly stopped. I removed the xmlns per request and it works now, so when using vs2005 it adds this tag?

|||

Hi,

I have the same problem and deleted the xmlns in the web.config:

<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">

But then another error happens: rsServerConfigurationError. The log indicates the following:

aspnet_wp!library!1!12/07/2006-10:06:39:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details., Could not load Authorization extension;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details.
aspnet_wp!library!6!07/12/2006-10:07:40:: i INFO: Catalog SQL Server Edition = Developer
aspnet_wp!library!1!12/07/2006-10:08:47:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details., Could not load Authorization extension;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: An internal error occurred on the report server. See the error log for more details.

Any idea? Help will be much appreciated, thanks a lot! :)

|||

Look in the ReportManager\web.config and ReportServer\web.config files, you should have the authentication mode set to "Windows".

<system.web>

<pages validateRequest="false" />

<authentication mode="Windows" />

<identity impersonate="true" />

This should be enough to solve your problem.

Greets.

|||Thanks, that was the solution for me!|||

.. so close to resolving my problem - but I'm still getting error 'Object reference not set to an instance of an object'.

I have checked out all of the above - but my Reporting Manager is still not my friend - anymore. Something must have happened ...

Subscribtions from Reporting Manager are still working, when I'm sending file (pdf e.g.)

Web.config is on both RepMan and RepServ =

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<configSections>

--

<system.web>
<pages validateRequest="false" />
<authentication mode="Windows" />
<identity impersonate="true" />
<compilation defaultLanguage="c#" debug="false">
<assemblies>
<clear />

SQL server 2005 is installed on MS server 2003 Stand ed., SP1

Is there any good souls who can help me find a solution to this problem?