tfs - 安装 TFS 2012 Update 1 时出错 - dbo.typ_BuildControllerTableV2 与 dbo.typ_BuildControllerTable 不兼容

Question

我刚刚在 TFS2012 服务器上下载并安装了 Team Foundation Server 2012 Update 1，现在无法配置构建 Controller 或编辑构建定义。

我从这里下载了更新:Team Foundation Server 2012 更新 1(web installer 或 1.1 GB ISO file)

然后我在我的服务器上运行安装程序，该服务器在同一个盒子上包含应用程序层和数据层。

然后我在另一台服务器(构建 Controller 和构建代理)上运行安装程序。它要求我重新配置构建 Controller ，但向导失败并出现以下错误:

当我查看应用程序层的事件日志时，我看到以下错误:

Detailed Message: TF30065: An unhandled exception occurred.

Web Request Details
    Url: http://tfs.contoso.com:8080/tfs/Collection/Build/v4.0/AdministrationService.asmx [method: POST]
    User Agent: Team Foundation (TfsMgmt.exe, 11.0.51106.1, Other, SKU:9)
    Headers: Content-Length=405&Content-Type=application%2fsoap%2bxml%3b+charset%3dutf-8&Accept-Encoding=gzip&Accept-Language=en-AU&Expect=100-continue&Host=tfs.contoso.com%3a8080&User-Agent=Team+Foundation+(TfsMgmt.exe%2c+11.0.51106.1%2c+Other%2c+SKU%3a9)&X-TFS-Version=1.0.0.0&X-TFS-Session=21fd1d52-8afa-455c-bcc8-32ee83fa39a2%2c+AddBuildControllers&SOAPAction=%22http%3a%2f%2fschemas.microsoft.com%2fTeamFoundation%2f2010%2fBuild%2fAddBuildControllers%22
    Path: /tfs/Collection/Build/v4.0/AdministrationService.asmx
    Local Request: False
    Host Address: 192.168.1.100
    User: DOMAIN\TFSBUILDSVC [authentication type: NTLM]

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)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.TranslateException(SqlException sqlException)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(Exception exception)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
   at Microsoft.TeamFoundation.Build.Server.DataAccess.AdministrationComponent.AddBuildControllers(IList`1 controllers)
   at Microsoft.TeamFoundation.Build.Server.TeamFoundationBuildResourceService.AddBuildControllers(TeamFoundationRequestContext requestContext, IList`1 controllers)
   at Microsoft.TeamFoundation.Build.Server.AdministrationWebService4.AddBuildControllers(List`1 controllers)

Inner Exception Details:

Exception Message: Operand type clash: dbo.typ_BuildControllerTableV2 is incompatible with dbo.typ_BuildControllerTable (type SqlException)
SQL Exception Class: 16
SQL Exception Number: 206
SQL Exception Procedure: 
SQL Exception Line Number: 1
SQL Exception Server: tfsdata.contoso.com
SQL Exception State: 3
SQL Error(s):

Exception Data Dictionary:
HelpLink.ProdName = Microsoft SQL Server
HelpLink.ProdVer = 11.00.2100
HelpLink.EvtSrc = MSSQLServer
HelpLink.EvtID = 206
HelpLink.BaseHelpUrl = http://go.microsoft.com/fwlink
HelpLink.LinkId = 20476


Exception Stack Trace:    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)

Answer 1

TF30040: The database is not correctly configured.

首先，此错误消息表明服务器上安装的二进制文件与数据库架构之间的架构/版本不匹配。

坏消息是这是服务器的缓存错误。

解决方法

好消息是，可以通过在应用程序层服务器上运行以下命令轻松解决此问题。之后，您应该能够配置构建服务器。

iisreset
net stop tfsjobagent
net start tfsjobagent

在 TFS 2012 Update 2 及更高版本中，此问题已得到修复。