AnsweredAssumed Answered

Phantom E-mails to Deleted User

Question asked by Brian Dalton on Apr 23, 2013
Latest reply on Apr 24, 2013 by Jim Sculley

Like • Show 0 Likes0
Comment • 5

I have a couple of transitions that send automatic notifications (via transition actions) to user groups. An employee recently left the company, and I removed his user account from all groups, then deleted it. I also removed his email address from my Outlook contacts and from any distribution lists within Outlook.

Strangely enough, whenever files go through the aforementioned transitions, EPDM insists on attempting to send him an email, which invariably gets bounced back to me (his account has been deleted from our Exchange Server as well, of course).

Does anybody have an idea of how EPDM could be sending an email to a user that has been deleted from the system?

Charley Saint Apr 23, 2013 4:04 PM

Correct Answer

Brian,

I've seen this before, you need to delete the email address out of the users table in the SQL database, just run this query.

UPDATE Users

SET Email = ''

WHERE (Enabled = 'False')

See the reply in context

No one else had this question

Outcomes

Charley Saint Apr 23, 2013 4:04 PM

Brian,

I've seen this before, you need to delete the email address out of the users table in the SQL database, just run this query.

UPDATE Users

SET Email = ''

WHERE (Enabled = 'False')

Actions

Joy Garon @ Charley Saint on Apr 23, 2013 4:23 PM

Brian -

Be aware that database updates are not sanctioned by SolidWorks unless directed to do so by Tech Support :-)

As always - do a backup first. (I speak from experience) I once ran an 'update' on a sandbox vault and I missed the critical WHERE line in my cut and paste....yes, it was ugly :-)

Joy

Actions

Brian Dalton @ Charley Saint on Apr 23, 2013 4:54 PM

Thanks for the tip, Charley. It's only an annoyance for now, so I'll contact VAR for authorization to fix when time allows.

Actions

Jim Sculley @ Brian Dalton on Apr 24, 2013 9:58 AM

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.

Actions

Tim Webb Apr 23, 2013 4:31 PM

Brian,

Have experienced this before. What Charley recommends is accurate. What Joy cautions on is sound advice.

Actions

5 Replies

Charley Saint Apr 23, 2013 4:04 PM
Unmark Correct
Correct Answer
Brian,

I've seen this before, you need to delete the email address out of the users table in the SQL database, just run this query.

UPDATE Users
SET Email = ''
WHERE (Enabled = 'False')
Like • Show 0 Likes0
Actions
- Joy Garon @ Charley Saint on Apr 23, 2013 4:23 PM
  Mark Correct
  Correct Answer
  Brian -
  
  Be aware that database updates are not sanctioned by SolidWorks unless directed to do so by Tech Support :-)
  As always - do a backup first. (I speak from experience) I once ran an 'update' on a sandbox vault and I missed the critical WHERE line in my cut and paste....yes, it was ugly :-)
  
  Joy
  Like • Show 0 Likes0
  Actions
- Brian Dalton @ Charley Saint on Apr 23, 2013 4:54 PM
  Mark Correct
  Correct Answer
  Thanks for the tip, Charley. It's only an annoyance for now, so I'll contact VAR for authorization to fix when time allows.
  Like • Show 0 Likes0
  Actions
  - Jim Sculley @ Brian Dalton on Apr 24, 2013 9:58 AM
    Mark Correct
    Correct Answer
    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.
    Like • Show 0 Likes0
    Actions
Tim Webb Apr 23, 2013 4:31 PM
Mark Correct
Correct Answer
Brian,

Have experienced this before. What Charley recommends is accurate. What Joy cautions on is sound advice.
Like • Show 0 Likes0
Actions

Phantom E-mails to Deleted User

Outcomes

Related Content

Recommended Content