On my prodcuction server, I can only select the "Team System" cube when creating reports, while on my test server all other cubes (Code Churn, Build, etc) are also visible.

Some of the default reports (Bug Rates) are returning an error: "Query execution failed for data set 'PriorityParam'. (rsErrorExecutingCommand)"

Others like "Bugs By Priority" are working fine.

Any ideas ?

Thanks.

Code Churn, Build, etc are Perspectives based off the "Team System" cube. The information available in "Team System" is a superset of the information in Code Churn, Build, etc... These Perspectives are only available in SQL Enterprise - are you running Enterprise on your production server?

A couple questions regarding the Report error:

Are the reports not working on your production or test server?
If they are on your test server - if they are on your test server did you create projects on the server or do backup/restores?
Is there any additional text in the error (when executing the report from the same machine as the report server)?
Are the data sources for the reports the same?
From the Report Server machine browse to http://localhost/Reports
Click the folder with the same name as your project
Click a report & select the "Properties" link near the top of the page
Select "Data Sources" from the left

The data sources for both should be something like "/TfsReportDS" and "/TfsOlapReportDS".

Some answers:
- the production server is indeed a Standard Edition, the test server is a Developer Edition
- (default Agile) reports are working on test server but not on production server
- test server has lots of projects and reports are working on all of them
- production server has only 1 project.
- report error message is the following
An error has occurred during report processing. (rsProcessingAborted)
Query execution failed for data set 'PriorityParam'. (rsErrorExecutingCommand)
Query (19, 3) The ALLMEMBERS function expects a hierarchy expression for the argument. A member expression was used.
- datasource for Bug Rates report (works on test, not on production) is 'TfsReportDS' for both.

Could above errors be explained because of the Standard Edition of SQL ?

Hi Paso,

SQL Developer Edition does contain perspectives, while SQL standard does not. This web page explains that the only different between SQL Dev Edition and Enterprise is the licensing policies: http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

So it makes sense that only Team System would show up as a cube on the production server and there appear to be more on your test server.

Do the reports that shipped with TFS fail on your production server, but work on your test server?

Thanks,

Mauli

Did you upgrade your production server from beta to RTM?

See http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=366609&SiteID=1 for a possible solution to this.

No I did not upgrade from beta to RTM. Both are RTM installations. I have read the thread but because I'm not so familiar with SQL server I did want to remove the warehouse without having a second opinion.

Yes, some of them. For example "Bug Rates" fails on the production server and not on the test server while "Actual Quality vs Planned Velocity" works on both.

If you are using SetupWarehouse.exe to rebuild the OLAP cube and/or the relational warehouse, then you do not need to stop AS.

I rebuilded the warehouse first on my testserver (SQL Developer Edition, all reports were working) and this went fine. So I did the same on the production server (SQL Standar Edition), but this did not solve the problem.

All reports are working except for: Bug Rates, Bugs found Without Corresponding Tests, Related Work Items.
They all return the same error.
Query execution failed for data set 'PriorityParam'. (rsErrorExecutingCommand)
Query (19,3) The ALLMEMBERS function expects a hierarchy expresion for the argument. A member expression was used.

I did not find an error in the eventlog.

Any other suggestions or is this related to the SE-edition of SQL ?