GenesysStack.com

How to Reinstall TFS 2015 Reports and Rebuild the reporting databases

Upgrades, running out of disk-space, admins gone rogue…there are many things that can disrupt your Team Foundation Server’s reporting databases.

Luckily, there is a fairly quick and easy way to re-install the TFS SSRS reports and rebuild the Tfs_Warehouse and Tfs_Analysis databases. As all items are boilerplate reports and generated databases.

To do this, we will work with the following components on TFS 2015 and SQL Server 2012 R2:

·         TFS 2015 SSRS Report Manager: http://Your_TFS_Machine_Name/Reports

·         Tfs_Warehouse: SQL Server Database

·         Tfs_Analsis: SQL Server Analysis Services Database

Let us start…

Step 1: Yes, you can start clean if desired.

·         TFS 2015 reports are boilerplate reports and generated databases. So losing them is recoverable.

·         This procedure assumes there are no reports loaded, and no Tfs_Warehouse and Tfs_Analysis databases.

·         Keep in mind that Tfs_Analysis is not in the “normal” SQL Server Database Engine, it is in SQL Server Analysis Services.

Step 2: Rebuild the Tfs_Warehouse and Tfs_Analsysis databases (databasi?)

1.     Run the Team Foundation Server Administration Console on your TFS Server.

2.    Click on Application Tier -> Reporting

3.    Click on Edit and ensure that all 3 tabs pass validation: Warehouse, Analysis Services and Reports

a.     Say OK to the “Ok to stop all jobs…?” warning. Keep in mind that this will cause downtime for users.

b.    Click the OK button and you will go back to Reports screen once validation passes.

4.    Click on Start Rebuild and Tfs_Warehouse and Tfs_Analysis databases will rebuild.

Step 3: Ensure the TfsReportDS and TfsOlapReportDS exist

·         You should have existing shared data source, but if they are not named according to TFS 2015 conventions, the new reports will not recognize the data source.

1.     Navigate to Report Manager at: http://Your_TFS_Machine_Name/Reports

2.    Ensure TfsReportDS exists with the following values:

a.     Data Source Type: Microsoft SQL Server

b.    Connection String: Data Source=Your_TFS_Machine_Name;Initial Catalog=Tfs_Warehouse;Integrated Security=True

c.     Click Test Connection and Apply

3.    Ensure TfsOlapReportDS exists:

a.     Data Source Type: Microsoft SQL Server Analysis Services

b.    Connection String: Data Source=Your_TFS_Machine_Name;Initial Catalog=Tfs_Analysis;Integrated Security=SSPI

c.     Click Test Connection and Apply

Step 4: Re-upload the TFS SSRS Reports

·         Ok, so now you have Tfs_Warehouse/Tfs_Analysis, but where are the reports?

·         Ensure you have the following two data sources:

·         You need to “download“ them from TFS in Visual Studio, and “upload” them to TFS SSRS Report Manager.

To download fresh SSRS report files (.rdl):

1.     Open Visual Studio and connect to your TFS Server

2.    In Team Explorer, click Settings -> Process Template Manager.

3.    In the Process Template Manager popup, select your template such as: Agile (default)

4.    Click the Download button to download all SSRS report .rdl files

To upload the SSRS report files (.rdl):

1.     Using Internet Explorer (important), open Report Manager: http://Your_TFS_Machine_Name/Reports

2.    Click TfsReports -> DefaultCollection -> Your_Collection_Name

3.    Upload reports by clicking the Upload File button -> Browse to your newly downloaded .rdl file -> Optionally click Overwrite item if it exists

 

Congrats, you have now re-installed TFS reports, reporting databases and shared data source!

Leave your comment