Since way back in the olden times before Project Server 2010, we’ve been experiencing this “Other Projects and Commitments” issue off and on.
In a Resource Usage view in Project Pro, the “Other projects and commitments” total does not match the work in the projects listed.
Below is an example, but the total can either add numbers which don’t appear, or fail to add numbers which do appear. Look for any mismatch between the total project hours and the hours supplied by the projects in the list.
We can usually fix a single instance of this by finding the offending project, replacing the resource with a local generic resource, removing the resource from the project, publishing, then replacing the local resource with the enterprise resource.
That’s the only fix I know, sadly, but I have finally found what I think might actually be the cause, and that’s somewhat exciting.
To me. Yes, I know I need a life.
I found a thread on the MS forum which points to it – http://social.technet.microsoft.com/Forums/en-US/projectserver2010general/thread/63d77cc7-4542-4a48-b821-034c516b0a81/
The poster indicates that the issue might be caused by adding a local resource with the same name as an enterprise resource, and then publishing and clicking “yes” to replace that local resource with the enterprise one.
I went back through all my notes and I can’t confirm a single user which we’ve had to fix didn’t get added that way. I know the last two instances of this were certainly set up like that from the start (it was me, I admit it!) but who knew, right?
Then I replicated it on our test server.
[EDIT: SP2 has rendered the replication steps invalid, but we still get these from time to time.]
The steps are easy:
Create a new project. Add a local resource with the same name as the enterprise resource like this:
Now assign them to a task. Give them some work. Not too much, they are very tired already. Publish, and when it asks if you want to replace the resource with the enterprise one, say yes.
Now go back and change the start date of the task you assigned Mr. Obama to. (ok, I doubt he’s really in your resource pool) Publish.
Go scroll around and compare the “other projects and commitments” total to the projects on the list there.
See any bad math? Here’s the weird part – I can replicate this on my test server, but not on the prod server. There, it seems intermittent.
For now, we’ll instruct our PMs to not do that anymore, but ultimately, I intend to get this feedback to MS so that maybe they can actually figure this out. It’s got to be a lot easier to troubleshoot when you can replicate it, right?