Orphan Records - getting overdue tasks email alerts on deleted tas

[ljsexton]

Does anyone know if there is a utility or some documented process for removal
of orphaned records? I am assuming this is what is causing us to get Overdue
Task Email notifications on tasks that have long been deleted.

These overdue task alerts are very helpful for valid tasks but can not use
with the number of alerts being generated for old Deleted Invalid tasks.
Suggestions/Comments would be most appreciated.
Thanks,
Jackie

 

[Kevin W Flanagan]

Was the project schedule ever republished (All Information) again after
deleting the tasks?

 

[ljsexton]

yes, several times.

Was the project schedule ever republished (All Information) again after
deleting the tasks?

 

[ad9aggie]

LJ,

I had this problem a while ago and found a script that deletes Deleted Tasks
from timesheets on this forum.

UPDATE MSP_WEB_ASSIGNMENTS
SET WASSN_REMOVED_BY_RESOURCE = 1
WHERE WASSN_Deleted_In_Proj = 1
and task_is_Summary = 0

Run this script and it will remove all Deleted Tasks from all timesheets.

I don't recall the exact explanation, but it has something to do with
disassociating the deleted task from the project itself in the timesheet view
so it still shows up after archiving or deleting the project.

Hope this helps,