TFS2012 - 无法使用某些模板创建新的团队项目

问题描述

我们刚刚设置了一个新的 TFS2012，在使用 Scrum 2.2 和 CMMI 6.2(敏捷模板完美运行)时，不知何故创建新的团队项目已经停止工作.

We've just set up a new TFS2012, and somehow creating new team projects have stopped working when using Scrum 2.2 and CMMI 6.2 (the agile template works perfectly).

TFS 抱怨试图将不可为 NULL 的列设置为空:

The TFS is complaining about trying to set a non-NULL-able column to null:

---begin Exception entry---
Time: 2013-07-22T15:36:52
Module: Engine
Event Description: TF30162: Task "WITs" from Group "WorkItemTracking" failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: There is a problem on the server. Contact your Team Foundation Server administrator.
Stack Trace:
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.Execute(ProjectCreationContext ctxt, XmlNode taskXml)
   at Microsoft.VisualStudio.TeamFoundation.PCW.ProjectCreationEngine.TaskExecutor.PerformTask(IProjectComponentCreator componentCreator, ProjectCreationContext context, XmlNode taskXml)
   at Microsoft.VisualStudio.TeamFoundation.PCW.ProjectCreationEngine.RunTask(Object taskObj)
--   Inner Exception   --
Exception Message: There is a problem on the server. Contact your Team Foundation Server administrator. (type UnexpectedErrorException)
Exception Stack Trace:    at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore.SendUpdatePackage(XmlElement package, XmlElement& result, Boolean bulk)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.Provision.UpdatePackageOptimizer.Update(XmlElement updatePackage)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.Provision.UpdatePackageOptimizer.Submit(XmlElement rootElement)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.Provision.UpdatePackageOptimizer.Submit(Snapshot snapshot, Int32 projectId, XmlElement updatePackage)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.Provision.ProvisionClass.Submit(ActionType action, Snapshot snapshot, Int32 projectId, WITImporter importer)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.Provision.ProvisionClass.ImportValidateWorkItemTypeInternal(Int32 projectId, String methodologyName, XmlElement typeElement, ActionType action)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemTypeCollection.Import(String definition, String methodologyName)
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.WitPcwTask.WorkItemTypesTask.UploadTypeDefinition(String file, Boolean execute)
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.WitPcwTask.WorkItemTypesTask.Execute()
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.Parse(ContextWrapper wrapper, XmlNode taskXml, Boolean fExecute)
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.Execute(ProjectCreationContext ctxt, XmlNode taskXml)

Inner Exception Details:

Exception Message: Attempting to set a non-NULL-able column's value to NULL. (type SoapException)SoapException Details: <detail ExceptionMessage="Attempting to set a non-NULL-able column's value to NULL." BaseExceptionName="System.Data.SqlClient.SqlException"><details id="0" xmlns="http://schemas.microsoft.com/TeamFoundation/2005/06/WorkItemTracking/faultdetail/03" /></detail>
Exception Stack Trace:    at Microsoft.TeamFoundation.WorkItemTracking.Proxy.RetryHandler.HandleSoapException(SoapException se)
   at Microsoft.TeamFoundation.WorkItemTracking.Proxy.WorkItemServer.Update(String requestId, XmlElement package, XmlElement& result, MetadataTableHaveEntry[] metadataHave, String& dbStamp, IMetadataRowSets& metadata)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.WorkItemStore.SendUpdatePackage(XmlElement package, XmlElement& result, Boolean bulk)

--- end Exception entry ---

对我来说，定义模板的 .xml 文件似乎已更改/损坏或其他内容.但我不知道从哪里开始，因为似乎没有其他类似的问题.

To me it looks like the .xml's defining the template have been changed / corrupted or something. But I have no idea where to start, as there seem to be no other out there with similar issues.

我已经按照大多数答案的建议尝试清除缓存，但没有成功.

I've tried to clear cache as most answers suggests, but with no luck.

我完全愿意接受建议:)

I'm totally open for suggestions :)

推荐答案

更新 SQL 服务器起到了作用 (http://social.msdn.microsoft.com/Forums/en-US/c4266b7d-a221-473e-847b-ed6c04d8c03c/tf30162-task-wits-from-group-workitemtracking-failed).究竟是什么问题，我不知道 - 但现在可以使用了.

Updating the SQL-server did the trick (http://social.msdn.microsoft.com/Forums/en-US/c4266b7d-a221-473e-847b-ed6c04d8c03c/tf30162-task-wits-from-group-workitemtracking-failed). What exactly was the issue, I don't know - but it works now.

这篇关于TFS2012 - 无法使用某些模板创建新的团队项目的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！