Unity Connection version 9.x / Issue with users

[chrysostomos1980]

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""       

[rm760]

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

[davrojas]

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

[chrysostomos1980]

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?

[davrojas · Accepted solution]

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