TFS reports finds wrong project after rename

Question

The problem is that alle the reports for a given project is now looking at a wrong team project.

In the standard reports the following query is used to determine the project:

SELECT TOP 1 p.ProjectNodeGUID, p.ProjectNodeName FROM
(
    SELECT ProjectNodeGUID, ProjectNodeName, 1 AS RowRank FROM GetProjectNodeInfoFromReportFolder(@ReportPath)
    UNION
    SELECT '00000000-0000-0000-0000-000000000000' AS ProjectNodeGUID, 'missing' AS ProjectNodeName, 0 AS RowRank
) p ORDER BY p.RowRank DESC

But it does not return the correct one.

What has happened is that I renamed a project from A to A.Old and created a new project called A. Looking at the report server, there is no folder called A.Old, only A but that actually points to A.Old.

Any idea of how to fix that?

Answer 1

If you are connecting to the Warehouse for TFS then you will need to run a rebuild of the Warehouse to have this change passed through. This is true for Project Renames, Deletes, and Collection detach/attach.

This should have been displayed in the warning message when you did the rename.

Running a rebuild from the admin console will fix this...