Resources assignmed to Summary Tasks ...

[rajanmisra]

Hi

We had to fix a few projects which had resources assigned at the
summary level.

Steps followed in fixing:

1. Saved the project file as .mpp file.
2.Deleted the project from PWA.
3.Delete the resource from the summary level in the .mpp file.
4.Published the saved .mpp file to the server.

The issue is that the actuals of the project has moved correctly , but
still it is showing unsubmitted timesheets.

Thanks and regards
Rajan

 

[Sumant]

Rajan,

Problem is just deleting a project doesn't actually "Cleans UP" everything
from web tables.

You can delete these Assignment records from the MSP_WEB_ASSIGNMENTS table
and if still you are not sure to 'delete' the assignment, you can just mark
them deleted by changing the value in WASSN_DELETED_IN_PROJ filed to "1"
i.e.
UPDATE MSP_WEB_ASSIGNMENTS
SET WASSN_DELETED_IN_PROJ = 1
WHERE WASSN_ID = < WEB-ASSIGNMENT-ID >

Such assignments will be displayed as 'deleted from project' in the timesheet.

Deleting records should not be a problem if these are part of old project,
otherwise (as these are summary items..) you should delete project - delete
assignments - re-import project.

Let me know if you still face any problem.

-Sumant