October 20, 2020 at 11:09 pm
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.
October 21, 2020 at 4:31 pm
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.
The above is all just my opinion on what you should do.
As with all advice you find on a random internet forum - you shouldn't blindly follow it. Always test on a test server to see if there is negative side effects before making changes to live!
I recommend you NEVER run "random code" you found online on any system you care about UNLESS you understand and can verify the code OR you don't care if the code trashes your system.
October 21, 2020 at 11:05 pm
It is only happening when trying to access reports through load balancer and too for https not for http
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply