Deleted projects still emailing resources

R

Ryan Miller

Good Afternoon

I have several projects that have been deleted from our server. We did not delete the Sharepoint Site as it still contains relevant project information as an archive

The problem is, resources are still being emailed about overdue/upcoming tasks despite the project being "gone"

Does anyone know a solution to this problem

Thank you for your assistance

Ryan
 
C

Chris

Yes I have please run the following sql scripts against your project server using sql anlayzer:

DESCRIPTION OF ISSUE:
--------------------------------------------
Email notifications being sent out aftert the task are completed

CRITERIA FOR RESOLUTION:
-----------------------------------
Please run the following scripts against your project server database

SQL script for the Reminders problem

This script needs to be run against the database in the SQL Query Analyzer.

update MSP_WEB_REMINDER_TYPES
set WRMND_QUERY=N'select A.WPROJ_ID, A.TASK_NAME, A.ASSN_START_DATE, A.ASSN_FINISH_DATE, A.ASSN_WORK, A.ASSN_REM_WORK from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P where A.WRES_ID=^0 and (^1) and A.WPROJ_ID=P.WPROJ_ID and P.WPROJ_IS_NONWORKING=0 and A.WASSN_DELETED_IN_PROJ=0 and A.WASSN_REMOVED_BY_RESOURCE=0 order by A.WPROJ_ID, A.ASSN_START_DATE'
where WRMND_TYPE_ID=11001

update MSP_WEB_REMINDER_TYPES
set WRMND_QUERY=N'select A.WPROJ_ID, A.TASK_NAME, A.ASSN_START_DATE, A.ASSN_FINISH_DATE, A.ASSN_WORK, A.ASSN_REM_WORK from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P where A.WRES_ID=^0 and (^1) and A.WPROJ_ID=P.WPROJ_ID and P.WPROJ_IS_NONWORKING=0 and A.WASSN_DELETED_IN_PROJ=0 and A.WASSN_REMOVED_BY_RESOURCE=0 order by A.WPROJ_ID, A.ASSN_FINISH_DATE'
where WRMND_TYPE_ID in (11002, 11003, 11004, 11005, 11006)

update MSP_WEB_REMINDER_TYPES
set WRMND_QUERY=N'select A.WPROJ_ID, A.WRES_ID, TASK_ID, TASK_NAME, RES_NAME, ASSN_START_DATE, ASSN_FINISH_DATE, ASSN_WORK, ASSN_REM_WORK from MSP_WEB_ASSIGNMENTS A, MSP_WEB_RESOURCES R, MSP_WEB_PROJECTS P where A.WPROJ_ID=P.WPROJ_ID and WRES_ID_MGR=^0 and (^1) and A.WRES_ID=R.WRES_ID and A.WASSN_DELETED_IN_PROJ=0 order by A.WPROJ_ID, A.WRES_ID, ASSN_FINISH_DATE'
where WRMND_TYPE_ID in (21001, 21002, 21003)

update MSP_WEB_REMINDER_TYPES
set WRMND_QUERY=N'select A.WPROJ_ID, A.WRES_ID, TASK_ID, TASK_NAME, RES_NAME, ASSN_START_DATE, ASSN_FINISH_DATE, ASSN_WORK, ASSN_REM_WORK from MSP_WEB_ASSIGNMENTS A, MSP_WEB_RESOURCES R, MSP_WEB_PROJECTS P where A.WPROJ_ID=P.WPROJ_ID and WRES_ID_MGR=^0 and (^1) and A.WRES_ID=R.WRES_ID and A.WASSN_DELETED_IN_PROJ=0 order by A.WPROJ_ID, A.WRES_ID, ASSN_START_DATE'
where WRMND_TYPE_ID=21004


Chris
 
Top