Sql Server Reporting services error "Operation is not valid due to the current state of the object"

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Sql Server Reporting services error...

Sql Server Reporting services error "Operation is not valid due to the current state of the object"

Rate Topic

Display Mode

Topic Options

Author

Message

nari

Posted Wednesday, April 08, 2009 12:49 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, September 23, 2010 7:52 AM
Points: 2, Visits: 15

Hi,
Am getting error like "Operation is not valid due to the current state of the object" when i pass the parameters from reportview control.
Description: I am passing the report columns and query parameters as parameters form WPF winform to display those columns in SSRS report.If i reselect the parameters from WPF Form and on click of view report button am getting this error "Operation is not valid due to the current state of the object " Plz help me to solve this problem.

Post #692785

ninu

Posted Friday, January 13, 2012 3:06 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, January 25, 2013 6:08 AM
Points: 14, Visits: 63

Hi,

Were you able to solve this issue. I am facing the same problem with some of my production reports.

Thanks,
ninu

Post #1235482

Sandy Westman

Posted Wednesday, January 18, 2012 1:24 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, May 20, 2013 8:11 AM
Points: 1, Visits: 117

I was also having this issue. I found a good post that told how to add a key to the web.config file in the folder C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportManager.

<add key="aspnet:MaxHttpCollectionKeys" value="1500" />

http://social.msdn.microsoft.com/Forums/ar-SA/sqlreportingservices/thread/c9d4431a-0d71-4782-8f38-4fb4d5b7a829

Post #1238245

martin.yardley

Posted Tuesday, January 24, 2012 3:55 AM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 3:57 AM
Points: 1, Visits: 19

Hi,

I have found that Security Patch KB2656355 caused my issues.

Post #1240738

ninu

Posted Tuesday, January 24, 2012 4:05 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, January 25, 2013 6:08 AM
Points: 14, Visits: 63

Hi,

Thanks All.

I found out that microsoft patch KB2656352 caused the issue

Post #1240743

kevin.booth

Posted Tuesday, January 24, 2012 8:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, January 03, 2013 2:35 PM
Points: 8, Visits: 23

Thanks, Sandy et al. Same problem here with the patches and adding the key resolved it.

Post #1240909

Jon Russell

Posted Wednesday, February 20, 2013 12:55 PM

Old Hand

Group: General Forum Members
Last Login: Thursday, June 06, 2013 5:46 PM
Points: 326, Visits: 901

Thanks Sandy. Adding the key worked for me.

Post #1422259

cphite

Posted Saturday, May 18, 2013 8:28 AM

Valued Member

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 11:07 AM
Points: 59, Visits: 340

Adding the key worked beautifully for me; didn't even have to restart SSRS.

Post #1454264

« Prev Topic | Next Topic »

Permissions