TFS 2012 Update 1 Issue: Error while configuring build
[Update 2/1/13] A fix for the issues is now available.
[Update 1/14/13] See this post for the latest on a fix with attaching collections.
We’ve discovered an issue in TFS Update 1 that may result in errors when you try to configure a build agent or controller. You will see an error in the Build Service Configuration Wizard (configuring a new agent/controller) or in the TFS Administration Console (viewing the properties of a build controller/agent).
In the event log on the server, you’d find an error about the database not being configured correctly.
TF53010: The following error has occurred in a Team Foundation component or extension:
Detailed Message: TF30065: An unhandled exception occurred.
Exception Message: TF30040: The database is not correctly configured. Contact your Team Foundation Server administrator. (type DatabaseConfigurationException)
Exception Stack Trace: at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(Int32 errorNumber, SqlException sqlException, SqlError sqlError)
Exception Message: Operand type clash: dbo.typ_BuildControllerTableV2 is incompatible with dbo.typ_BuildControllerTable (type SqlException)
The workaround is to run the following commands.
- net stop tfsjobagent
- net start tfsjobagent
[Update 11/30/12] Note that this is a race condition that you may not hit and that the app pools for TFS are set to recycle every 29 hours (the Regular Time Interval setting in IIS), which will also fix this issue.
Follow me at twitter.com/tfsbuck