Project association locked

Oct 31, 2007 at 8:24 PM
After creating a project server project and associating it to an existing TFS project, I selected "Auto-create assignments from current WorkItems." No tasks were created in project server, and there is a locked icon on the project list. I'm unable to delete the association or view it in any other way.
Nov 2, 2007 at 4:55 PM

This page covers how to deal with the lock problem: http://blogs.msdn.com/lfenster/rss.xml

What I did to fix it was to go into a SQL query

First find the Project GUID for the project that is locked:

USE PS2007ProvidersDB
SELECT * FROM ProjectAssociations;


Update the IsLocked Value:

USE PS2007ProvidersDB
UPDATE ProjectAssociations SET IsLocked = '0' WHERE ProjectGuid='projectGUIDhere';