Hello all, When executing a reporting services 2008 r2 report a get the following error: Message: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 12152 Line: 5 Char: 62099 This happens after 2 to 3 minutes. When I process the report locally a the server (windows server 2008 r2) it works ok. I have searched the internet and adjusted serveral setting in the web.config of the reportserver / manager. But no succes. Anyone ideas? Thanks Gerben

Hi Gerben_S, Thanks for your question. Based on my research and past experiences, this issue may be caused by time out. According to your description, this problem happens after 2 to 3 minutes, when you processed the report locally on the server, it works fine. So I can gather that there are large amount of data being queried from the Database, right? If I misunderstand your question, please don’t hesitate to let me know. Actually, when you viewing one report from one client rather than the local server, the data being passed from server to client, this process will occupy many network resources, the data will lost if the process is time out. In order to resolve this issue, please try to increase the connection time out in my source database. Hope it helps you. If your issue still exists, please feel free to let me know. Thanks, Sharp Wang Please remember to mark the replies as answers if they help you and unmark them if they provide no help.

Can you please me know the size of the report, meaning how large data its trying to pull from DB? Can you check if the data its taking is in Data retrieving, Data processing or data rendering? Refer this for more details: http://blogs.msdn.com/b/robertbruckner/archive/2009/01/05/executionlog2-view.aspx on querying execution Logs data from report server Catalog DB. (Note: Please be careful in reading the data, as this is the Catalog DB for SSRS). As Sharp suggested, there might be some network delays which can also cause the problem. Try to do a tracert from the remote machine and check if its taking too long. There is a setting in Report Manager to increase time out, under site settings, called "Limit report processing to the following number of seconds". Try increasing this value and check. Chaitanya( Twitter | Blogs ) Any documentation bug? Tell us about it at Connect. Please feel free to add any community comments in any of the MSDN/technet articles. This posting is provided "AS IS" with no warranties, and confers no rights. The next CTP for SQL Server Code Name "Denali" is coming soon. Sign up now to be notified of the next CTP release.