Task reminders still being sent from closed projects

[Stacy]

I have 2 databases, one for the open projects and one for the closed/archived
projects. Resources are still getting task reminders even though the project
has been closed out. In the project remaining work has been set to 0, and
100% complete. I have not been able to resolve this problem, I have run a
qurey in the database and in the past it has worked. It is not clearing.
Any ideas??

Thanks,

Stacy

 

[Jack]

There is a bug in MS Project 2003. We have the latest patch and that didn't
fix it still. There are two ways to correct the problem (the first won't
really apply to you).

1. Save the project out into a local file, delete it from the server and
re-save it back into the server. This way, you flush out everything related
to that project in MSP_WEB* tables.

2. Run the following query in SQL Server to look for the problematic task
SELECT *
FROM MSP_WEB_ASSIGNMENTS
WHERE (WRES_ID IN
(SELECT WRES_ID
FROM MSP_WEB_RESOURCES
WHERE (RES_NAME = 'John Doe'))) AND
(WPROJ_ID IN
(SELECT wproj_id
FROM MSP_WEB_PROJECTS
WHERE (PROJ_NAME LIKE 'ProjectName%')))
ORDER BY TASK_ID

Change the ASSN_REM_WORK field to 0 by running an update query (add TASK_ID
in WHERE clause), or via your SQL Server Enterprise Manager.

Sad to say, you'll have to do this for every project manager that complains
about it. You can further your research by proactively looking for
discrepancies like this between the MSP_WEB_ASSIGNMENTS vs.
MSP_ASSIGNMENTS/MSP_PROJECTS/MSP_TASKS tables.

Good Luck!


-Jack

 

[Stacy]

Thanks Jack, I will give that a try.