After installing TFS 2010 RC the project dashboard shows a reporting services error “Default value or value provided for the report parameter ‘StateParam’ is not a valid value. (rsInvalidReportParameter)”.
After searching for a few minutes the issue was resolved by Processing the Analysis Database.
There are 2 ways to complete this task.
Using the TFS webservice
1. Logon to the Application Tier for TFS.
2. Browse to http://localhost:8080/tfs/TeamFoundation/Administration/v3.0/WarehouseControlService.asmx or Use IIS Manager to navigate to this URL.
3. Select Process Analysis Database and Invoke a Full processing Type.
Using SQL Management Studio
1. Login to SQL Management Studio
2. Select your TFS Analysis Server under Databases.
3. Right Mouse Click on the Database and select Process.
4. Select Ok.
David Almost anything can be accomplished with applied discipline and belief. Work smarter at all times, and harder whenever necessary to power through the task!
TFS 2010 Reporting Services Error (rsInvalidReportParameter) Apr 6, 2010
Magento eCommerce Open Source Application Installation Nov 3, 2009
A Book Truly Worth Its Price. May 16, 2009
Carl P May 10 2010 - 7:46 pm
Thanks- This solved an issue I had after a fresh single server installation of TFS.
David May 10 2010 - 8:09 pm
Your Welcome! Glad to see it was useful to someone else.
Chris May 11 2010 - 9:30 am
Thanks David!!
This is a great article. Saved me hours of hassle! Cheers
Maximilian Raditya Jul 2 2010 - 9:10 am
Thank you for this! It really works.
Attila Sep 1 2010 - 6:53 pm
I do not appear to have a TFS Analysis Server database. Does this imply a problem with the installation of TFS? As far as I can tell the other parts of TFS are working just fine.
FYI SharePoint, TFS, and SQL are all running on the same box.
sevedd Sep 10 2010 - 5:31 pm
Hi Attila,
Yes you will need to have Analysis Services installed as a prerequisite for installing TFS. I would recommend downloading the TFS Installation Guide and go through all of the items for Installing Prerequisites for Team Foundation Components. The Manually Installing SQL Server for TFS section provides the requirements. Hope this helps.
Victor Gutierrez Sep 8 2010 - 10:34 pm
Thank you!!!
This is a great article.
Debarghya Oct 20 2010 - 6:57 am
Thanks a lot. It worked like a charm.
Jeff Dec 2 2010 - 4:06 pm
I got this error:
OLE DB error: OLE DB or ODBC error: A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.; 08001; Client unable to establish connection; 08001; Encryption not supported on the client.; 08001.
sevedd Dec 2 2010 - 4:49 pm
Hi Jeff,
I am not sure if you have tried a few other resolutions from the web yet, however one that I have come across is the following below from Steve St. Jean. http://sstjean.blogspot.com/2010/07/tfs-2010-rtm-… . This may not be the same for your issue, however it's worth a shot.
Nathan Mar 9 2011 - 5:03 pm
This step should be added to the TFS installation guide! Just went through a clean installation of TFS2010 RTM and of course leave it to Microsoft to not do this step for you and leave you to search the internet. Thank you for alleviating many possible hours of Report Server digging (especially when the issue was in the SSAS!)
Nick Aug 30 2011 - 11:24 am
Fantastic. Thank you for this.
Igor.Tsyselsky Oct 16 2011 - 2:38 am
Thanks a lot David.