Missing TfsReportDS and TfsOlapReportDS

Some time ago I noticed that the Reports folder in Team Explorer had a red x in the lower right hand corner and would not expand to show reports. Since I was not really using them yet I just ignored this error. Today I tried to create a new project and received this error.

Error
TF30004: The New Team Project Wizard encountered an unexpected error while initializing the Microsoft.ProjectCreationWizard.Reporting plug-in.
Explanation
TF30171: The Microsoft.ProjectCreationWizard.Reporting plug-in used to create the new team project could not be initialized and returned the following error: TF30222: The New Team Project Wizard could not find the data source TfsOlapReportDS on the SQL Server Reporting Services server kpwavsts. Contact the administrator for the server and confirm that your user account has Content Manager permission to create reports. If the problem persists, contact your Team Foundation Server administrator and ask that Team Foundation Server be repaired..
User Action
Contact your Team Foundation Server administrator.

I looked in the log and found the following

2006-05-15 13:20:21Z | Module: Internal | Team Foundation Server proxy retrieved | Completion time: 1.8905645 seconds
2006-05-15 13:20:22Z | Module: Internal | The template information for Team Foundation Server "kpwavsts" was retrieved from the Team Foundation Server. | Completion time: 0.7031025 seconds
2006-05-15 13:20:27Z | Module: Wizard | Retrieved IAuthorizationService proxy | Completion time: 7.7341275 seconds
2006-05-15 13:20:28Z | Module: Wizard | TF30227: Project creation permissions retrieved | Completion time: 0.1093715 seconds
2006-05-15 13:21:40Z | Module: Engine | Thread: 16 | New project will be created with the "MSF for CMMI Process Improvement - v4.0" methodology
2006-05-15 13:21:40Z | Module: Engine | Retrieved IAuthorizationService proxy | Completion time: 0 seconds
2006-05-15 13:21:40Z | Module: Engine | TF30227: Project creation permissions retrieved | Completion time: 0.031249 seconds
2006-05-15 13:21:43Z | Module: Engine | Wrote compressed process template file | Completion time: 0 seconds
2006-05-15 13:22:26Z | Module: Engine | Extracted process template file | Completion time: 43.529857 seconds
2006-05-15 13:22:26Z | Module: Engine | Thread: 16 | Starting Project Creation for project "WAW 3.0" in domain "kpwavsts"
2006-05-15 13:22:26Z | Module: Engine | The user identity information was retrieved from the Group Security Service | Completion time: 0.124996 seconds
2006-05-15 13:22:26Z | Module: Initializer | Thread: 16 | The New Team Project Wizard is starting to initialize the plug-ins.
2006-05-15 13:22:26Z | Module: CssStructureUploader | Thread: 16 | Entering Initialize in CssStructureUploader
2006-05-15 13:22:26Z | Module: CssStructureUploader | Thread: 16 | Initialize for CssStructureUploader complete
2006-05-15 13:22:26Z | Module: Initializer | Thread: 16 | The New Team Project Wizard successfully Initialized the plug-in Microsoft.ProjectCreationWizard.Classification.
2006-05-15 13:22:27Z | Module: Rosetta | Thread: 16 | Entering Initialize in RosettaReportUploader
begin Exception entry
Time: 2006-05-15 13:22:28Z
Module: Initializer
Event Description: TF30207: Initialization for plugin "Microsoft.ProjectCreationWizard.Reporting" failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: TF30222: The New Team Project Wizard could not find the data source TfsOlapReportDS
on the SQL Server Reporting Services server kpwavsts. Contact the administrator for the server
and confirm that your user account has Content Manager permission to create reports. If the
problem persists, contact your Team Foundation Server administrator and ask that Team Foundation
Server be repaired.
Stack Trace:
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.CheckForProjectFolder(PrivateData data, String projectName, ProjectCreationContext context)
at Microsoft.VisualStudio.TeamFoundation.RosettaReportUploader.Initialize(ProjectCreationContext context)
at Microsoft.VisualStudio.TeamFoundation.EngineStarter.InitializePlugins(MsfTemplate template, PcwPluginCollection pluginCollection)
end Exception entry

2006-05-15 13:22:29Z | Module: Engine | Thread: 16 | Attempting to delete MSF folder "C:\Documents and Settings\jarrett\Local Settings\Temp\TPW_tmp75.tmp"
2006-05-15 13:22:30Z | Module: Engine | Thread: 16 | The temporary folder C:\Documents and Settings\jarrett\Local Settings\Temp\TPW_tmp75.tmp used to store the process template was removed.

I looked at the report server (http://kpwavsts/reports) and found an empty folder. Apparently I have somehow lost the TfsOlapReportDS and TfsReportDS data sources. Is there any way to get them back?

[5316 byte] By [EdJarrett] at [2008-2-25]
# 1

It is quite easy to re-create them by following these steps:
- browse to http://<ApplicationTierName>/reports
- Click on New DataSource and fill up the information

- For TfsOlapReportDS:
- Connection type: Microsoft SQL Server Analysis Services
- Connection String: Data source=DataTierMachineNameGoesHere;initial catalog=TFSWarehouse
- Credentials: Use "Credentials stored in the report server, specify your service account and its password and check the first check box: "Use as Windows credentials when connecting to the data source"

For TfsReportDS: Everything is the same except the Connection type which should be set to Microsoft SQL Server.

Also ensure that they are named exactly as specified above as these are the names used to reference them in the reports.

Thanks,
Othmane

OthmaneRahmouni-MSFT at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 2
Thanks. That has given me the ability to create a new project. Unfortunately the existing projects still do not have a functioning reports folder but I can live with that.
EdJarrett at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...
# 3

You could try altering the datasource of the existing reports in the properties tab of each report.

Just browse to the appriopriate data source in the tree view.

Kevik at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Team Foundation Server - Reporting & Warehouse...

Visual Studio Team System

Site Classified