Cisco unity connection 11.5 delete user error

[Bekzod Fakhriddinov]

Hi, I have a problem to add user in CUC , CUC gives error that this smtp user exist, and when i do 

:run sql select * from enduser where userid='kamisettym'    , he is in the sql table .

I tried to delete it by using pkid but getting error 4303

run sql delete   from enduser where pkid='31cb2cb5-9dd4-fde6-8256-3288848d2572'

this command  run cuc dbquery unitydirdb SELECT ObjectId from vw_User WHERE Alias = 'kamisettym'

gives no record found 

Anyone knows how to delete this user from database ? 

[Ratheesh Kumar]

Hi there

Is it like you deleted the user from CUCM and CUC still have the reference of that user. 

Lets try this,

run sql select userid, pkid from enduser where userid = 'crath'

Start with a two step process,

Remove Object ID

run cuc dbquery unitydirdb SELECT ObjectId from vw_User WHERE Alias = 'crath'

Delete User

run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete (pObjectId = 'full objectid that was returned from above query')

Also suggest you to use CUDLI. You can get the relationships of users and Objectid. Point the mouse at objectId and find out the Display name of the user. Check out the help guide for more info

http://www.ciscounitytools.com/Applications/CxN/CUDLI/CUDLI.html

Hope this helps!

Cheers
Rath!

***Please rate helpful posts***

[Bekzod Fakhriddinov · Accepted solution]

The problem was cause of his email addres was used once in another visitor account, and stupid cuc was conflict ing not allowing to add new his own account. Cisco tac found link btw email address and username, deleted it and we could add that user personal vm account, resolved