SSRS 2016 giving 500 error

  • Hello!

    I am getting this intermittent issue when browsing the report, this error goes away once I refresh the browser.

    This seems to be happening when accessing report through the load balancer (https://) only

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

    Thanks in advance.

    • This topic was modified 1 month, 1 week ago by  PJ_SQL.
  • My first step - check the logs.

    Is the error coming from the load balancer or SSRS?  Do you get the same error if  you go directly to the machine rather than through the load balancer on any of the machines?

    I would look at the logs for SSRS on all of the machines as well as the load balancer.  Check the SSRS logs and the windows event logs and might not even hurt to check the SQL Server logs.  But I expect that one (or more) of the logs will provide better info than error 500.  If memory serves, a 500 error is a server side error.  Refreshing the page is likely pushing you over to a different server from the load balancer which is why a refresh fixes the issue.  Basically, load balancer points you to server A which gives you the 500 error.  You hit refresh, the load balancer gets your request and pushes you over to server B and you don't get the error.  Since it is intermittent, it is likely that you are being directed to server A infrequently and thus don't see the error often.

    But the logs will confirm what the issue is for sure.  That and testing SSRS on each of the machines in the load balancer rotation.  But even if you determine which machine in the load balancer rotation is giving the error, you will still need to check the logs to determine what is wrong.  Therefore, I would check logs as my first step.

  • It is only happening when trying to access reports through load balancer and too for https not for http

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply