Commentor Blog

When Quality Matters

Commentor A/S

When Quality Matters

Contact usSend mail

Recent comments

Disclaimer

The opinions expressed herein are my own personal opinions and do not represent my employer's view in anyway.

© Copyright 2012

Install TFS2010 with SharePoint Foundation 2010 (wss 4.0)

When installing TFS2010 (or upgrading on new hardware) with SharePoint Foundation (wss 4.0) it can not be done with the installer setting up wss. You need to install and prepare SharePoint before configuration of TFS. This can be done as described in the following blog post:

http://myalmblog.com/2010/12/20/installing-tfs2010-with-sharepoint-foundation-2010/

There is one added security setting which you might have to tweak also in SharePoint Foundation and which has been changed since wss 3.0. You need to change the security on files other than aspx to "Permissive". The default security setting is Strict, which gives you the:

 "Do you want to save this File"

when you try to access html files. E.g. the wiki.

How to change to "permissive" security is described in the following blog:

http://blog.brainlitter.com/archive/2010/05/19/sharepoint-2010-treats-pdf-and-other-file-types-as-insecure.aspx

One further note if you want to use EMC SCRUM for Team system v.3 on SharePoint Foundation 2010 and get the error:

TF249033: The site template is not available for the locale identifier (LCID). The site template name is: SCRUM

Then  apply the fix in the following post:

http://consultingblogs.emc.com/crispinparker/archive/2011/01/14/scrum-for-team-system-v3-sharepoint-2010-portal.aspx

And remember to change the powershell script line with the suggestions in the blog comments ("LiteralPath" instead of "FileName")

 

 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by jorn.floor.andersen on Wednesday, February 23, 2011 10:59 AM
Permalink | Comments (0) | Post RSSRSS comment feed

Retrieving the build history from Team Foundation Server using the Visual Studio 2010 SDK

In this short article I would like to demonstrate how to use the Visual Studio 2010 SDK to retrieve the Build History for a specific Team Project and Build Definition and retrieve the Change Sets and Work Items associated to the build. Before getting started we need to install the Visual Studio 2010 SDK.

The namespaces used in this sample are included in the following assemblies: 

  • Microsoft.TeamFoundationServer.Client
  • Microsoft.TeamFoundationServer.Build.Client -
  • Microsoft.TeamFoundationServer.VersionControl.Client
  • Microsoft.TeamFoundationServer.WorkItemTracking.Client 

 
using System;
using System.Diagnostics;
using Microsoft.TeamFoundation.Build.Client;
using Microsoft.TeamFoundation.Client;
using Microsoft.TeamFoundation.VersionControl.Client;
 
namespace BuildHistory
{
    class Program
    {
        static void Main(string[] args)
        {
            Trace.Listeners.Add(new ConsoleTraceListener());
 
            var tfs = TfsTeamProjectCollectionFactory.GetTeamProjectCollection(new Uri("[TFS SERVER URL"), new UICredentialsProvider());
            tfs.EnsureAuthenticated();
 
            var buildServer = tfs.GetService<IBuildServer>();
            var versionControl = tfs.GetService<VersionControlServer>();
 
            var buildDetails = buildServer.QueryBuilds("[TEAM PROJECT NAME]", "[BUILD DEFINITION NAME]");
            foreach (var build in buildDetails)
            {
                Trace.WriteLine("Build: " + build.BuildNumber);
 
                var changesets = InformationNodeConverters.GetAssociatedChangesets(build);
                if (changesets == null)
                    continue;
 
                foreach (var summary in changesets)
                {
                    Trace.WriteLine("Changeset Summary: " + summary.ChangesetId + " " + summary.Comment);
 
                    var changesetItem = versionControl.GetChangeset(summary.ChangesetId);
                    foreach (var file in changesetItem.Changes)
                        Trace.WriteLine("Affected file: " + file.Item.ServerItem);
 
                    foreach (var workItem in changesetItem.WorkItems)
                        Trace.WriteLine("Work Item: " + workItem.Id + " " + workItem.Title);
                }
 
                Trace.WriteLine(string.Empty);
            }
 
            Console.ReadLine();
        }
    }
}
 

I hope you found this useful 

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by christian.resma.helle on Wednesday, August 04, 2010 3:34 AM
Permalink | Comments (0) | Post RSSRSS comment feed

Problem upgrading to SQL Server (R2) before upgrading to TFS2010

When an instance of TFS2008 (or 2005) is to be upgraded to TFS2010 the SQL Server must be upgraded to 2008 (sp1) as a minimum. I expected this to be the smallest issue but the problem that:

"Rule 'Consistency validation for SQL Server registry keys' failed". The SQL Server registry keys from a prior installation cannot be modified. To continue, see SQL Server Setup documentation about how to fix registry keys.

It turned out to be a problem with the permissions for a registry key for SQL Server. Even though I tried to upgrade with an account with local admin rights there was a registry key which didn't allow access. For this particular instance it was the key:

HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\UDDI\MSSQLServer\SuperSocketNetLib\Lpc

The solution was to add the account which was used for the upgrade to have full access to this key. Probably write acces would have been sufficient.

The way to find out which key(s) it is/are is to look in the SQL Server installation log:

Folder: .\Microsoft SQL Server\100\Setup Bootstrap\LOG\ ("and then the date and time of the upgrade attempt")

Look for "System.UnauthorizedAccessException" in the Details.txt file

///Jørn

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by jorn.floor.andersen on Monday, June 14, 2010 6:25 AM
Permalink | Comments (0) | Post RSSRSS comment feed

Error: Execution of a full-text operation failed. 'Access is denied.' Creating full text index on Workitem

Error:

TFS Error 2900: Execution of a full-text operation failed. 'Access is denied.' Creating full text index on Workitem

This error (actually the generic error 29000) came when installing TFS2008 on a dual-server configuration, where the data-tier was clustered. It turned out that the SQLFullTextService was running under the TFSService account and it didn't have sufficient rights to the databases.

Resolution: 

After the TFSSerice was made sysadmin on the database and the full-text service was restarted (from within SQLServer Mangement Studio or Cluster Admin - not the Service MMC as that would have made the fulltext service to fall to the secondary node) it worked.

Currently rated 5.0 by 3 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by jorn.floor.andersen on Tuesday, December 09, 2008 6:13 PM
Permalink | Comments (8) | Post RSSRSS comment feed

Guide to upgrading TFS2005 to TFS2008

The link below is a guide to upgrading TFS2005 to TFS2008. It includes descriptions of different errors and work arounds for these found during a number of upgrades of various TFS installations. Further a number of the steps in the official upgrade guide is further detailed or corrected.

 

Team Foundation Server upgrade from 2005 to 2008.docx (35,18 kb)

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by jorn.floor.andersen on Tuesday, December 09, 2008 3:52 PM
Permalink | Comments (3) | Post RSSRSS comment feed

Materiale fra ALM seminar 13-11-2008: Projektstyring med TFS

Projektledelse med Team System 2008:

Projektledelse med Team System 2008.pdf (797,04 kb)

Projektledelse med Team System 2010:

Projektledelse med Team System 2010.pdf (383,65 kb)

Reports for VSTS 2008:

VSTS 2008 Reports.pdf (852,24 kb)

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by jorn.floor.andersen on Saturday, November 15, 2008 6:15 AM
Permalink | Comments (11) | Post RSSRSS comment feed

Tech Talk Statisk Kode analyse

TecTalken gennemgik, hvorledes Visual Studio Team System 2008's statiske analyse kan benyttes til at højne ensartetheden og kvaliteten. Det blev gennemgået hvorledes reglerne kan tilpasses og nye regler kan implemeneteres. Herudover blev der fremlagt en "hvordan kommer vi i gang strategi".

 

Powerpoint ligger i Statisk Kodeanalyse Techtalk.pptx (722,96 kb)

Og regel-eksemplerne ligger i CommentorFxCopRules.zip (9,77 kb)

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by ole.hedegaard on Wednesday, October 15, 2008 7:25 AM
Permalink | Comments (9) | Post RSSRSS comment feed

TFS web casts about TFS2008 source control features and Customizing Build

In relation to the upcomming Launch of Microsoft Visual Studio Team Foundation Server 2008 we have made a couple of web casts about new version control features and customization of builds:

http://blogs.commentor.dk/downloads/WebCast - Customisering af builds.wmv

http://blogs.commentor.dk/downloads/TFS2008 SC features.wmv

///Jørn

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by jorn.floor.andersen on Tuesday, February 19, 2008 3:08 AM
Permalink | Comments (3) | Post RSSRSS comment feed

Upgrading TFS2005 to TFS2008 - AS problem

Last week we should upgrade a TFS2005 dual server installation to TFS2008. Pretty straight forward as we didn't wanted to upgrade SharePoint services from WSS 2.0 to WSS 3.0. So the installation followed the standard upgrade guide:

1) Uninstall TFS on the data-tier server

This should actually never have been there, but is just a left-over, which the MS team doing the Setup program didn't get rid of before the release - Unfortunately it has been a source of frustration as no database team in an IT department wants anything installed on their database servers :-(

2) Installation of TFS2008 on the Application-tier.

First we had to restore the changes we had made for accessing the TFS server over SSL/Basic authentication. This to ensure that the Setup program could access the WSS and reporting services. After we had ensured access to both wss and rs we could do the upgrade-installation. The process went well untill we got the following error:

The Error: 32000 on TfsDb.exe is pretty generic, so we had to run the step from the command line and then we could actually see that it stopped in processing the cube files:

\\[AS Files folder]\MSSQL.2\OLAP\Data\TfsWarehouse.0.db\Team System.13093.cub.xml

This file was for some reason corrupted, as it ended in the middle of the XML statements. The TfsDb.exe program couldn't instantiate an object based on that. The solution was to delete the file and then process the dataware house.

 After that the upgrade was successful.

 

Currently rated 5.0 by 1 people

  • Currently 5/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by jorn.floor.andersen on Thursday, February 14, 2008 3:49 PM
Permalink | Comments (1) | Post RSSRSS comment feed

Querying Overridden Check-in Policies

In the Team Foundation Server, you can enable certain policies for checking in files. The default install will contain policies that can verify that the check-in is associated with a work item, or that unit tests were created for the changes made, etc etc. But even though certain rules were made for checking in, the user is still given the possibility to override these policies, if the user decides to override the policy then the user is prompted with a dialog, where the user can input their "reason" for ignoring such policies. This action is logged to the TFS databases.

In this article I will show you how to query the database "TfsVersionControl" and "TfsWarehouse" to get more information for the overridden check-in policy.

let's start off with openning a query to the database server that TFS uses then type in the following query:

SELECT
    'Changeset ID'=p.ChangeSetId,
    'Creation Date'=cs.CreationDate,
    'Check-in Comment'=cs.Comment,
    'Override Reason'=p.Comment,
    'Owner'=pr.Person,
    'Email'=pr.Email
FROM
    TfsVersionControl..tbl_PolicyOverride p
INNER JOIN
    TfsVersionControl..tbl_ChangeSet cs ON p.ChangeSetId=cs.ChangeSetId
INNER JOIN
    TfsVersionControl..tbl_Identity i ON cs.OwnerId=i.IdentityId
INNER JOIN
    TfsWarehouse..Person pr ON i.DisplayName=(pr.Domain+'\'+pr.Alias)
ORDER BY
    cs.ChangeSetId DESC

This query will provide you with the change set number, date, check-in comment, override reason, change set owner and email address for every overridden check-in policy.

Be the first to rate this post

  • Currently 0/5 Stars.
  • 1
  • 2
  • 3
  • 4
  • 5

Posted by christian.resma.helle on Monday, June 04, 2007 4:10 PM
Permalink | Comments (0) | Post RSSRSS comment feed