Hi IT Guru's,

I have a long running SSRS "Report" (It actually kicks off 9 Insert Queries in SQL) that works fine in SSRS 2005, but since being upgraded to SSRS 2012, it now errors the two errors below. Sometimes it runs with Zero errors, or it may prompt for a login again (I believe that is SSRS timming out) and then error out anyway. See the two errors below:

Any assistance would be great - the report and query have not changed other than being migrated to SSRS 2012 from 2005.

Errors:

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

OR

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

Hi MBall,

This might be due to the following reasons

There is no space (0 Byte is available) in the drive where underlying SQL DB is residing. 

OR 

Please check if the following web config appSettins value settings from SSRS server could fix the issue (Note, back up your original web config file before any modification).

http://stackoverflow.com/questions/10911610/ssrs-webpage-error-status-code-500

http://srinivasbn.blogspot.in/2013/09/syswebformspagerequestmanagerservererro.html

http://connect.microsoft.com/SQLServer/feedback/details/782155/ssrs-2012-failed-with-win32-error-0x03e3

Hi MBall2222,

According to your description, after you migrate the report from SSRS 2005 to SSRS 2012, when you run the report, sometimes, the status code: 12019 or 500 is return, right?

Based on my research, regarding the error Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 12019, the issue can be caused by that the lad balancer is timing out the connection after a period of time because the timeout value on load balancer is set to a specific time value. In your scenario, please check if you have specified the value for load balancer. If that is a case, please increase the timeout value on load balancer.

Regarding the error Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500, the issue can be caused by that you have apply the patch MS11-100 .Net Framework Security Update (KB 2656355). Applying this update limits the maximum number of form keys, files and JSON members to 1000 in a request. An ASP.NET request that has lots of form keys, files, or JSON payload fails with an exception and returns a 500 HTTP status code. For more information, please refer to this KB article: An ASP.NET request that has lots of form keys, files, or JSON payload members fails with an exception.

Besides, would you please run the report witch cost less time to render, then check if the same error throws out? If the error only occur when the report takes long time to render, please try to optimize the report to improve report performance. Please refer to this article: Troubleshooting Reports: Report Performance .

If you have any question, please feel free to ask.

Best regards,
Qiuyun Yu