Tfs 2010附加集合错误KB2278944CollectionInstall.sql无效列名“System.AreaID”
我们有一个Tfs 2010 SP1团队项目集合，我们试图分离它并对db进行备份并重新附加它。德戴克很好。附加时我们得到了这个错误。
错误KB2278944CollectionInstall.sql第1587行错误:无效列名'System.AreaID‘。无效列名“System.IterationID”。无效的列名'ID‘。无效的列名'ID‘。无效的列名'ID‘。冲压DB..。
在深入分析日志时，我们在TFS日志的末尾看到了这个错误
[Error] KB2278944CollectionInstall.sql Line 1587 Error: Invalid column name 'System.AreaID'.
Invalid column name 'System.IterationID'.
Invalid column name 'ID'.
Invalid column name 'ID'.
Invalid column name 'ID'.
Stamping DB...
[Info @11:50:21.425] [2015-12-08 09:43:55Z][Informational] Microsoft.TeamFoundation.Framework.Server.CollectionServicingException: KB2278944CollectionInstall.sql Line 1587 Error: Invalid column name 'System.AreaID'.
Invalid column name 'System.IterationID'.
Invalid column name 'ID'.
Invalid column name 'ID'.
Invalid column name 'ID'.
Stamping DB... ---> System.Data.SqlClient.SqlException: Invalid column name 'System.AreaID'.
Invalid column name 'System.IterationID'.
Invalid column name 'ID'.
Invalid column name 'ID'.
Invalid column name 'ID'.
Stamping DB...
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.MapException(SqlException ex, QueryExecutionState queryState)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.HandleException(SqlException ex)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.Execute(ExecuteType executeType, CommandBehavior behavior)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationSqlResourceComponent.ExecuteNonQuery(Boolean bindReturnValue)
at Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteSql(String sqlScriptResourceName, String[] lines, SqlParameter[] sqlParameters)
--- End of inner exception stack trace ---
at Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteSql(String sqlScriptResourceName, String[] lines, SqlParameter[] sqlParameters)
at Microsoft.TeamFoundation.Framework.Server.SqlScriptResourceComponent.ExecuteSql(Stream sqlScriptResource, String sqlScriptResourceName, SqlParameter[] sqlParameters, Boolean retryIfLostConnection)
at Microsoft.TeamFoundation.Server.Servicing.TFCollection.FrameworkStepPerformer.ExecuteSql(String stepData, ServicingContext servicingContext, Boolean validateOnly)
at Microsoft.TeamFoundation.Framework.Server.TeamFoundationStepPerformerBase.Microsoft.TeamFoundation.Framework.Server.IStepPerformer.PerformStep(String servicingOperation, String stepType, String stepData, ServicingContext servicingContext)
at Microsoft.TeamFoundation.Framework.Server.ServicingStepDriver.PerformServicingStep(ServicingStep step, ServicingContext servicingContext, ServicingStepGroup group, ServicingOperation servicingOperation, Boolean validateOnly)
[Info @11:50:21.425] [2015-12-08 09:43:55Z] Servicing step Tfs2010RtmKB2278944Install SQL servicing step failed. (ServicingOperation: Tfs2010SP1Install; Step group: Tfs2010RtmKB2278944Install)
[Info @11:50:21.425] [2015-12-08 09:43:55Z][Informational] Clearing dictionary, removing all items.
[Error @11:50:21.425] The servicing operation failed.我试着停止和开始，分离和附加多次。重新启动的机器，什么也不能用
回答 1
Stack Overflow用户
发布于 2015-12-08 12:18:23
最后的解决方案是
进入TFS App服务器，打开命令提示符导航到Tools文件夹。
`E:\Program Files\Microsoft Team Foundation Server 2010\Tools>'运行以下命令，您将得到如下输出
TfsConfig修复
日志发送到文件C：\ProgramData\ Microsoft \ TfsConfig \服务器Configuration\Logs\CFG_SVC_UNK_ 1208_103237.log命令:修复TfsConfig-TfsConfig配置工具版权(c) Microsoft。版权所有。获取维修锁。已获得维修锁。停止申请..。应用程序已成功停止。开始申请..。成功启动应用程序。
现在进入团队管理控制台，检查名为Status的选项卡。
上面还会有一条
服务收集排队。
几分钟后，它应该说
服务收集成功
然后你就可以把收藏带到网上去了。:)
https://stackoverflow.com/questions/34155328
复制相似问题
腾讯云开发者
Copyright © 2013 - 2026 Tencent Cloud. All Rights Reserved. 腾讯云 版权所有
深圳市腾讯计算机系统有限公司 ICP备案/许可证号：粤B2-20090059 
粤公网安备44030502008569号
腾讯云计算（北京）有限责任公司 京ICP证150476号 | 京ICP备11018762号