Removing cancelled tasks

[JWasmuth]

Hello,

I have a request to remove cancelled tasks as it is bothersome to see them
in the My tasks page of PWA. Apparently, when they are cancelled, they do
not show up on the project side, but still do on the PWA side. We "hide"
them, but after the Project Manager re-publishes the project, they show back
up.

I am concerned about removing these as I have absolutely no idea of the
impact on Project Server. Has anyone out there had this issue and is there
better way to "hide" these from view rather then deleting them through the
backend?

 

[Dale Howard [MVP]]

JWasmuth --

Refer to the following FAQ:

http://www.projectserverexperts.com/Shared Documents/deletecancelledtasks.htm

Hope this helps.

 

[JWasmuth]

Dale,

Thank you so much for your quick answer. It is greatly appeciated.

I wanted to verify with you that no negative impact on data integrity will
result from deleting these rows from the Project Server database. Since the
integrity is not managed from the database, I want to make sure we do not
break the application.

--
Thank you for your help!
JWasmuth

JWasmuth --

Refer to the following FAQ:

http://www.projectserverexperts.com/Shared Documents/deletecancelledtasks.htm

Hope this helps.

 

[Dale Howard [MVP]]

JWasmuth --

The process will not have a negative impact on the database integrity. It
will simply remove the cancelled tasks from each team member's timesheets in
PWA. Hope this helps.

Dale,

Thank you so much for your quick answer. It is greatly appeciated.

I wanted to verify with you that no negative impact on data integrity will
result from deleting these rows from the Project Server database. Since
the
integrity is not managed from the database, I want to make sure we do not
break the application.

 

[Joel P.]

Please confirm that this script will not affect Actuals recorded for the
associated task.

Thanks,

Joel

 

[Dale Howard [MVP]]

Joel P --

No, it will not erase actuals. It will simply remove the cancelled tasks
from each team member's timesheets in PWA. Hope this helps.

 

[ProjectAnalyst]

I've had good results using Dale's solution for the past 18 months with no
negative effects.

JWasmuth --

Refer to the following FAQ:

http://www.projectserverexperts.com/Shared Documents/deletecancelledtasks.htm

Hope this helps.