Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

What would generate an unhandled exception in SSRS 2008r2

Posted on 2014-10-01
4
Medium Priority
?
821 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 40

Assisted Solution

by:lcohan
lcohan earned 1500 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
Steps to solve SSRS SQL 2008 R2 User Access Control (UAC) Permission Error With the introduction of SQL Server 2008 R2 and Vista (Windows 7 as well) came new enhanced security features. One of the features included was User Access Control (UAC) t…
We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data. But that feeling is fleeting. Attacks these days can happen in many w…
Loops Section Overview
Suggested Courses

824 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