TFS 2010 Reporting Services Error (rsInvalidReportParameter)
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)”.
A brief search pointed to the resolution which is to Process 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.
About the Author
Thanks- This solved an issue I had after a fresh single server installation of TFS.
Your Welcome! Glad to see it was useful to someone else.
Thanks David!!
This is a great article. Saved me hours of hassle! Cheers
Thank you for this! It really works.
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.
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.
Thank you!!!
This is a great article.
Thanks a lot. It worked like a charm.
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.
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.
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!)
Fantastic. Thank you for this.
Thanks a lot David.