Deleted Tasks still there

[Melanie]

I have been given the pleasure in cleaning up a bunch of older projects
published on the Project 2003 server. I am the new administrator on the
server picking up from someone else.

In a few of these projects tasks have been deleted from the schedule after
publishing. The assignment is still out there with the 'X' beside the task.
How can I remove these from the server to stop my phone from ringing.

In some completed projects the assignment still exists where the remaining
work is greater than zero. When opening the schedule, all tasks are 100%
complete and the remaining work on all tasks is zero. I have republished
these schedules in attempt the email madness without success.

I also am getting some pressure from assignee's on messages which there is
zero remaining time on tasks in the schedule.

I could use some help here. If you can assist I just may be able to keep my
sanity.

 

[Mark Byington]

What I have found is that IF ther task has not already been deleted from
Project Professional, the Team Member can select the task in PWA, the click
'Reject' at the top of the column. This notifies the PM and stuff, removes
the task from the worksheet view and when the PM deletes it...it nicely goes
away.

But...if the task has already been deleted on the Project Prof side, and the
'X' appears in the Ind column, the only recourse that I know of at that point
is to have the team member select the task and click 'hide' at the top of the
column. This will 'hide' the task.

At least...this is how I've seen it work. Someone else may have a better
explanation.

 

[Melanie]

Unfortunately the tasks were deleted from the schedule after publishing the
assignments. Microsoft is working on a way to assist in this issue.

 

[Dale Howard [MVP]]

Melanie --

You can use the following SQL Server query and script to remove the deleted
tasks from your users' timesheets in PWA:

Query to see list of cancelled tasks:

select ma.WASSN_ID, mp.PROJ_NAME, ma.TASK_NAME,mr.RES_NAME, from
MSP_WEB_ASSIGNMENTS ma
join MSP_WEB_PROJECTS mp
ON ma.WPROJ_ID = mp.WPROJ_ID
join MSP_WEB_RESOURCES mr
ON ma.WRES_ID = mr.WRES_ID

where
ma.WASSN_DELETED_IN_PROJ <>0

order by 1


SQL Server script to delete cancelled task assignments from PWA timesheets:

delete from MSP_WEB_ASSIGNMENTS
where WASSN_ID IN (
select ma.WASSN_ID from MSP_WEB_ASSIGNMENTS ma
join MSP_WEB_PROJECTS mp
ON ma.WPROJ_ID = mp.WPROJ_ID
join MSP_WEB_RESOURCES mr
ON ma.WRES_ID = mr.WRES_ID
where
ma.WASSN_DELETED_IN_PROJ <>0
--AND mp.PROJ_NAME like '25713%' --uncomment it for specific project
)


Hope this helps.

 

[Mark Byington]

Thanks, Dale....I'm sure I'll use these queries in the future.

 

[Charlie]

This seems like a serious problem, judging by the number of posts related to
this. I hope that Microsoft will provide an easy way for project managers to
clean this up in the future. I will have to run the scripts periodically
to clean them up for now.

Dale, thanks for all your insight.

 

[Dale Howard [MVP]]

Charlie --

You are more than welcome for the help, my friend!