Unable to delete user from Cisco Unity

Unable to delete user from Cisco Unity system

1. Trouble Shooting Steps

Step 1:

When checked the config found user extension assigned to old user, and user was not present in AD.

Tried to delete the user from CLI by using below Command

admin:run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete(pObjectId='a6ef1f75-253c-426f-93f6-88b5af84a788')

Key value for constraint (informix.pk_tbl_globaluser) is still being referencedot .

Command failed

Got above error and checked call routing /call handlers but didnt find anything.

Step 2:

Run the below query and found the following dependency.

admin:run cuc dbquery unitydirdb select * from vw_subscriberreference where objectid IN (select objectid from vw_subscriber where fn_tolower(alias) =fn_tolower('mary.flanders'))

objectid displayname referencetype referrerobjectid referrerobjecttype

------------------------------------ --------------- ------------- ------------------------------------ ------------------

a6ef1f75-253c-426f-93f6-88b5af84a788 AA Recipient c40fa18d-755e-40f5-b6d4-1fbd4a069a75 3

a6ef1f75-253c-426f-93f6-88b5af84a788 Receptionist Recipient 3f1ab745-40ca-4b67-8456-5041e52cbd19 3

a6ef1f75-253c-426f-93f6-88b5af84a788 mary.aRecipient 2081d266-1c83-4392-a9b8-466f391b3c23 3

Step 3:

Removed old user account from AA,Receptionist from following locations

Go to Call Management -- System Call Handlers --and select Call Handlers--choose edit --message settings

And remove associated user

Step 4:

Run the below command and deleted account from data base.

admin: run cuc dbquery unitydirdb SELECT ObjectId from vw_User WHERE Alias='mary.a' --to get the object ID

admin:run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete(pObjectId='a6ef1f75-253c-426f-93f6-88b5af84a788')

Few other cmds

----------------------

admin:run sql select userid, pkid from enduser where userid = ''

admin:run sql SELECT fkenduser, fkappserver FROM enduserappservermap WHERE fkenduser = '83215248-6288-446d-87e2-db5efcca3e98'

run sql delete FROM enduserappservermap WHERE fkenduser = '83215248-6288-446d-87e2-db5efcca3e98' and fkappserver = '67285943-ff95-4f4f-88c6-e6206cf23551