03-09-2013 07:30 AM - last edited on 04-29-2013 11:03 AM by Chronos
Hi, i am unable to create a user because he is stuck in the database but i am unable to delete him. I think the issue occured when someone selected to delete him and erase device but the device was manually erased instead. Anyway i can see the user by running the following command "select DisplayName from UserConfig" using sqlcmd but the console does not list the user.
I've read abit about manually removing users in BES Express 5 and Blackberry Professional but the delete command does not work in BES 10.
Can anyone help me delete the user please?
Subject Title edited to reflect new topic.
Solved! Go to Solution.
03-10-2013 05:24 AM
The user was removed through BAS but the user did not completely erase from SQL, BAS can no longer see the user. This is known issue with previous versions and different flavours of BES. We've never has this issue with BES 5 though.
03-10-2013 01:25 PM
Ok. Just wanted to make sure that by manually removed you didn't mean that the user was deleted through SQL commands being manually run against a table in the database. There are occasions where artifacts are left in the database.
You likely will need to contact support to get your database analyzed to figure out why this is happening and fix it.
03-11-2013 05:29 AM
Got it! easier than i first thought, the user was queued for deletion so i did an advanced search on queued for deletion = true.
Thanks for your help!
03-11-2013 10:42 AM
To verify if BlackBerry smartphone user accounts are queued for deletion, perform the following steps:
BlackBerry smartphone users who are pending a deletion, but the process has not completed, will be displayed.
The BlackBerry smartphone user account can be purged from the database or removed immediately from the BlackBerry service by performing the following steps:
if above wont work.
If user is stuck in pending delete, you can drop user from database using the following:
1. Open command prompt
2. Type "osql -E"
3. 1>use BESMgmt
5. 1>delete from userconfig where firstname.lastname@example.org''
04-16-2013 12:41 PM
So there's a user (ME) that I removed after initial testing of my newly built BES 10 server and it's stuck in pending delete in the admin console. The SQL above isn't valid for BES 10. I show a list of users using SQL and it doesn't show me in any kind of state, active or pending delete. I've had a ticket open with Blackberry Support for 5 days now with no luck yet. I really need to add myself back so I can work from my phone again. Any suggestions? Thanks.
04-26-2013 05:19 PM
04-26-2013 05:28 PM
you posted in a BES 5 thread, and yes it wont work on BES 10
best to call in support as I have seen a few issue with delete user on BES 10
04-26-2013 05:31 PM - edited 04-26-2013 05:37 PM
No, this is in a BES 10 Forum.
BlackBerry® Enterprise Service 10
Re: User stuck in database and unable to delete hi...
But thanks for the advice to contact support