When i am executing on SSRS report i am getting below error. I'm getting this error at the bottom left yellow colored exclamation mark. What could be the cause of getting this error in SSRS?? Please help! Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500Line: 5Char: 62099Code: 0

Please help! I need your valuable comments as i am stuck up in this issue.

Hi abhishek, are you executing the report from reportManager or inside a report viewer .net control?Aftab Ansari

http://forums.asp.net/t/1761246.aspx/1?SSRS+report+manager+error+Sys+WebForms+PageRequestManagerServerErrorException+

Aftab; I'm executing report from my intranet application. The report is created using SQL Server Report Builder 3.0

Devil, I have already visited the website. Thanks!

Hi Abhishek. refer this link: http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/1cf8fddd-eeea-4020-8510-c0efdf65f964 Aftab Ansari

Aftab; Your link was useful but not helpful :-( I tried what Chaitanya told: "Limit report processing to the following number of seconds". I increase the value from 1800 to 3600 and then i remove such constraint but that still throws that same error.

Hi Abhishek, i can suggest couple of things here: · check the execution time of your query from outside of the SSRS · if query is taking more than 3600 sec. you can try to set the "Do no timeout report" option in the site settings in the report manager · Try to execute the report from Report manger. there you will get more error detail if any error occurs Aftab Ansari

Thanks aftab; I have tried "Do not timeout report"option. Even that didn't worked out! I'm not sure about Report Manager. I don't know what that is. as i said before, i am using Report Builder v 3.0 for the report builder/changing in the report.

Hi abhishekgandhi, Aftab means that, you publish your report to report server, and then use http://serverName/Reports to to go into report manager to find the relevant report, and execute it to verify whether it works fine. Addtionally, if your report is verify large over 4 MB size, I would suggest you to find the web.config file both in Report Server and Report manager folder, open it and find the httpRuntime node, modify it like below( if you fail to find it just to add it): <httpRuntime maxRequestLength="1048576" executionTimeout="9000" /> Thanks, Bill Lu Bill Lu TechNet Community Support

Hi abhishekgandhi, Aftab means that, you publish your report to report server, and then use http://serverName/Reports to to go into report manager to find the relevant report, and execute it to verify whether it works fine. Addtionally, if your report is verify large over 4 MB size, I would suggest you to find the web.config file both in Report Server and Report manager folder, open it and find the httpRuntime node, modify it like below( if you fail to find it just to add it): <httpRuntime maxRequestLength="1048576" executionTimeout="9000" /> Thanks, Bill Lu Bill Lu TechNet Community Support

Hi Bill, Thanks for your reply. Can you let me know where i can find web.config files for Report Server & Report Manager. I have myself able to locate one path as c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\web.config. I'm not sure what this path is applicable for: Report Server OR Report Manager. Please let me know valid path for another option. Thanks!

Hi Abhishek, As per your shared path in above post, the applicable path for [Report Server] will be “c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\web.config” And For [Report Manager] will be “c:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportManager\web.config” You need to make the required changes in these both files as per the Bill’s suggestion in his above post. Aftab Ansari

Hello Aftab & Zilong, Thanks for the inputs. I added the maxRequestLength parameter in both the web.config files. The value that i gave was 163840 (equals to 160 MB) but that still didn't worked and throws the same error. My manager replaced the file and restarted the SSRS too. What should i do? Please help me!