TFS 2010 Beta 2 and MS Project 2007 Integration (FieldMapping.xml)

January 13, 2010 · 1 min read

I was running into an odd problem today when trying to add some new custom columns to a Microsoft Project project plan. These fields were driven by the values in other columns, in other words they calculated columns that used custom formulas I created to poluate them with content. I had added new fields to my project plan and validated and tested the formulas. Next I updated my task.xml to contain the new fields in TFS and uploaded that, then changed the FieldMapping.xml to reflect the mapping.

I had only added two new fields (and have done this many times before) so I wasn't at all worried about failure. Sure enough when I hit refresh the first time I received "TF82039: Team Foundation was unable to modify the project plan". I knew I couldn't have done anything wrong so I was worried that the fact that these columns were calculated was the issue. After much searching and no results I decided to troubleshoot a little more. I removed the mapping to one of the columns in my FieldMapping.xml and tried to refresh again. Project/TFS magically completed the process with no errors. So I went back and added the other field back in and voila, worked like charm.

I'm still not sure what the deal was, or why it let me add the one at a time. SO, if you run into this problem, try adding the new mappings one at a time. It also might help to create a tfs_msproject.log file to get the stacktrace and exception that occurs in your case.

I'll post steps to ensure that that file gets created later.

This article is part of the GWB Archives. Original Author: Matt deClercq

New on Geeks with Blogs

  • We Won The One Award I Actually Care About

    Full Scale made the Inc. 5000 for the fifth year straight, the 12th listing across my three companies. Here is why the one award you cannot buy is worth stopping for.

  • Your Customers Build the Features Now

    I let a tool I liked sit dead for a year rather than build the features I wanted. An MCP server meant I never had to, and your customers can do the same to your product.

  • Get the Size of a Directory in Linux the Easy Way

    du -sh for the quick answer, ncdu for the cleanup, df for the disk itself: every command for checking directory size in Linux, plus why du and df never agree.

  • Vim Search and Replace: The Ultimate Guide

    One :%s command replaces every match in a file before a find dialog would even open. The Vim substitute patterns worth the muscle memory: flags, ranges, capture groups, and multi-file edits.