When i am running few reports that have 3+ parameters having many values (>1000) 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
romilnagrani
Member
95 Points
78 Posts
Report is throwing runtime error from Report Manager
Feb 09, 2012 05:53 AM|LINK
Hello,
When i am running few reports that have 3+ parameters having many values (>1000) 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
Can anyone help me for this? What is the cause & solution of the problem causing such error??
Please help me!!!
SSRS sql sqlserver 2008
S/w Developer
romilnagrani
Member
95 Points
78 Posts
Re: Report is throwing runtime error from Report Manager
Feb 09, 2012 07:21 AM|LINK
Any help/comment would be a helping hand & would be greatly appreicated!
SSRS sql sqlserver 2008
S/w Developer
romilnagrani
Member
95 Points
78 Posts
Re: Report is throwing runtime error from Report Manager
Feb 10, 2012 06:48 AM|LINK
Can somebody help me with this??? At least a simple comment would help!
S/w Developer
xavier.r.fer...
Member
9 Points
8 Posts
Re: Report is throwing runtime error from Report Manager
Feb 20, 2012 07:06 AM|LINK
Hi
Are you using Mozilla browser ? If so please try with the latest IE version.
The URL length seems to exceed the limit i guess as the error is showing only for a few reports when many values are passed as parameters.
Please check and let know