Create team project failed: Task "Queries" from Group "WorkItemTracking" failed

Question

When I create a new team project with my web application via power tools command line I got error like:

Event Description: TF30162: Task "Queries" from Group "WorkItemTracking" failed
Exception Type: Microsoft.TeamFoundation.Client.PcwException
Exception Message: Team Foundation Server encountered an error creating the query My Work Items from C:\Windows\TEMP\TPW_tmpAB9B.tmp\WorkItem Tracking\Queries\My Work Items.wiq
Stack Trace:
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.Execute(ProjectCreationContext ctxt, XmlNode taskXml)
   at Microsoft.VisualStudio.TeamFoundation.ProjectCreationEngine.TaskExecutor.PerformTask(IProjectComponentCreator componentCreator, ProjectCreationContext context, XmlNode taskXml)
   at Microsoft.VisualStudio.TeamFoundation.ProjectCreationEngine.RunTask(Object taskObj)
--   Inner Exception   --
Exception Message: Team Foundation Server encountered an error creating the query My Work Items from C:\Windows\TEMP\TPW_tmpAB9B.tmp\WorkItem Tracking\Queries\My Work Items.wiq (type WitPcwFatalException)

Exception Stack Trace:    at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.WitPcwTask.QueryTask.AddQuery(String name, String fileName, String path, QueryFolder parent)
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.WitPcwTask.QueryTask.ParseQuery(XmlNode node, String parentPath, QueryFolder parent, Boolean execute)
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.WitPcwTask.QueryTask.Parse(Boolean execute)
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.WitPcwTask.QueryTask.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: TF51005: The query references a field that does not exist. The error is caused by «[System.Id]». (type InvalidQueryTextException)

Exception Stack Trace:    at Microsoft.TeamFoundation.WorkItemTracking.Client.StoredQuery.ValidateWiql(WorkItemStore store, String queryText)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.QueryDefinition.SetQueryTextWithValidation(String queryText)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.QueryDefinition..ctor(String name, String queryText, QueryFolder parent)
   at Microsoft.VisualStudio.TeamFoundation.WorkItemTracking.WitPcwPlugin.PcwPluginComponentCreator.WitPcwTask.QueryTask.AddQuery(String name, String fileName, String path, QueryFolder parent)

Inner Exception Details:

Exception Message: TF51005: The query references a field that does not exist. (type SyntaxException)

Exception Stack Trace:    at Microsoft.TeamFoundation.WorkItemTracking.Client.Wiql.NodeFieldName.Bind(IExternal e, NodeTableName tableContext, NodeFieldName fieldContext)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.Wiql.Node.BindChildren(IExternal e, NodeTableName tableContext, NodeFieldName fieldContext)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.Wiql.NodeFieldList.Bind(IExternal e, NodeTableName tableContext, NodeFieldName fieldContext)
   at Microsoft.TeamFoundation.WorkItemTracking.Client.Wiql.NodeSelect.Bind(IExternal e, NodeTableName tableContext, NodeFieldName fieldContext)

But if I create team project in team explorer the team project will be created successful. Anybody have any idea why cause the error? The process template is same and had no any update.

Answer 1

Hi Tracy,

Thank you for your post.

Seems use team explorer create team project is ok, use your web application to run tf command create team project failed. If I have misunderstood anything, please free feel to let me know.

What's the version of TFS, VS?
What process template you use to create team project?
Do you make some change to the process template?
What's result to create a team project when use another process template?

Regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi Lily_Wu

Thanks for you reply.

The version of TFS is TFS2010 and VS is VS2010 and the process template we have made some changes in work items. But this web application has been used for three months and created several team projects. I created several times and not only failed at "Queries", Occasionally the creation failed at firtst "Uploading work item type". I found when run the command line "tfpt createteamproject copy the process template folder to "c:\windows\temp" in TFS server, but I couldn't find any files have the field definition. Is there a  possible that the disk has no enough space to copy or download files? I found that only 3% free space in the my drive C. Any idea or suggestion?

Regards

Answer 3

Hi Tracy,

Thank you for your question.

I am trying to involve someone familiar with this topic to further look at this issue. There might be some time delay. Appreciate your patience.

Thank you for your understanding and support.

Best regards,

---

Lily Wu [MSFT]
MSDN Community Support | Feedback to us

Answer 4

1. Is this failure occurring only on a single machine (have you tested with another machine)?
2. When you created the team project from team explorer, was it from the same box?
3. You can run process monitor and see where the files are getting generated/stored.
http://technet.microsoft.com/en-us/sysinternals/bb896645.aspx

---

Trevor Hancock (Microsoft)
Please remember to "Mark As Answer" the replies that help.