Solved

Unhandled exception (sometimes) in SSRS 2016 Native mode

Posted on 2016-09-23
7
46 Views
Last Modified: 2016-10-23
We're currently using SSRS 2016 (the unpatched RTM) in Native mode and we've run into an issue that occurs rarely, but often enough to be a problem. When viewing a report, leaving it up on the screen for a while (more than a few minutes, but it doesn't always occur) and then coming back later and trying to expand a group or open a separate segment of the report results in an exception:

Sys.Webforms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500

Unfortunately that's pretty generic and not much help - I found an ASP.NET 4.0.30319.0 "Warning" (Event ID 1309) in the server's application event log that has a bit more detail (snipped a bit to show what seems like the relevant portions):

Event code: 3005
Event message: An unhandled exception has occurred.
(Snip)
Event detail code: 0
 
Application information:
    Application domain: ReportServer_MSSQLSERVER_0-34-131190290606090156
    Trust level: RosettaSrv
    Application Virtual Path: /ReportServer
    Application Path: C:\Program Files\Microsoft SQL Server\MSRS13.MSSQLSERVER\Reporting Services\ReportServer\
    (Snip)
 
Process information:
    Process ID: 1600
    Process name: ReportingServicesService.exe
    (Snip)
 
Exception information:
   Exception type: ArgumentNullException
    Exception message: Value cannot be null.
Parameter name: exception
   at System.Web.UI.AsyncPostBackErrorEventArgs..ctor(Exception exception)
   at System.Web.UI.PageRequestManager.OnPageError(Object sender, EventArgs e)

Has anybody seen this before? It's occurring on all three of our servers (we have a scale-out deployment), but it only happens once every few days or so (about once/week per server). I don't think it's not a strict timeout, as I've let a report sit open on the site for hours and then browsed around with no issue at all.

There's a CU out for SQL 2016 that we're going to apply in our lab to see if that resolves it, but I wanted to see if anybody here had thoughts before we do that.
0
Comment
Question by:Ryan McCauley
  • 4
  • 3
7 Comments
 
LVL 14

Assisted Solution

by:Megan Brooks
Megan Brooks earned 500 total points
ID: 41812859
I haven't had an opportunity yet to set up an SSRS 2016 test environment, but this sounds vaguely similar to things I have seen in the past with earlier versions. The messages above seem to imply that you are using the HTML renderer. Is that correct? Are you viewing in the report server Report Manager, in ReportVIewer embedded in your application, or in your own or a 3rd party report viewer?

As I understand it, CUs are now intended to be installed as product updates (as opposed to hotfixes) at the time they are released, after testing of course. I think the CU should be the best place to start.
0
 
LVL 28

Author Comment

by:Ryan McCauley
ID: 41813413
This occurs on the native SSRS site when viewing a report - we're not embedding anything or doing any non-standard rendering. If there are other options for rendering, I'm happy to try those but I thought it was just the HTML renderer - it appears to be entirely handled by IIS.

I figured the CU is the best place to start - we'll be testing those next week and I'll post here if it resolves the issue (I'm not hopeful based on the released notes, but I'd love to be pleasantly surprised).
0
 
LVL 14

Expert Comment

by:Megan Brooks
ID: 41813425
CU2 came out today. It seems to contain a number of additional SSRS fixes.
0
Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

 
LVL 28

Author Comment

by:Ryan McCauley
ID: 41818851
We're trying to reproduce this error in our UAT environment - once we're able to do that, we'll be applying CU2 to see if it resolves it and then I'll update the thread.
0
 
LVL 28

Accepted Solution

by:
Ryan McCauley earned 0 total points
ID: 41849450
This ended up not being an issue resolved by CU2, but rather a step we missed during configuration of setting the machine key to match between all servers in the scale-out deployment:

https://msdn.microsoft.com/en-us/library/cc281307.aspx

It appeared this was happening when the load balancer switched the user between different servers, which wasn't happening very often. Once we corrected the machine key, this error hasn't reappeared.
1
 
LVL 28

Author Closing Comment

by:Ryan McCauley
ID: 41855849
Final resolution wasn't suggested by any other participants.
0
 
LVL 14

Expert Comment

by:Megan Brooks
ID: 41856306
Ouch, that would do it!
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Get Duration of last Status Update 4 31
email about the whoisactive result 7 27
T-SQL--Two Different Totals Even with the Same Concept 6 45
Help Extract Specific in SQL 8 25
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

895 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

14 Experts available now in Live!

Get 1:1 Help Now