Solved

What would generate an unhandled exception in SSRS 2008r2

Posted on 2014-10-01
4
717 Views
Last Modified: 2014-10-21
Hi Experts,

I have an SSRS report running under 2008r2 that, most of the time, works perfectly. It produces invoices or credit notes based on user parameter selection from Microsoft AX. However, on four occasions now, users have selected to report on invoices that have a) taken significantly longer to appear in preview in the browser than usual, b) given a "Print Error - An error occurred during printing. (0x80004005)" when printing and c) "Server Error in '/Reports' Application - An internal error occurred on the report server. See the error log for more details. (rsInternal Error)" when exporting to PDF.

Exports to other formats, such as Word or Excel - though not normally used for this report - tend to produce an empty document except for page headers and footers.

One thing I have noticed in common about the 4 invoices to fail is that they are all rental invoices and have more rental line items invoiced than others. The significance this may signal is that each invoice line of a rental type has a sub-report to show different rental periods at different day rates, whereas a non-rental line has a simple quantity, unit price and line amount within the main report.

So, does anyone know how to determine the root cause from the stack dump, or the appropriate section of the server log (which I can get if necessary), have any ideas what the cause may be, or think I may be on the right lines due to some limitation on the number of rendered sub reports from SSRS 2008r2.

I should add that, when I run the same report for the same invoice from within VS 2012 - my development environment - the invoice prints and exports perfectly. I'm thinking some known issue since fixed, which may have a work-around or patch / hot-fix, but I just can't seem to find one on TechNet.

I am based in the UK, and am about to stop work for the evening, so don't expect a response for the next 16 hours or so.
.
Thanks for looking
Mark
0
Comment
Question by:SeeHearMark
  • 3
4 Comments
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 500 total points
Comment Utility
In my opinion there are three separate issues:


a) taken significantly longer to appear in preview in the browser than usual,
either the SSRS server is under heavier load than usual or most likely they select a different range therefore lot more data to be processed/reported on. you can try use some of the SSRS performance improvements described below:
http://stackoverflow.com/questions/976133/performance-issuses-with-ssrs
http://technet.microsoft.com/en-us/library/bb522806(v=sql.105).aspx
http://www.mssqltips.com/sqlservertip/3023/sql-server-reporting-services-tips-and-tricks-to-improve-the-end-user-experience/

 b) given a "Print Error - An error occurred during printing. (0x80004005)" when printing - see if any applies to your problem:

http://go4answers.webhost4life.com/Example/error-occured-during-printing-ssrs-2008-67750.aspx
http://stackoverflow.com/questions/787966/reporting-services-2005-printing-graph-an-error-occurred-during-printing-0
https://social.msdn.microsoft.com/Forums/sqlserver/en-US/75340f2f-99de-41c5-bf4f-3cd0cfac986b/0x80004005-error-when-printing-ssrs-rdlc-report?forum=sqlreportingservices



c) "Server Error in '/Reports' Application - An internal error occurred on the report server.
http://msdn.microsoft.com/en-ca/library/ms165307.aspx
http://msdn.microsoft.com/en-us/library/aa337323.aspx
http://msdn.microsoft.com/en-us/library/aa337312.aspx
0
 

Author Comment

by:SeeHearMark
Comment Utility
Hi and thanks for your reply. Lots to digest there, so will take a while to come back, but interesting that you think there are 3 separate issues!
0
 

Accepted Solution

by:
SeeHearMark earned 0 total points
Comment Utility
Hi again,

Firstly, some of the links you provided relating to performance issues gave me pointers to articles I had not come across before, and held some interesting information. As I said, there's a lot to digest there, so thanks for that.

Unfortunately, none of the links related to the printing error involved my circumstances, or anything close, so were not of any help. The pointers on the internal server error were, of course, very generic and did little other than remind me that I still had not had a copy of the SSRS server trace log from the system admin. Quite why they can't give me access, I really don't know, but that's another problem :)

Anyway, the server log did give me the internal error stack trace, pointing the finger at
Microsoft.ReportingServices.Rendering.HPBProcessing.Tablix.PageMemberCell.ResolveRHDuplicates
and an InternalCatalogException index out of range. A quick search gave me 2008 Reporting Services:An internal error occurred on the report server while exporting to PDF only for one report which described precisely my issue. Removing the single HideDuplicates I had in the report, which happened to only be for rental invoices under some fairly rare circumstances resolved the error.

So, I guess I'll accept your response as the solution, if only to underline the importance of checking the SSRS server log!

Thanks
Mark
0
 

Author Closing Comment

by:SeeHearMark
Comment Utility
The expert provided a link to a generic article on getting more information from the SSRS server log. This in itself is not a solution, but directed me to finding further information that led to the article I quoted that provided the solution.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
repeat headers on every page when exporting to excel 2 37
SSRS report 5 44
SSRS 2012 URL 11 46
Visual Studio 2008 book recommendation 6 27
Introduction: This article is aimed at report developers who are used to developing reports using relational databases and have gotten a first-time assignment to develop reports on OLAP cubes. It demonstrates how to build a report using SQL Ser…
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
This video discusses moving either the default database or any database to a new volume.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now