11-25-2013 07:28 AM - edited 03-16-2019 08:34 PM
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""
Solved! Go to Solution.
11-26-2013 08:00 AM
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
11-25-2013 09:52 AM
Have you tried a differnet browser? I have had such issues with IE11 and Java 7.
11-25-2013 10:00 AM
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
11-25-2013 11:11 PM
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?
11-26-2013 08:00 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide