Re: SQL server 2000 RS printing problem
  Home FAQ Contact Sign in
microsoft.public.sqlserver.tools only
 
Advanced search
POPULAR GROUPS

more...

 Up
Re: SQL server 2000 RS printing problem         

Group: microsoft.public.sqlserver.tools · Group Profile
Author: Dan
Date: May 23, 2007 11:06

I am having this exact same issue, but no luck on any of the articles or
hotfixes mentioned in this posting. I can deploy the same report to a
different server and print fine, but on my main production box I'm getting
the error. I am just calling the reports from a URL in my address bar in IE.
Please help. Thanks.

"Sue Hoegemeier" wrote:
> There are some solutions out there depending on what in the
> report is setting off the error - graphics, drill throughs,
> rendering formats, how the report is being viewed - those
> all make a difference with that error. Check this thread for
> a couple:
> http://www.sqlservercentral.com/forums/printtopic.aspx?forumid=162&messageid=110...
>
> -Sue
>
> On Wed, 16 May 2007 14:55:02 GMT, "Charlie_HE via
> SQLMonster.com" wrote:
>
>>Sue,
>>
>>Thanks for the reply.
>>
>>We turned the client print log on and caught the following errors in the
>>reporting service log
>>
>>### GetReportChunk('RenderingInfo_HTML4.0', 2), chunk was not found.
>>
>>The detailed log is listed below. I searched those errors and found no
>>solution except the Microsoft support. Someone indicated this was a memory
>>issue.
>>
>>Charlie
>>
>> w3wp!library!1700!05/11/2007-09:59:59:: i INFO: Call to RenderFirst( '/EDV -
>>Elanco/ProductList' )
>>
>>w3wp!library!1700!05/11/2007-10:00:01:: i INFO: Initializing
>>SqlStreamingBufferSize to default value of '64640' Bytes because it was not
>>specified in Server system properties.
>>
>>w3wp!library!1700!05/11/2007-10:00:01:: i INFO: Initializing
>>SnapshotCompression to 'SQL' as specified in Server system properties.
>>
>>w3wp!library!1700!05/11/2007-10:00:01:: i INFO: Initializing
>>EnableExecutionLogging to 'True' as specified in Server system properties.
>>
>>w3wp!webserver!1700!05/11/2007-10:00:01:: i INFO: Processed report.
>>Report='/EDV - Elanco/ProductList', Stream=''
>>
>>w3wp!library!9b4!05/11/2007-10:00:01:: i INFO: Initializing
>>SessionAccessTimeout to default value of '600' seconds because it was not
>>specified in Server system properties.
>>
>>w3wp!library!9b4!05/11/2007-10:00:01:: i INFO: Call to RenderNext( '/EDV -
>>Elanco/ProductList' )
>>
>>w3wp!chunks!9b4!05/11/2007-10:00:01:: i INFO: ### GetReportChunk
>>('RenderingInfo_HTML4.0', 2), chunk was not found! this=91ff3eb1-2cbf-41f9-
>>a1c6-6812b8f8e968
>>
>>w3wp!library!9b4!05/11/2007-10:00:02:: Using folder D:\Program Files\
>>Microsoft SQL Server\MSSQL\Reporting Services\RSTempFiles for temporary files.
>>
>>
>>w3wp!cache!9b4!05/11/2007-10:00:02:: i INFO: Session live: /EDV -
>>Elanco/ProductList
>>
>>w3wp!webserver!9b4!05/11/2007-10:00:02:: i INFO: Processed report.
>>Report='/EDV - Elanco/ProductList', Stream=''
>>
>>w3wp!library!6e0!05/11/2007-10:00:15:: i INFO: Call to RenderFirst( '/EDV -
>>Elanco/ProductList' )
>>
>>w3wp!library!6e0!05/11/2007-10:00:15:: i INFO: Initializing
>>EnableExecutionLogging to 'True' as specified in Server system properties.
>>
>>w3wp!webserver!1700!05/11/2007-10:00:15:: i INFO: Processed report.
>>Report='/EDV - Elanco/ProductList', Stream=''
>>
>>w3wp!library!9b4!05/11/2007-10:00:15:: i INFO: Call to RenderNext( '/EDV -
>>Elanco/ProductList' )
>>
>>w3wp!cache!9b4!05/11/2007-10:00:15:: i INFO: Item not cacheable: -
>>PersistStreams /EDV - Elanco/ProductList
>>
>>w3wp!chunks!9b4!05/11/2007-10:00:15:: i INFO: ### GetReportChunk
>>('RenderingInfo_IMAGE', 2), chunk was not found! this=86f64f44-7d54-4553-a90e-
>>6119296d6da1
>>
>>w3wp!webserver!6e0!05/11/2007-10:00:16:: i INFO: Processed report.
>>Report='/EDV - Elanco/ProductList', Stream=''
>>
>>w3wp!library!6e0!05/11/2007-10:00:16:: 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.
>>
>>w3wp!cache!9b4!05/11/2007-10:00:16:: i INFO: Session live: /EDV -
>>Elanco/ProductList
>>
>>w3wp!webserver!6e0!05/11/2007-10:00:18:: e ERROR: Reporting Services error
>>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.
>>
>>w3wp!library!6e0!05/11/2007-10:09:11:: i INFO: Cleaned 0 batch records, 0
>>policies, 0 sessions, 0 cache entries, 0 snapshots, 0 chunks, 0 running jobs
>>
>>
>>
>>
>>
>>
>>Sue Hoegemeier wrote:
>>>Others hit a similar issues on SP2 - check the following
>>>article regarding the hotfix:
>>>FIX: Error message when you print a report in SQL Server
>>>2000 Reporting Services: "An error occurred during printing
>>>(0x80004005)"
>>>http://support.microsoft.com/kb/907010
>>>
>>>-Sue
>>>
>>>>We had a SQL Server 2000 Reporing Service SP2. We had a problem to print the
>>>>reports from the reporting service website on the client server. The strange
>>>[quoted text clipped - 15 lines]
>>>>
>>>>Charlie
>
>
no comments
diggit! del.icio.us! reddit!