Deleted Task still shows in PWA "View resource assignments"

[Doug]

I deleted a task using Project Pro, however the task still shows when using
Project Web Access "View resource assignments". The task does have an
exclamation icon, and does NOT have the "x" to indicate the task was deleted.

How can I force Project to correct the information in the view?

This task has no actual work

I am using Project Pro 2003 & Server.

Thanks in advance.

 

[Doug]

I have tried the SQL queries posted below. THis query did NOT find the
offending assignment.

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

 

[Vadim Bogdanov]

Hi Doug,

there's an add-on that automaticaly does this overnight.
If you need, I can send you link.

 

[Doug]

If the resource "hides" the task the problem goes away.

Doug

 

[Vadim Bogdanov]

Yes,

but if a whole project was cancelled this may take a lot of time, since only
1 task can be hidden at a time.

The add-on I told you, hides all deleted tasks for all users for all
projects.

Regards,
Vadim

 

[Torben Petersen]

Hi

I would very much like to try the add-on since i have a number of tasks that
needs to be deleted in PWA......

i am using Project 2003 if that matters.....


regards
Torben

 

[Mike Glen]

Hi Torben,

Try posting on the server newsgroup as this one is closing down. Please see
FAQ Item: 24. Project Newsgroups. FAQs, companion products and other useful
Project information can be seen at this web
address:http://project.mvps.org/faqs.htm .

Mike Glen
Project MVP