After create a new Team Project, why always have reporting services error

Reporting Services Error

---

• An error has occurred during report processing. (rsProcessingAborted) Get Online Help
  • Query execution failed for data set 'WorkItemTypeParam'. (rsErrorExecutingCommand) Get Online Help
    • For more information about this error navigate to the report server on the local server machine, or enable remote errors

  ---

  SQL Server Reporting Services

Hi Jiajia,

It sounds like the warehouse isnt populated yet. Please check the event log on your application tier for warnings/errors from TFS Warehouse. Are you seeing anything there?

Thanks,

Mauli

hi Mauli,

First thank you for the reply. But I have a stupid question, where is TFS warehouse?

jiajia

Hi Jiajia,

TFSWarehouse is a database on your data tier (the machine that contains the SQL Server for the databases for work items, build, version control).

Specifically, it would be helpful to know if you're seeing any errors in the event viewer on your application tier with source = "TFS Warehouse". To open the event viewer, type eventvwr.msc into a command window and click on "Application" in the window.

Thanks!
Mauli

I reported the same error in my thread http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=753326&SiteID=1 but was not yet able to resolve this problem

" 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 ?"

Hi Mauli,

A collegue have found a way to solve the problem. He set the three default user tfssetup, tfsservoce amd tfsreports as administrator. it seems working. What do you think? is it the right way to do it?

Thank you

Jiajia