Trouble with resource assignments not being removed

D

D Web

I'm having a bit of trouble with some resource assignments not actually being
removed from Project Server when the Project Manager removes the resource and
republishes. I'm wondering if anyone might have some suggestions regardind
what I might be able to do to clean up the situation.

Here's the scenario. Resource A was attached to roughly 10 tasks in a
project plan. The plan was saved and published. The resource was correctly
assigned to all 10 tasks.

It was then determined that Resource A would no longer be needed on the
project so the project manager completely removed Resource A from the project
and republished. Roughly 5 of the assignments have been removed (correct)
while 5 are still remaining. (incorrect)

There is no longer any trace of Resource A anywhere on the project, the
project has been republished several times and we are certain that all
updates have been accepted. No actual time was posted to any of the tasks.

Can anyone think of a reason why only some of the task assignments were
removed?

More importantly, can anyone think of a way to delete the task assignments
that are still hanging around without actually deleting the project? We've
tried re-adding the resource, publishing (resource A will get all 10
assignments again), removing the resource for a second time and republishing
with no luck.

The only actual way I've been able to remove them is to update the
msp_web_assignments table, forcing the wassn_deleted_in_proj to 1 for those
tasks. Obviously, that's a horrible option as this has already happend more
then a few times. (not to mention the fact that I'm not certain of the exact
effects of directly modifying the data myself.)

Any ideas? Thanks in advance for any assitance.
 
E

eswb10

Have you tried the clean up tools in Project Web Access? In PWA >
Admin > Clean Up Project Server Database. You can specify tasks
assigned to specific individuals. Here is a part of the help file for
that.

Under Specify the users whose items should be deleted, indicate whether
you want to delete these items for all resources or for a specific
resource in the database.
To delete items for all users, click Delete the specified task,
resource task change, and status report items for all users.
To delete items for a specific user, click Delete the specified items
for only this user, and then select the name of a user in the list.
Click Delete.

I assume that all assignments to the resource were zeroed out prior to
being removed from the project?

Mark Everett |PMP
 
D

D Web

Thanks for the reply Mark.

I did look at the admin functions for Project Server clean up but our
resources are on many different Projects. I need an option to delete all the
task assignments for a specific resource on a specific project and it didn't
appear as though i could do that from the admin functions.

As for your comment about zeroing out the tasks before removing, the tasks
are still around and there are other users assigned to the tasks. We just
needed to remove a specific resource from the task. (and it did appear to
remove that resource for some of the tasks...just not all of them)
 
E

eswb10

For the tasks that remain, with other users assigned...do those tasks
still contain any remaining work assigned to Resource A? In other
words:
Task 1 has Resource A, Resource B and Resource C assigned. Each had 20
hours of work. Change happens and Resource A isn't required. The PM
should go to each task that had Resource A assigned, delete any
assigned work and make sure that Remaining Work = 0 for Resource A.
Mark
 
E

eswb10

For the tasks that remain, with other users assigned...do those tasks
still contain any remaining work assigned to Resource A? In other
words:
Task 1 has Resource A, Resource B and Resource C assigned. Each had 20
hours of work. Change happens and Resource A isn't required. The PM
should go to each task that had Resource A assigned, delete any
assigned work and make sure that Remaining Work = 0 for Resource A.
Mark
 
Top