Background Information
When a project manager cancels a task by removing the
resources assigned to the task, and publishes the changes to Project Server,
each resource’s timesheet page displays a large X indicator to the left of the
task name in Project Web Access. Note:
Cancelled tasks also appear on the View resource assignments page in Project Web
Access as well.
Resolution
Users can delete cancelled tasks from their timesheets
in Project Web Access by selecting a task and clicking the Hide button on the
toolbar above the timesheet grid. This approach hides the cancelled task but
does not remove it from the Project Server database.
To completely remove cancelled tasks from the Project
Server database, the Project Server administrator can run the following SQL
Server script:
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
)
If the Project Server administrator wants to view a
list of cancelled tasks before deleting them, he/she can run the following SQL
Server query:
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