tech·nic·al·ly agile

Upgrading to TFS 2010 Beta 1 and SQL Collation

Learn how to tackle collation conflicts when upgrading to TFS 2010 Beta 1 from TFS 2008. Discover solutions to ensure a smooth transition!

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

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 

Troubleshooting Install and Configuration
Comments

Related blog posts

No related videos found.

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.​

Hubtel Ghana Logo
Boeing Logo
Jack Links Logo
New Signature Logo
MacDonald Humfrey (Automation) Ltd. Logo
Graham & Brown Logo
Lockheed Martin Logo
Workday Logo
Cognizant Microsoft Business Group (MBG) Logo
Slicedbread Logo
Teleplan Logo
Akaditi Logo
Freadom Logo
Deliotte Logo
Philips Logo
Bistech Logo
Sage Logo
Microsoft Logo
Washington Department of Transport Logo
Royal Air Force Logo
Ghana Police Service Logo
New Hampshire Supreme Court Logo
Nottingham County Council Logo
Department of Work and Pensions (UK) Logo
Jack Links Logo
Microsoft Logo
Genus Breeding Ltd Logo
Hubtel Ghana Logo
Sage Logo
Capita Secure Information Solutions Ltd Logo