Re: SQL server 2000 RS printing problem

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

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums.aspx/sql-server-tools/200705/1

.

Relevant Pages

  • Re: SQL server 2000 RS printing problem
    ... report is setting off the error - graphics, drill throughs, ... SnapshotCompression to 'SQL' as specified in Server system properties. ... ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream ... operation cannot be located in the report server database. ...
    (microsoft.public.sqlserver.tools)
  • Re: SQL server 2000 RS printing problem
    ... I am having this exact same issue, but no luck on any of the articles or ... report is setting off the error - graphics, drill throughs, ... SnapshotCompression to 'SQL' as specified in Server system properties. ... ReportingServices.Diagnostics.Utilities.StreamNotFoundException: The stream ...
    (microsoft.public.sqlserver.tools)
  • XLANGPart.LoadFrom(stream) failing - UnauthorizedAccessException
    ... My component then generates a PDF stream using Crystal Reports, ... attempts to load the XLANGMessage's 1st data part with the stream generated ... ReportDocument report = new ReportDocument; ... Exception thrown from: segment 1, ...
    (microsoft.public.biztalk.general)
  • How to print only certain page(s) in Microsoft Reports rdlc
    ... to load it to report viewer first. ... printDoc.PrinterSettings.PrinterName = printerName; ... Stream stream = new MemoryStream; ... private void Export ...
    (microsoft.public.dotnet.framework.windowsforms)
  • Problem mit LocalReport im MemoryStream
    ... Von dem 6 Seiten langen Report werden jedoch nur 4 Seiten ... deviceInfo, out mimeType, out encoding, out extension, out streamIDs, ... string encoding; ... //set the position of the stream to 0 to make sure ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)