Out-of-control Logging

This morning I found out that reporting services was logging out-of-control.
In one day I have about 2 Gigs of the last four lines:
<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.878.00</Product>
<Locale>en-US</Locale>
<TimeZone>Central Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__07_16_2004_06_40_23.log</Path>
<SystemName>[Removed]</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!runningjobs!1b48!7/16/2004-06:40:23:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 69576 seconds
ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
Expiring old execution log entries
ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
Expiration of old execution log entries is complete. Removed 0 entries.
ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO: Cleaned
0 broken snapshots, 0 chunks
Can anyone tell me what's going on and how to correct the problem?
Thanks in advance,
BryanCurrently the only workaround is to first try restarting the ReportServer
service. If that does not help you will need to restart the box. We are
aware of this issue and are looking into it.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Bryan Bullard" <reply@.to.group.com> wrote in message
news:eWfbW10aEHA.3352@.TK2MSFTNGP10.phx.gbl...
> This morning I found out that reporting services was logging
out-of-control.
> In one day I have about 2 Gigs of the last four lines:
> <Header>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.878.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>Central Daylight Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__07_16_2004_06_40_23.log</Path>
> <SystemName>[Removed]</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> ReportingServicesService!runningjobs!1b48!7/16/2004-06:40:23:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 69576 seconds
> ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
> Expiring old execution log entries
> ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
> Expiration of old execution log entries is complete. Removed 0 entries.
> ReportingServicesService!dbcleanup!11f8!7/16/2004-06:40:23:: i INFO:
Cleaned
> 0 broken snapshots, 0 chunks
> Can anyone tell me what's going on and how to correct the problem?
> Thanks in advance,
> Bryan
>

Out of memory error

I'm trying to generate a very large report. My server's got 32 gigs of memory though, so memory shouldn't be an issue. However, when I try to generate my report, I get the following outofmemory error message in the error log on the server:

EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 116e, P8 29, P9 system.outofmemoryexception, P10 NIL.

The w3wp.exe process maxes out at ~1,250 MB. I imagine I just have to change a setting somewhere to allow this to grow beyond that, but I can't seem to find that setting. What do I have to do?

Thanks!

-Carl

Were you able to resolve this issue?

Anyone have any ideas?

|||I am receiving this same error in the desktop development studio - system.outofmemory was thrown with 1044612 rows. It runs fine in the "Data" tab and in management studio but when I try to preview the report in the "Preview "tab I get this error. Any resolution for this?|||

I am having the same problem - the query runs perfectly fine in Management studio, or the Data tab - but when the report is generated it gives out of memory error.

Is there a resolution, or a workaround (would a custom ITemporaryStorage class resolve this issue - I can't find any example code or discussion on this except MSDN api docs)

Out of memory error

I'm trying to generate a very large report. My server's got 32 gigs of memory though, so memory shouldn't be an issue. However, when I try to generate my report, I get the following outofmemory error message in the error log on the server:

EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 116e, P8 29, P9 system.outofmemoryexception, P10 NIL.

The w3wp.exe process maxes out at ~1,250 MB. I imagine I just have to change a setting somewhere to allow this to grow beyond that, but I can't seem to find that setting. What do I have to do?

Thanks!

-Carl

Were you able to resolve this issue?

Anyone have any ideas?

|||I am receiving this same error in the desktop development studio - system.outofmemory was thrown with 1044612 rows. It runs fine in the "Data" tab and in management studio but when I try to preview the report in the "Preview "tab I get this error. Any resolution for this?|||

I am having the same problem - the query runs perfectly fine in Management studio, or the Data tab - but when the report is generated it gives out of memory error.

Is there a resolution, or a workaround (would a custom ITemporaryStorage class resolve this issue - I can't find any example code or discussion on this except MSDN api docs)

Out of memory error

I'm trying to generate a very large report. My server's got 32 gigs of memory though, so memory shouldn't be an issue. However, when I try to generate my report, I get the following outofmemory error message in the error log on the server:

EventType clr20r3, P1 w3wp.exe, P2 6.0.3790.3959, P3 45d6968e, P4 mscorlib, P5 2.0.0.0, P6 4333ab80, P7 116e, P8 29, P9 system.outofmemoryexception, P10 NIL.

The w3wp.exe process maxes out at ~1,250 MB. I imagine I just have to change a setting somewhere to allow this to grow beyond that, but I can't seem to find that setting. What do I have to do?

Thanks!

-Carl

Were you able to resolve this issue?

Anyone have any ideas?

|||I am receiving this same error in the desktop development studio - system.outofmemory was thrown with 1044612 rows. It runs fine in the "Data" tab and in management studio but when I try to preview the report in the "Preview "tab I get this error. Any resolution for this?|||

I am having the same problem - the query runs perfectly fine in Management studio, or the Data tab - but when the report is generated it gives out of memory error.

Is there a resolution, or a workaround (would a custom ITemporaryStorage class resolve this issue - I can't find any example code or discussion on this except MSDN api docs)

sql

Out of disk space

We are having a ton of problems with a full backup. The db is 120 gigs,
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas?
Thanks
Richard
What is the exact message? Are you sure the backup device is pointing to
the correct drive?
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas?
> Thanks
> Richard
>
|||What is the size of the log file?
"Richard Douglass" wrote:

> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out of
> disk space. Makes no sense.
> Any ideas?
> Thanks
> Richard
>
>

Out of disk space

We are having a ton of problems with a full backup. The db is 120 gigs,
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas'
Thanks
RichardWhat is the exact message? Are you sure the backup device is pointing to
the correct drive?
--
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>|||What is the size of the log file?
"Richard Douglass" wrote:
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out of
> disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>
>

Out of disk space

We are having a ton of problems with a full backup. The db is 120 gigs,
there are 270 gigs free on the server and it continues to fail saying out of
disk space. Makes no sense.
Any ideas'
Thanks
RichardWhat is the exact message? Are you sure the backup device is pointing to
the correct drive?
Andrew J. Kelly SQL MVP
"Richard Douglass" <RDouglass@.arisinc.com> wrote in message
news:eROSq$ANGHA.3908@.TK2MSFTNGP10.phx.gbl...
> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
> of disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>|||What is the size of the log file?
"Richard Douglass" wrote:

> We are having a ton of problems with a full backup. The db is 120 gigs,
> there are 270 gigs free on the server and it continues to fail saying out
of
> disk space. Makes no sense.
> Any ideas'
> Thanks
> Richard
>
>