Do More Than Manage
Gord Schmidt's Ideas for Doing More with Microsoft Project Server
Summary Task

The resource is owner on one or more projects and cannot be deleted

I was cleaning up an instance of Project Server today. I had deleted all but a handful of projects from the instance and had moved on to the resources. When I attempted to delete the resources (Server Settings, Delete Enterprise Objects, (Delete) Resources and Users), I received the error message "The resource is owner on one or more projects and cannot be deleted".

As it turns out, Project Server is enforcing referential integrity; that is, it will not allow you to delete the user if there are projects that reference that user. In my case, there were some users that had published project templates and other users that owned projects that were in the Archive.

Once I deleted the projects from the Archive and resaved the Templates myself, I was able to delete the final users from my list.

Posted by Gord Schmidt on Thursday, February 25, 2010 | Permalink | Resolve

Milestone