PWA 2003 (SP2) - deleted tasks still show on 'My Tasks'

[Kurt Petteloot]

Hi,
can anyone explain why tasks that have been deleted in a project, don't
disappear from the 'My tasks' view after publishing the assignments? The
tasks do not contain any actuals, they were simply published by mistake
originally.

Any hints about how to get these tasks off the view and how to avoid these
kind of mess-ups are welcome.

Regards.
Kurt

 

[Jonathan Sofer]

Kurt,

Are they showing up with an X in the indicator field? The X indicating that
the task assignment has been deleted?

If so, you can only have the team member hide those tasks from their
timesheet.

In the future, you can have the PM first change the booking type of the
resources to proposed and re-publish the assignments. This will remove the
assignments from the team members' timesheets.

Then the PM can safely remove the tasks and re-publish the project.

Jonathan Sofer

 

[Kurt Petteloot]

Thanks for your feedback Jonathan.
The tasks do not show the 'X' to indicate that they have been deleted as I
forgot to mention in my post. I have no idea why this is and how this may
(not) have happened unfortunately.

Thanks for the tip about re-publishing with the proposed booking type. This
may come in handy later.

Kind regards
Kurt

 

[Al Ponds]

Reproducible Cause:

One possible explanation for deleted tasks showing in a team members task
view is --- A task was published to a resource by the PM and the PM delete
the resource and/or entire task before actual hours were entered. (I seen
this in managed time periods... I'm not certain about a non-managed time
period environment.)

To automate:

Below is a script I been using to remove deleted tasks from all timesheets.
Please test and verify in development first and have a dB Admin schedule this
on a recurring interval via SQL Server Agent.

----- Code Starts -----

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
)

----- Code Ends-----


Hope this helps...


Thanks,
Al

 

[Al Ponds]

The script was posted on http://www.projectserverexperts.com and the credit
goes to them.

 

[Kurt Petteloot]

Hi Al,

thanks for your reply. The possible cause you described here is more than
likely to be the one that applies here. Anyway thanks for the script. I ran
this script already on a test environment. I was reluctant to go about this
the same way on the production environment because this comes pretty close to
tampering the database. Anyway, your response gave me just that extra touch
of confirmation I was hoping for I guess . So I ran the script on the
production environment as well now.

Thanks.