Phantom E-mails to Deleted User

This problem is mentioned in S-487531. It refers to S-036225 which does not appear to be accessible to normal users.  My VAR provided me with the text of  S-036225 when I had the same notification problem you describe:

=====================

Question: Why are SMTP email notifications still being sent to a deleted (removed) user in an Enterprise PDM vault?

Answer: This can be seen if the user was deleted from the 'Users' list via the Enterprise PDM administration tool without being removed from the group first.

This issue is submitted to our development team on SPR 487531 ""SMTP notifications still being sent to deleted user when that user was a member of a group if not removed from group before deleting user"

Workaround:
Note! Please back up the database before running this query update.
1. Open SQL management studio and log into the server.
2. Select File > Open File > load "ClearEmailForDeletedUsers.sql"
3. Select the vault database in the droplist
4. Press the execute button, or select Query > Execute

======================

The query itself just says:

UPDATE Users

SET Email = ''

WHERE (Enabled = 'False')

just as Charley Saint posted.

Rather than use the SQL script, I just edited the data directly using SQL Management studio since it was only a couple of users.

Incidentally, I have had this problem 'reappear'.  I had the problem in August 2012, updated the database and everything was fine until I removed another user a few weeks back.  The problem came back, with emails being sent to the users that were cleaned up the first time around.

Jim S.