Solved

What would generate an unhandled exception in SSRS 2008r2

Posted on 2014-10-01
4
744 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL RS 2014 - upload all RDL files to report server 7 55
Security manage in SSRS 1 75
SSRS Calculation help 6 50
SSRS page break on parameter values 1 53
Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
Have you ever had to extract data from a Microsoft SQL Server database and export it to an Excel file, but did not want to use a DTS package? The concept in this article is not new, but it is the answer and will also work on 64-bit SQL boxes.   …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

808 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