Why I receive notification of completed tasks?

[åŠæ–°ä¸æ—§]

Hi, I am using PS2007+PWA. I have a question:
- From Prj Professional, completed tasks are marked "No Pulish";
- After publish this project, thess completed tasks are removed from
"My_Tasks" list;
- But, I and my resources will still receive notification emails saying
"your assignments have been changed, please contact your PM...." etc., and
list all my completed in the email with progress 100%.
This is very upset. Can I bar this kind of notifications to such "No
Publish" marked tasks.

Thanks in advance,

JJin

 

[Dale Howard [MVP]]

JJin --

Are you current on the updates for Project Server 2007? Microsoft just
released the February 2009 cumulative update, for example. If you are
current, and you continue to see this problem, then I suspect you are seeing
one of the remaining unfixed bugs in the software. Personally, I think a
default permission for Alerts and Reminders generates an awful lot of e-mail
messages that resources soon interpret as "spam" and create a Rule in
Outlook to send the Project Server "spam" to their Recyle Bin. I personall
recommend that everyone deselect the "My project tasks are modified" option
on the Manage My Alerts and Reminders page in PWA. That would solve this
problem once and for all. Hope this helps.

 

[KimmoR]

We have encountered similar problem with Project Server 2003.

Project managers receive announcements of resources reporting hours to
already closed projects' tasks, even though they have not.

Project resource assignments have set to proposed, which should be enough to
disable time booking and notifications.

sql script:

select P.PROJ_NAME, A.TASK_NAME, A.ASSN_START_DATE, A.ASSN_FINISH_DATE
from MSP_WEB_ASSIGNMENTS A, MSP_WEB_PROJECTS P
where WASSN_ID in (select A.WASSN_ID from MSP_WEB_ASSIGNMENTS A
where A.WRES_ID = (select R.WRES_ID from MSP_WEB_RESOURCES R
where R.RES_NAME = '<resource name here>')
and A.WPROJ_ID=P.WPROJ_ID
and P.WPROJ_IS_NONWORKING=0
and A.ASSN_BOOKING_TYPE=0
and A.WASSN_REMOVED_BY_RESOURCE = 0)
order by ASSN_START_DATE

shows that the resource is still assigned to the project (as he should be,
what I know).

Project manager's notification subscription is also on:

select n.wntfy_is_enabled from msp_web_notifications n, msp_web_resources p
where p.wres_id = n.wntfy_owner_id
and n.wntfy_event_id = 1009
and p.res_name = '<project manager name here>'

Which naturally is ok, he must receive notifications of "current" projects.

Next I would like to inspect the procedure which triggers the notification
email for projects, to see if there is something which could explain this
behaviour.

Please tell me what procedure to look into?

--Kimmo

 

[Dale Howard [MVP]]

KimmoR --

I'm not a DBA, so I can't even guess an answer to your question. Please
repost this question as a new question and allow our people with DBA
experience to answer your question.

 

[KimmoR]

Thanks for your response Dale,

--Kimmo

KimmoR --

I'm not a DBA, so I can't even guess an answer to your question. Please
repost this question as a new question and allow our people with DBA
experience to answer your question.