solving sql server problems for millions of dbas and developers since 2006



SQL Server DBA Tips SQL Server Developer Tips SQL Server Business Intelligence Tips SQL Server Career Tips SQL Server Whitepapers SQL Server Tools SQL Server Webcasts SQL Server Questions and Answers SQL Server Questions and Answers













SSRS report throwing run time error from report manager

Asked 2/9/2012 1:44:50 AM by Romil Nagrani

Hello,

When i am running few reports that have 3+ parameters having many values (>100) then sometime the report is throwing the runtime error as described below;

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; InfoPath.2; MS-RTC LM 8; .NET CLR 2.0.50727; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729; .NET4.0C; .NET4.0E)
Timestamp: Wed, 8 Feb 2012 14:34:12 UTC


Message: Sys.WebForms.PageRequestManagerServerErrorException: An unknown error occurred while processing the request on the server. The status code returned from the server was: 500
Line: 5
Char: 62099
Code: 0
URI: http://pit-as-sqldbp03/Reports/ScriptResource.axd?d=LSM-sIjIq1I3gqXWAV4-sDoSzT66sEJz0Rf8Iko-xIr2Gk6IIEtfrAeXLKMBVKsD2PT8EUa4dck9Tp5I-r0TEVxM92WQtwDjvg68Dmnv4K3LrV1y76r-Wu_gAfNLZfJynNkH3Pmt7ock4K7L4NUbzk8TrdU1&t=ffffffff8dc250fc


I googled this for SSRS and got one link http://www.sqlservercentral.com/Forums/Topic1245595-150-1.aspx that says that it could be caused due to data-type exceeding its limit

Can anyone help me for this? What is the cause & solution of the problem causing such error??

Please help me!!!



Answered 2/9/2012 2:22:27 AM by Romil Nagrani (0) vote answer is useful vote answer is NOT useful

 

Not a single comment???


Answered 2/9/2012 1:06:38 PM by Jeremy Kadlec (0) vote answer is useful vote answer is NOT useful

Romil,

Let me see if anyone on the team can help out.

Thank you,
Jeremy Kadlec



Post an Answer

Keep it clean and stay on the subject or we may delete your comment.
Your email address is not published. Required fields are marked with an asterisk (*)

*Name   *Email   Notify for updates
Comments
*Enter Code refresh code


 
Sponsor Information
Find and fix SQL Server problems before they happen - SQL diagnostic manager now with predictive analysis!

Time-strapped database professionals use SQL Monitor to look after their servers. Try it online.

Need SQL Server help and not sure where to turn? Reach out to the Edgewood consultants for a Health Check.

Free Trial: Get Proactive Insight with SpotlightŪ for SQL Server Enterprise.

Join the over million SQL Server Professionals who get their issues resolved daily.

Learn SQL Server 2012, Performance Tuning, Development, Administration, Replication and more - free webcasts


Copyright (c) 2006-2012 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | user groups
Some names and products listed are the registered trademarks of their respective owners.


Edgewood Solutions LLC | MSSharePointTips.com | MSSQLTips.com