Solved

What would generate an unhandled exception in SSRS 2008r2

Posted on 2014-10-01
4
728 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
ID: 40380607
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
ID: 40382489
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
ID: 40384872
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
ID: 40393987
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
It is helpful to note: This is a cosmetic update and is not required, but should help your reports look better for your boss.  This issue has manifested itself in SSRS version 3.0 is where I have seen this behavior in.  And this behavior is only see…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

864 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

22 Experts available now in Live!

Get 1:1 Help Now