Cannot preview or print: Invalid Page Number error

(This is a repost, under my correct subscriber ID.)
I have a report that I think is not too complex (a matrix inside a list).
With small datasets, all is well. But with large datasets (the threshold
seems to be around 5500 rows, which should turn out to be about 25 printed
pages), the report displays to the browser just fine, but if I attempt to
print it or preview it:
(1) I get just the 1st page, then a dialog box:
(Caption:) Invalid Page Number
(Text) The requested page does not exist.
(2) In addition, in the RS LogFiles folder, the corresponding log file has
this line in it:
aspnet_wp!chunks!72c!07/20/2006-22:22:04:: i INFO: ###
GetReportChunk('RenderingInfo_IMAGE', 2), chunk was not found!
this=93db4874-b6d5-4cf2-b885-affcf17ced96
I am guessing that the "2" here refers to page 2 of the report, which it is
bombing on.
(3) In addition, the aspnet_wp.exe process goes wild, consuming 80-95% of
the processor speed, and keeps churning until I am forced to shut it down.
========== I am seeing the same behavior (a) on my development machine, (b) on a test
server in my office, (c) at a client site. So I don't think it's an anomoly
of my environment.
I am running with SQL Server 2000, Reporting Services 2000 SP2. I also
found a hotfix on the MSFT site, which I installed, to no effect.
Any ideas, anyone'
Thanks in advance,
C17Hello,
Thank you for your post in MSDN newsgroup!
I understand that you encountered issue when prview/print a specific report
on different machines. If I'm off-base, please let me know.
Based on my research, I was not able to find any known issue on this error.
To troubleshoot the issue we may need to analyze memory dumps or use live
debug, this work has to be done by contacting Microsoft Product Support
Services. Therefore, we probably will not be able to resolve the issue
through the newsgroups. If the issue is urgent, I recommend that you open a
Support incident with Microsoft Product Support Services so that a
dedicated Support Professional can assist with this case. If you need any
help in this regard, please let me know.
For a complete list of Microsoft Product Support Services phone numbers,
please go to the following address on the World Wide Web:
http://support.microsoft.com/directory/overview.asp
If you'd still like to continue working via the newsgroup, please
understand the issue might take a long time to narrow down. During the
course of troubleshooting, we may redirect you to PSS if required. For now,
please try the following and let me know how it goes:
1. Get the sample RS project, and backend database with necessary tables
behind, and send them to me at petery@.microsoft.com. Please also let's know
the detailed reproduce steps
2. Does the issue occurs in report designer? Does the issue occur if you
configure default printer to "Microsoft Office Document Image Writer"?
3. Does the issue only occur with report with large number rows? If you
limit the rows/pages, can you reproduce the issue?
If you have other related information, please also let's know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||I think it might be a timeout issue. I get the "Invalid Page Number" from
Print Preview after EXACTLY 5 minutes.
The question is, WHAT is timing out? I have the following set:
1) Query timeout (set as property of the query on the report) = 1800 seconds
= 30 minutes. (In fact the underlying report query takes only about 20
seconds to run.)
2) Report execution timeout (set for report using Report Manager) = 1800
seconds
3) Site settings default (set for entire site using Report Manager) = 1800
seconds
4) IIS Web Site/Default Web Site properties: 900 seconds = 15 minutes
What else is there that could be causing a time out at exactly 5 minutes'
Thanks,
C17|||Hello,
Thank you for your reply. I think this may not be related to timeout but
rather than memory related issue.
Based on my further research, the GetReportChunk exception shall not be
generated by printer renderer. It might be generated by HTML renderer which
uses url?s for the chart. Printer renderer will create only one stream for
the entire report and this stream will be in memory since we need to seek
on it. If in your report, every page has a chart or graph, We need to
preprocess these graph/chart before we will embed them in the file. This
process is taking time/memory.
If this is the issue, the workaround is to use less pages/records in one
report or use smaller graph. Also, you may contact PSS to get the following
fix to see if it resolves the issue:
905121 FIX: An error message is logged when you try to export a large
report to PDF, and you cannot open a spreadsheet file in Office Excel that
was exported from SQL Server 2000 Reporting Services
http://support.microsoft.com/default.aspx?scid=kb;EN-US;905121
If you have any update, please feel free to let's know.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================|||Peter,
Thank you for the information, but I do not think that HotFix will solve the
problem, because the HotFix addresses problems with charts and images in
export to PDF. However, in my case:
* The problematic report does not contain ANY charts or images
* Export to PDF, and Export to Excel, works just fine. It's just Printing
and Print Preview that fails.
I will try the HotFix if you still think I should, but let me give you some
more information based on my testing:
1) I get the "Invalid Page Number" message box after 5 minutes with: Print
or Print Preview to *any* printer (including "Microsoft Office Document
Image Writer")
2) The problem occurs when running the report under *any* environment: (a)
when running my application, (b) within the report designer, (c) when
running the report from Report Manager.
3) The problem occurs at a threshold of about 800 rows in the underlying
query. If I change the report parameters so the query returns fewer rows,
the report successfully prints/previews in about 45 seconds. Above that
threshold, the report gives the "Invalid Page Number" message box after
exactly 5 minutes.
4) The problem does NOT occur upon Export to Excel, or Export to PDF.
(Export to PDF takes a long time to run, but I understand from reading the
newgroup that this is normal.)
I will bundle up a sample database, and the report, and email them to you as
you suggested in an earlier post. I don't think you will need my
application, because the problem occurs even when you run the report from
Report Manager.
Thanks,
--C17|||Hello Charles,
Thank you for your patience. I tested on RS 2005 SP1 machine and the issue
does not occur. I think you may consider the possibility of upgrading to
SQL 2005 as a workaround. Also, I?d check if I could find other workaround
on RS 2000. Please rest assured I?v reported this issue to the proper
channel. Thanks.
Best Regards,
Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support
=====================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
======================================================Hello Charles,
I was able to reproduce the issue on my side. I tried to upgrade to build
1049 (hotfix 912715) but the issue still persists. It seems to be a product
issue for RS 2000. I will perform some more research and test it on RS
2005. Thank you for your patience.
Best Regards,
Best Regards,