06-25-2012 01:42 AM - edited 03-12-2019 09:49 AM
This document describes how to troubleshoot the error "An object with the SMTP address (abc@def.abcgroup.com) already exists"
Unity Connection version 8.5.1ES65.13900-65
An object with the SMTP address (abc@def.abcgroup.com) already exists.
Follow the below steps in order to resolve the above error
1. run cuc dbquery unitydirdb select object_globaluserobjectid from vw_smtpaddress where smtpaddress = abc@def.abcgroup.com
2. run cuc dbquery unitydirdb select * from vw_subscriberreference where objectid = "referenced from previous command"
3. run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete(pObjectId =referenced from previous command')
Run these commands
1. utils cuc users bulk_clean_orphans subscribers 2. utils cuc users bulk_clean_orphans mapentries
Make sure that any other user should not have this address as SMTP Proxy Address.
I tried Solution 2 but was unsuccessful.
Solution 4:-
Delete the offending user and recreate the end user voicemail account again.
Solution 3 seems to work best even on Unity 10.5.2
Solution 3 described here worked for me.
Solution 4 worked for me. Running Unity Connection 8.5.1. Thanks!
Perfect Solution 3
On the left side of the Unity Connection, under Tools, there is " SMTP Address Search"
I used it to identify the duplicate SMTP address
Solution 1 worked for me. Here are some examples:
Command #1:
run cuc dbquery unitydirdb select object_globaluserobjectid from vw_smtpaddress where smtpaddress='abc@vm.xyz.edu'
The result of this command would be:
object_globaluserobjectid
------------------------------------
162677bb-a84d-41d5-89ab-571ead7c5828
Command #2: (object id is used from above command result)
run cuc dbquery unitydirdb select * from vw_subscriberreference where objectid='162677bb-a84d-41d5-89ab-571ead7c5828'
The result of this command would be:
objectid | displayname | referencetype | referrerobjectid | referrerobjecttype |
162677bb-a84d-41d5-89ab-571ead7c5828 | dfeghij | Recipient | 1894de90-0c6f-4cfd-acbf-020709158040 | 3 |
Now, you can search with alias "defghij" in Unity Connection and edit the SMTP address with correct one.
Thanks,
Vaijanath S.
Method 3 ended up working for me. The query commands above didn't seem to work for CXN 11.5 SU5. It ended up being a user with the same name, but who seemed to have a unique smtp address than the new hire with the same name. We found the conflict eventually in the first user's SMTP Proxy Address section.
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: