|
|
Engineering Practices – v2.2 Reports
Started by erlingmann at 11-30-2008 3:01 . Topic has 6 replies.
  
|
|
Sort Posts:
|
|
|
|
 11-30-2008, 3:01
|
erlingmann
Joined on 07-10-2008
Posts 4
|
Build types does not update
|
|
|
|
|
Hello. First of all, I love the new reports added in the 2.2 template sets!
But a slight problem: I renamed some of our build definitions, and on all the Build reports they now appears with both the old and the new name. I have tried everything, deleting all builds done with the old name, removed those builds from the Global list of builds, and even rebuilt the cube and processed the warehouse. But to no avail, the old names still appear on all reports under Build Type
Is there any way to fix this?
Thanks,
Erling
|
|
|
|
|
Report
|
|
|
|
|
12-04-2008, 5:48
|
Steve Wright
Joined on 02-05-2008
Egham
Posts 173
|
|
|
|
|
Hi Erling
Thank you for your post. I am sorry to hear that you are having some data issues. This sounds like the MDX filtering is not working as expected. Could you please run the following MDX query, within management studio, against your TFS warehouse cube and send me the results.
Regards
Steve Wright
Technical Consultant
EMC Consulting
|
|
|
|
|
Report
|
|
|
|
|
12-11-2008, 11:42
|
erlingmann
Joined on 07-10-2008
Posts 4
|
|
|
|
Ok, here's the list(attached)
It's only the builds listed under "PCM" I am interested in.
I wasn't allowed to upload a csv file, so the extension is txt, but it's still a CSV file :)
|
|
|
|
|
Report
|
|
|
|
|
01-02-2009, 3:22
|
Steve Wright
Joined on 02-05-2008
Egham
Posts 173
|
Re: Build types does not update
|
|
|
|
|
|
|
Hi Erling
Thank you for data. Can you also please let me know all the builds names you are currently seeing for your Team Project PCM and which ones are incorrect?
Regards
Steve Wright
Technical Consultant
EMC Consulting
|
|
|
|
|
Report
|
|
|
|
|
01-05-2009, 1:43
|
erlingmann
Joined on 07-10-2008
Posts 4
|
|
|
|
Doh. Forgot that. Sorry :)
I have attached a file where I have tagged the ones that are incorrect.
|
|
|
|
|
Report
|
|
|
|
|
01-26-2009, 2:03
|
Steve Wright
Joined on 02-05-2008
Egham
Posts 173
|
Re: Build types does not update
|
|
|
|
|
|
|
Hi Earling
Thank you for the data. The reason why you are still getting the old build types listed is because there still seems to be some build details records within the warehouse. Could you please run the following sql:
SELECT b.[Build],
b.[Build Type],
b.[Drop Location],
b.[Build Start Time],
b.[Build Artifact Moniker],
bd.[Build Duration],
bd.[Build Quality],
bs.[Build Status],
tp.[Team Project]
FROM dbo.[Build Details] AS bd
INNER JOIN dbo.[Build] AS b
ON bd.[Build] = b.[__ID]
INNER JOIN dbo.[Team Project] AS tp
ON tp.[__ID] = bd.[Team Project]
INNER JOIN dbo.[Build Status] AS bs
ON bs.[__ID] = bd.[Build Status]
WHERE b.[Build Type] IN ('1.2 Maint (CI)','1.3 Maint (CI)','H8_TC (CI)','V8_TC (CI)','V9 (CI)')
The results should list the build details records that causing a count to happen.
Regards
Steve Wright
Technical Consultant
EMC Consulting
|
|
|
|
|
Report
|
|
|
|
|
03-02-2010, 2:11
|
webhostingreviews
Joined on 03-02-2010
Washington
Posts 1
|
Re: Build types does not update
|
|
|
|
|
|
|
|
|
Scrum for Team ... » Version 2.x - T... » Engineering Pra... » Build types does not update
|
|
|
|