Deleted build definitions still are shown in build reports !

Engineering Practices – v2.2 Reports

Deleted build definitions still are shown in build reports !

ccolell 01-23-2009, 11:27
Hello,

I have deleted some build definitions from my TFS2008 project, but it seems that still are kept in the datawarehouse. Then, Scrum for Team System Build Reports , have a parameter to show to the user the build definition to filter results and deleted build definition are also shown, which is anoying.

Is there any way to delete build definitions from the datawarehose ?

Or, is there any way to change the query you have in the reports to obtain the build definitions within a project, so it will return the definition names of a project that exist but not the ones that have been deleted from Team System ?

I'm talking about this query:

WITH
SET RealBuildTypes AS
{[Build].[Build Type].[Build Type].Members - [Build].[Build Type].UNKNOWNMEMBER}

MEMBER [Measures].[ParameterCaption] AS
[Build].[Build Type].CURRENTMEMBER.MEMBER_CAPTION

MEMBER [Measures].[ParameterValue] AS
[Build].[Build Type].CURRENTMEMBER.MEMBER_CAPTION

SELECT
{
[Measures].[ParameterCaption],
[Measures].[ParameterValue]
} ON COLUMNS,
{
Filter(RealBuildTypes, [Measures].[Build Details Count])
} ON ROWS
FROM [Team System]
WHERE ( STRTOMEMBER("[Team Project].[Team Project].[" + @Project + "]") )

Best regards,

Carlos.

Carlos Colell Sorinas

Re: Deleted build definitions still are shown in build reports !

Steve Wright 01-26-2009, 1:59

Hi Carlos

Thank you for your post. Unfortunately there is currently no visible method to detect which build types have been deleted. The only way to remove data from the warehouse is as follows:

Physically delete data from the source system (Team Build, Work Item Tracking, etc..).

Using the TFS.exe or the TFS power tools.

Drop and Recreate the Warehouse

Using SetupWarehouse.exe (http://msdn.microsoft.com/en-us/library/ms400783.aspx)

Run the warehouse adapters

This will happen when warehouse is dropped and recreated.

Please be advised that this will affect all deleted data, and some history from the TFS system could be lost.

Also there is another post where some more information will be available:http://www.scrumforteamsystem.com/cs/forums/3472/ShowPost.aspx. They also have the same problem.

Regards.

Steve Wright
Technical Consultant
EMC Consulting