StreamNotFoundException in reports with drill and images
Hi,
I always have this exception:
w3wp!library!1!02/28/2007-13:50:11:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database., ;Info: Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database.When i try to drill in a report that have images.
The weird is that i only have this error when i view thisreportin ReportViewer in a .aspx page. When i try to enter in this report directly by using the ReportServer ( http://server/Reports) i dont have this error.
whatis wrong ?cya
February 28th, 2007 8:05pm
Does the report have two or more parameters?
http://support.microsoft.com/default.aspx/kb/913363
System.Web.Services.Protocols.SoapException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. ---> Microsoft.ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream cannot be found. The stream identifier that is provided to an operation cannot be located in the report server database. at Microsoft.ReportingServices.WebServer.HttpClientRequest.InitForRequest(CatalogItemContext context, String userName) at Microsoft.ReportingServices.WebServer.ReportingService.RenderStream(String Report, String Format, String StreamID, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, Byte[]& Result, String& Encoding, String& MimeType) --- End of inner exception stack trace --- at Microsoft.ReportingServices.WebServer.ReportingService.RenderStream(String Report, String Format, String StreamID, String HistoryID, String DeviceInfo, ParameterValue[] Parameters, Byte[]& Result, String& Encoding, String& MimeType)
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2007 8:14pm
Hi,
I have just one parameter.
Any suggestion ?
cya
ps.: using SS SP2
February 28th, 2007 8:30pm
You may want to try the hotfix that I posted anyway. But I'm not positive it will fix your issue.
Free Windows Admin Tool Kit Click here and download it now
February 28th, 2007 9:14pm
Hi GregSQL
tks for the reply.
But i think that this hotfix is inside the SP1 for SS http://support.microsoft.com/kb/913090
And i using SS SP2
Any suggestion ?
cya
February 28th, 2007 9:33pm
Hi,
Problem solved.
But, i think that is a bug in ReportViewer control.
I change my <sessionState> from "StateServer" to "InProc"
I know that objects aren't real serialized when the sessionState is in InProc when inserted in Session ( or Application ),only when the sessionState is in StateServer ( or SqlServer ). There issomething beeinginsertedin Session or Application in ReportViewer control ?
Can someone from MS check this ? Why in InProc works and with StateServer not
cya
Free Windows Admin Tool Kit Click here and download it now
March 1st, 2007 7:51pm
We got the hotfix for this as per KB 913363 but it will not install. Gives an error:
This update requires service pack 0. The service pack for product instance MSSQLSERVER is 2. Download the update for service pack 2.
We've downloaded the cumulative update (build 3161) as per KB 935356 and installed it, rebooted, and we still get this error message.
What do we need installed to get this hotfix installed?
Thanks.
- Grant
August 7th, 2007 7:15pm
We're experiencing the same problem but with SQL Server 2008 - is there a hotfix for this version too?
Free Windows Admin Tool Kit Click here and download it now
May 9th, 2011 10:01am
Just discovered what was causing the error in our case - a column's visibility in one of the tables was set to hidden but we were attempting to merge some of its cells with an adjacent visible column (doh!) - would help if
this general rendering error was a little clearer though...
May 9th, 2011 10:19am