SSRS report throwing run time error from report manager

• romil.nagrani

  Mr or Mrs. 500

  Points: 501

  More actions

  February 8, 2012 at 7:42 am

  #251160

  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!!!

• romil.nagrani

  Mr or Mrs. 500

  Points: 501

  More actions

  February 8, 2012 at 8:02 am

  #1444534

  Can anyone help me with this?

  Its urgent and i'm stuck up here. cannot go ahead with this.

• romil.nagrani

  Mr or Mrs. 500

  Points: 501

  More actions

  February 9, 2012 at 12:01 am

  #1444882

  No comments???? Please help me on this!!!

• vaswanijayesh15

  Grasshopper

  Points: 13

  More actions

  February 14, 2012 at 4:26 pm

  #1447095

  Please try the below link http://dynamicsuser.net/forums/p/42644/216380.aspx