Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

Unity Connection version 9.x / Issue with users

Hi to all

We are experiencing  one issue with CUC and i need your input pls

When i tried to delete a user i recieved the below error 

Do you have a workaround about that?

Error: java.lang.NullPointerException

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

""The Most Successful People Are Those Who Are Good At Plan B""       

Please rate all useful posts Regards Chrysostomos ""The Most Successful People Are Those Who Are Good At Plan B""
1 ACCEPTED SOLUTION

Accepted Solutions
Silver

Re: Unity Connection version 9.x / Issue with users

Hello chrysostomos1980,

Here is a list of commands to run as it did not work with the extension:

First determine the object id, there are several ways to do so if one does not work or fails continue with the next command to find it out:

run cuc dbquery unitydirdb SELECT ObjectId from vw_subscriber WHERE Alias = 'davidDapeck'

run cuc dbquery unitydirdb SELECT ObjectId from vw_globaluser WHERE Alias = 'peckdaDavid'

run cuc dbquery unitydirdb SELECT ObjectId from vw_alias WHERE Alias = 'examplealiasname'

TO DELETE  (examples below):

run cuc dbquery unitydirdb execute procedure csp_subscriberdelete(pObjectId = 'objectid ofuser')

run cuc dbquery unitydirdb execute procedure csp_aliasdelete(pobjectid='ae10df94-3601-4037-3333-fc967ccda961')

run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete (pObjectId='ae10df94-3601-2222-8084fc967ccda961')

run cuc dbquery unitydirdb select * from tbl_alias where object_globaluserobjectid = 'dd662797-ee1a-4b5b-1111-845aa9c60cd3'

DELETE USER WITH PKID>>

run sql select userid, pkid from enduser where userid = '<_user_alias>'

run sql SELECT fkenduser, fkappserver  FROM enduserappservermap WHERE fkenduser = '83215248-6288-4444-87e2-db5efcca3e98'

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

If none of those work due to a reference from the subscriber mapped elsewhere run:

Used the following command to find subscriber references:

run cuc dbquery unitydirdb select * from vw_subscriberreference where objectid='user_object_id'

That's the stack i have in the meantime, check them out and let me know results.

Regards,

-sajor kcep divad

4 REPLIES
New Member

Re: Unity Connection version 9.x / Issue with users

Have you tried a differnet browser?  I have had such issues with IE11 and Java 7.

Silver

Re: Unity Connection version 9.x / Issue with users

Hello chrysostomos1980,

You can also try deleting the user via CLI by the extension:

DELETE USER BY EXTENSION

example of extension 1616

run cuc dbquery unitydirdb delete from tbl_DtmfAccessId WHERE DtmfAccessId ='1616'

-divad sajor kcep

Unity Connection version 9.x / Issue with users

Hi Guys

Thank you for the reply

I  have tried throught CLI

Result looks like this:

admin:run cuc dbquery unitydirdb delete from tbl_DtmfAccessId WHERE DtmfAccessId ='0105'

ACE_File_Lock::ACE_File_Lock: Permission denied /dev/shm/CCM_GENstatusLock_0

Rows: 1

Do you have any idea about that?

Please rate all useful posts Regards Chrysostomos ""The Most Successful People Are Those Who Are Good At Plan B""
Silver

Re: Unity Connection version 9.x / Issue with users

Hello chrysostomos1980,

Here is a list of commands to run as it did not work with the extension:

First determine the object id, there are several ways to do so if one does not work or fails continue with the next command to find it out:

run cuc dbquery unitydirdb SELECT ObjectId from vw_subscriber WHERE Alias = 'davidDapeck'

run cuc dbquery unitydirdb SELECT ObjectId from vw_globaluser WHERE Alias = 'peckdaDavid'

run cuc dbquery unitydirdb SELECT ObjectId from vw_alias WHERE Alias = 'examplealiasname'

TO DELETE  (examples below):

run cuc dbquery unitydirdb execute procedure csp_subscriberdelete(pObjectId = 'objectid ofuser')

run cuc dbquery unitydirdb execute procedure csp_aliasdelete(pobjectid='ae10df94-3601-4037-3333-fc967ccda961')

run cuc dbquery unitydirdb EXECUTE PROCEDURE csp_UserDelete (pObjectId='ae10df94-3601-2222-8084fc967ccda961')

run cuc dbquery unitydirdb select * from tbl_alias where object_globaluserobjectid = 'dd662797-ee1a-4b5b-1111-845aa9c60cd3'

DELETE USER WITH PKID>>

run sql select userid, pkid from enduser where userid = '<_user_alias>'

run sql SELECT fkenduser, fkappserver  FROM enduserappservermap WHERE fkenduser = '83215248-6288-4444-87e2-db5efcca3e98'

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

If none of those work due to a reference from the subscriber mapped elsewhere run:

Used the following command to find subscriber references:

run cuc dbquery unitydirdb select * from vw_subscriberreference where objectid='user_object_id'

That's the stack i have in the meantime, check them out and let me know results.

Regards,

-sajor kcep divad

444
Views
0
Helpful
4
Replies
CreatePlease login to create content