a·gen·tic a·gil·i·ty

Upgrading to TFS 2010 Beta 1 and SQL Collation

TL;DR; Explains issues upgrading from TFS 2008 to TFS 2010 Beta 1 due to SQL Server collation conflicts, error messages, and the need to align collation settings.

Published on
2 minute read
Image
https://nkdagility.com/resources/NdEr9LWJ2ti
Subscribe

I have just finished installing TFS 2010 beta 1 and doing an upgrade of out TFS 2008 data. This did not go well…

Due to a collation mismatch between my original SQL Server 2005 and my new SQL Server 2008 I received an error when upgrading…

[Error  @13:57:23.665] TF255184: An error occurred during operation.  Message=Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.. Exception=.
[Error  @13:57:23.681] TF254026: An error occurred during the following operation: Upgrade. The error occurred during the following step group: Upgrade.TfsTeamBuild. It occurred on the following step: Check In Build Process Templates. The following message was returned: Cannot resolve the collation conflict between “SQL_Latin1_General_CP1_CI_AS” and “Latin1_General_CI_AS” in the equal to operation.
Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1..
[Info   @13:57:23.681] CollectionServicingMonitor - [5/25/2009 2:56:55 PM] Servicing step Check In Build Process Templates failed. (ServicingOperation: Upgrade; Step group: Upgrade.TfsTeamBuild)

And then the roll back of the transaction did not quite work as expected, so although the TFS Administration does not know about my OldTfs2008Test1 project collection.

Upgrading to TFS 2010 Beta 1 and SQL Collation

My client has it listed but with a TF31001 error.…

Upgrading to TFS 2010 Beta 1 and SQL Collation

Solution? Suck it up and reinstall everything, including SQL and change the collation to the same on both servers. :(

Technorati Tags: ALM   TFS 2010   TFS 2008

Smart Classifications

Each classification [Concepts, Categories, & Tags] was assigned using AI-powered semantic analysis and scored across relevance, depth, and alignment. Final decisions? Still human. Always traceable. Hover to see how it applies.

Subscribe

Connect with Martin Hinshelwood

If you've made it this far, it's worth connecting with our principal consultant and coach, Martin Hinshelwood, for a 30-minute 'ask me anything' call.

Our Happy Clients​

We partner with businesses across diverse industries, including finance, insurance, healthcare, pharmaceuticals, technology, engineering, transportation, hospitality, entertainment, legal, government, and military sectors.​

Flowmaster (a Mentor Graphics Company) Logo

Flowmaster (a Mentor Graphics Company)

Sage Logo

Sage

Big Data for Humans Logo

Big Data for Humans

Xceptor - Process and Data Automation Logo

Xceptor - Process and Data Automation

Freadom Logo

Freadom

Qualco Logo

Qualco

Graham & Brown Logo

Graham & Brown

Lockheed Martin Logo

Lockheed Martin

Lean SA Logo

Lean SA

YearUp.org Logo

YearUp.org

Trayport Logo

Trayport

Bistech Logo

Bistech

Microsoft Logo

Microsoft

Workday Logo

Workday

Healthgrades Logo

Healthgrades

Genus Breeding Ltd Logo

Genus Breeding Ltd

Boxit Document Solutions Logo

Boxit Document Solutions

Alignment Healthcare Logo

Alignment Healthcare

Washington Department of Enterprise Services Logo

Washington Department of Enterprise Services

Department of Work and Pensions (UK) Logo

Department of Work and Pensions (UK)

Ghana Police Service Logo

Ghana Police Service

Nottingham County Council Logo

Nottingham County Council

Royal Air Force Logo

Royal Air Force

New Hampshire Supreme Court Logo

New Hampshire Supreme Court

Lockheed Martin Logo

Lockheed Martin

Higher Education Statistics Agency Logo

Higher Education Statistics Agency

Capita Secure Information Solutions Ltd Logo

Capita Secure Information Solutions Ltd

Schlumberger Logo

Schlumberger

Hubtel Ghana Logo

Hubtel Ghana

Deliotte Logo

Deliotte