can't delete a resource

H

Hernandezz

Hi, I try delete a resource but I receive this msg:

"The resource is assignment owner for one or more resources and cannot
be deleted"


The resource is not assigned at any task and I search all projects and
he is not a assignment owner of any task. Why this error? I need to
delete the resource..

Is possible you give me a query in sql for search all assignment
owners for all tasks in all projects?

A lot of thanks,


Best regards
 
D

Dale Howard [MVP]

Hernandezz --

To determine if the resource in question is the Assignment Owner of any
task, you need to do the following:

1. Navigate to the Resource Center in PWA.
2. Click the View pick list and select the All Resources view.
3. Click the Settings menu button and select the Filter option.
4. In the Filter pane, select the AutoFilter option checkbox.
5. In the Resource Center data grid, scroll to the right until you can see
the Default Assignment Owner field.
6. In the Default Assignment Owner field header, click the AutoFilter pick
list button.
7. In the list of names on the AutoFilter pick list, select the name of the
user you want to delete.
8. If you see the user listed as the Default Assignment Owner for anyone
other than him/herself, select the open checkbox to the left of those
resources.
9. Write down the names of the resources for whom the user is the Default
Assignment Owner.

If the user is only his/her own Default Assignment Owner, you do not need to
complete the remaining set of steps in this first section.

10. Click the Edit Details button.
11. For each resource you selected in step #8, select someone else as the
Default Assignment Owner (inlcluding the selected resource), and then click
the Save and Continue button or the Save button.

If step #8 revealed the names of resources for whom the user is the Default
Assignment Owner, you need to determine in which projects the resources are
assigned. Complete the following steps in the Resource Center:

1. Make sure the option checkboxes are still selected for the resources
from step #8.
2. Click the View Assignments button.

Below each resource's name, you will see a list of projects to which the
resource is assigned.

3. Write down the names of the projects to which each resource is assigned.

After completing the above steps, you will also need to do the following

1. From step #3 in the second set of steps, open each enterprise project in
the Project Server database.
2. Apply the Resource Usage view.
3. Right click on the Work column header and select the Insert Column item
from the shortcut menu.
4. Select the Assignment Owner field and then click the OK button.
5. In the list of resources shown in the Resource Usage, find the resources
located in step #9 in the first set of steps.
6. Change the Assignment Owner to someone other than the user (inlcuding
the name of the resource assigned to the task).
7. Save the project and publish the latest schedule changes.

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top