Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SSRS Parameter dropdown receiving error: Sys.WebForms.PageRequestManagerServer.

Status
Not open for further replies.

deedv

Technical User
Feb 24, 2016
1
US
Can anyone point me in the right direction on how to either: run only the parameter values that are selected from the drop down to view the report, instead of it running all of the records or how to resolve the below error. I am using a Group By, but still have 67,000 records in the drop down, but I believe it is erroring out, because of it trying to run through so many records, so how can I have it run only the selected records in the dropdown?

The error I get is:

Sys.WebForms.PageRequestManagerServerErrorException:
An unknown error occurred while processing the request on the server. The status code returned from the server was: 500 or I get status code 12019

I receive this error from the Report Server. The report runs fine from Report Manager and Report Builder.

And, I already added these lines to the Report Servers web.config file:

<appSettings>
<add key="aspnet:IgnoreFormActionAttribute" value="true" />
<add key="aspnet:MaxHttpCollectionKeys" value="100000" />
</appSettings>

I also added these lines but had to remove them:
<system.web.extensions>
<scripting>
<scriptResourceHandler enableCompression="false" enableCaching="true"/>
</scripting>
</system.web.extensions>

Gave me an error in the ReportServer page, I get "The Website Cannot Display the Page", so I had to take those lines out.
Any help is appreciated.

My other 2 reports use the same syntax and they do not have any errors (although there are not as many records being returned in those), but this report is causing the error.

I also should add that in the vendor query, if I put Top (1000) after the Select, then I have no issues or errors with running the report.

Let me know what code you would need to help me in figuring out what the issue is.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top