SQL Reporting error

[Sheila]

Hi,

Does anybody encounter the following SQL reporting error:

Reporting Services Error:
An internal error occured on the report server. See the error log for more
details. (rsInternalError) Object reference not set to an instance of an
object.

The error appears at the end of the report (although report content is
successfully displayed), and it does not happen all the time. When it occurs,
if you print again, it won't happen. Sometimes I need to re-print 3 or 4
times.

Does anybody know what could be the reason, is there any way to configure
the reporting service so that the error message will not be displayed on the
report.

Following is the error message captured in report log file.

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.Library.ReportSnapshot.EnsureAllStreamsAreClosed()
at
Microsoft.ReportingServices.Library.RSService.RenderAsLive(CatalogItemContext
reportContext, ItemProperties properties, ParameterInfoCollection
effectiveParameters, Guid reportId, ClientRequest session, String
description, ReportSnapshot intermediateSnapshot, DataSourceInfoCollection
thisReportDataSources, Boolean cachingRequested, Warning[]& warnings,
ReportSnapshot& resultSnapshotData, DateTime& executionDateTime,
RuntimeDataSourceInfoCollection& alldataSources, UserProfileState&
usedUserProfile)
at
Microsoft.ReportingServices.Library.RSService.RenderAsLiveOrSnapshot(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters)
at
Microsoft.ReportingServices.Library.RSService.RenderFirst(CatalogItemContext
reportContext, ClientRequest session, Warning[]& warnings,
ParameterInfoCollection& effectiveParameters, String[]& secondaryStreamNames)
--- End of inner exception stack trace ---

Thanks in advance.

[bobfoc]

Hi Sheila,

I had an rsinternal error (when deploying to my report manager) as well not
exactly like this one, but found very little documentation on the internet.
After trying many different things, i restarted IIS and it seemed to fix the
problem.
I know you haven't said it's related with your deploiyment but if it is then
just try restarting IIs and see if it works.

good luck, sorry if this is useless but thought i'd try.

bob

"Sheila" <She...@discussions.microsoft.com> wrote in message
news:524F9956-39F1-4F62...@microsoft.com...