sql server reporting services: When I execute the report from a remoting object using the web service api I
get the following error:

<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\ReportServer__08_23_2005_12_26_49.log</Path>
<SystemName>HCDCO-DBS1</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
aspnet_wp!webserver!2134!8/23/2005-12:26:49:: i INFO: Reporting Web Server
started
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
ConnectionType to '0' as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
IsEventService to 'True' as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
PollingInterval to '10' second(s) as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing MemoryLimit
to '60' percent as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing RecycleTime
to '720' minute(s) as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
MaxQueueThreads to '0' thread(s) as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
MaxActiveReqForOneUser to '200' requests(s) as specified in Configuration
file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
MaxScheduleWait to '5' second(s) as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
InstanceName to 'MSSQLSERVER' as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
DisplayErrorLink to 'True' as specified in Configuration file.
aspnet_wp!library!2134!8/23/2005-12:26:49:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
aspnet_wp!resourceutilities!2134!8/23/2005-12:26:50:: i INFO: Running on 4
physical processors, 4 logical processors
aspnet_wp!resourceutilities!2134!8/23/2005-12:26:50:: i INFO: Reporting
Services starting SKU: Standard
aspnet_wp!runningjobs!2134!8/23/2005-12:26:50:: i INFO: Database Cleanup
(Web Service) timer enabled: Cycle: 600 seconds
aspnet_wp!runningjobs!2134!8/23/2005-12:26:50:: i INFO: Running Requests
Scavenger timer enabled: Cycle: 60 seconds
aspnet_wp!runningjobs!2134!8/23/2005-12:26:50:: i INFO: Running Requests DB
timer enabled: Cycle: 60 seconds
aspnet_wp!runningjobs!2134!8/23/2005-12:26:50:: i INFO: Memory stats update
timer enabled: Cycle: 60 seconds
aspnet_wp!crypto!2134!08/23/2005-12:26:55:: i INFO: Initializing crypto as
user: HCDCO-DBS1\ASPNET
aspnet_wp!crypto!2134!08/23/2005-12:26:55:: i INFO: Exporting public key
aspnet_wp!crypto!2134!08/23/2005-12:26:56:: i INFO: Performing sku validation
aspnet_wp!crypto!2134!08/23/2005-12:26:56:: i INFO: Importing existing
encryption key
aspnet_wp!library!2134!08/23/2005-12:26:56:: i INFO: Call to RenderFirst(
'/JISReports/JISTreasurerChecks' )
aspnet_wp!library!2134!08/23/2005-12:26:56:: i INFO: Initializing
EnableIntegratedSecurity to 'True' as specified in Server system properties.
aspnet_wp!library!2134!8/23/2005-12:27:01:: i INFO: Initializing
SqlStreamingBufferSize to default value of '64640' Bytes because it was not
specified in Server system properties.
aspnet_wp!library!2134!8/23/2005-12:27:01:: i INFO: Initializing
SnapshotCompression to 'SQL' as specified in Server system properties.
aspnet_wp!runningjobs!403c!8/23/2005-12:27:50:: i INFO: Adding: 1 running
jobs to the database
aspnet_wp!runningjobs!403c!8/23/2005-12:27:50:: i INFO: Removing: 1 running
jobs from the database
aspnet_wp!reportrendering!2134!08/23/2005-12:28:41:: e ERROR: Throwing
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown., ;
Info:
Microsoft.ReportingServices.ReportProcessing.WrapperReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. --->
Microsoft.ReportingServices.ReportRendering.ReportRenderingException:
Exception of type
Microsoft.ReportingServices.ReportRendering.ReportRenderingException was
thrown. ---> System.OutOfMemoryException: Exception of type
System.OutOfMemoryException was thrown.
--- End of inner exception stack trace ---
at
Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRendererBase.Render(Report
report, NameValueCollection reportServerParameters, NameValueCollection
deviceInfo, NameValueCollection clientCapabilities,
EvaluateHeaderFooterExpressions evaluateHeaderFooterExpressions,
CreateAndRegisterStream createAndRegisterStream)
at
Microsoft.ReportingServices.ReportProcessing.ReportProcessing.a(DateTime A_0,
GetReportChunk A_1, ProcessingContext A_2, RenderingContext A_3,
CreateReportChunk A_4, Boolean& A_5)
--- End of inner exception stack trace ---
aspnet_wp!library!2134!08/23/2005-12:28:41:: i INFO: Initializing

It looks like you're running out of memory. Try freeing up memory (or
increasing overall system memory) in order to render larger reports.

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]