BlackBerry Professional Software - unable to delete user...

[wellnomics]

Hello everyone,

I am a new BlackBerry Administrator and have just been handed BlackBerry Professional Software as the 'new' BES from Vodafone NZ. Not many people seem to have used it yet (even the guys providing support to Vodafone customers!), but looking at the folder if self-extracts to it might be equivalent to BES 4.1.4. Indeed, the Help / About from BlackBerry Manager says '4.1.4.15', however the Home screen says 'BlackBerry Professional Software Version: 4.1.4.2'.

Anyway, my issue is that I have previously added a user to our single user license and, having had issues trying to set them up, had to remove them. This worked successfully once or twice, but now they are gone and the 'Number of Users' remains at 1; therefore, when I add a new user, it tells me that I do not have sufficient licences.

If I go into the user tab and search for this user, it doesn't bring up the 'not found' error (as it does with other users), however no record is actually displayed. So it seems to know it's 'in there somewhere', but does not show it.

I've read that there has previously been a 'purge deleted user' option, however I am unable to find this (despite repeated clicking!) in this version of the software.

The latest guidance from the support line was to remove and re-install, which I've done (using the same service account, but to a fresh database - hosted on a separate SQL server) and I still see one licence in use.

Does anyone have any thoughts or ideas on how I can reclaim this license or get the user removed successfully?

Many thanks in advance for your time and assistance,

Simon

[sunkast]

There is another topic on this forum that sounds very similar to this problem. Take a look. Hopefully this solves your problem.

[wellnomics]

Thanks for the input, however in this 'new version' of the 'Express' solution, it looks like they might have 'simplified' the functionality and I cannot find any purge option anywhere.

Is anyone out there using this software and able to see purge when deleting?

Simon

[chucky_b]

Look for a "User Pending Delete" tab or section. This is likely where the user is stuck.

Worse case, hack the user right out of the database....although I don't recomend this.

[leigh_d]

i'm using the blackberry professional 4.1.4.15 and don't find the purge deleted users either. have a deleted user that is stuck with my last license and i need to reassign.....

[chucky_b]

Best as I can recall, there is no "user pending delete" window on BPS, but there should be, because this is where your users are stuck.

Best option is to hack them out of the database, and then run DBClean on their mailbox.

If I remember correctly, here's the commands. Make sure you're logged into the computer that has the database on it.

-open command prompt
osql -E
1>use BESMgmt
2>select DisplayName from UserConfig
3>go

This will (should) give you an output with all the DisplayName's in your database. Locate the user in question, and then follow the next steps:

-still in the command prompt
1>use BESMgmt
2>delete from UserConfig where DisplayName=<name from last step>
3>go

1>exit

That should take care of it, if i got the field right (DisplayName). If anyone out there has SQL Enterprise Manager, and wants to check the field names in the UserConfig table in the BESMgmt database, please update us with the correct spelling, or something else that may be easier to use.

Afterwards, you should run DBClean on the user's mailbox. If you don't have DBClean, you can contact RIM to get it, plus instructions on how to run it. I assume its also somewhere here in the forums.

[chucky_b]

Oh, and I forgot to mention the reason for people getting stuck in "users pending delete".

When you delete someone off the BES, it attempts to do 2 things. First, it attempts to delete the BB Info folder off the user's mailbox. Second, it deletes the user from the database. If it is having trouble deleting the BB Info folder from the mailbox, it will never get to step 2. This is generally caused by lack of permissions to access the user's mailbox, for some reason or another. BESAdmin permissions not set up correctly, mailbox was moved/deleted or network problems are some of the common ones.

Please note, if its a permissions issue, or network problem, the steps above about hacking the user out of the database are only a stop gap measure, as it will likely be an issue again.

[jebus2012]

I found permissions to check for the BES Admin account on any additional Exchange servers in the environment.

go to your system manager > Administrative Groups > First Administrative Group > Servers >

go to the properties of the server holding the mailbox of the user with issues.

under the security tab for the server look for your BES Admin account and make sure the following items have been checked above and beyond the default inheritance

Send As
Receive As
Administer information store

after adding those permissions to the server i was able to get a user connected to my Blackberry Professional Server

[grateful]

I am having the same problem. The permissions on the bb admin account are set as above. I have the following syntax error when i try to remove the entry.




Microsoft Windows [Version 5.2.3790]
(C) Copyright 1985-2003 Microsoft Corp.

C:\Documents and Settings\Administrator.>osql -E
1> use BESMgmt
2> select DisplayName from UserConfig
3> go
DisplayName






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

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

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

---------------------------------
David L. O'Donoghue







(1 row affected)
1> use BESMgmt
2> delete from UserConfig where DisplayName=<David L. O'Donoghue>
3> go
Msg 102, Level 15, State 1, Server SERVER2, Line 2
Incorrect syntax near '<'.
Msg 105, Level 15, State 1, Server SERVER2, Line 2
Unclosed quotation mark after the character string 'Donoghue>
'.

[grateful]

I think the editor interpets the apostrophe and the period in the user name as formatting characters. Does anyone know how to fix this? Also is there a patch to put a proper purge function into this program?

[ssadowski]

Originally Posted by grateful

1> use BESMgmt
2> delete from UserConfig where DisplayName=<David L. O'Donoghue>
3> go
Msg 102, Level 15, State 1, Server SERVER2, Line 2
Incorrect syntax near '<'.
Msg 105, Level 15, State 1, Server SERVER2, Line 2
Unclosed quotation mark after the character string 'Donoghue>
'.

Try using a double-quote instead of an angle bracket, or use a single quote and escape the single quote in David's name.

I.E.

use BESMgmt
delete from UserConfig where DisplayName="David L. O'Donoghue"
go

[kparks4285]

Worked like a charm! Thanks.

osql -E

1> use BESMgmt
2> select DisplayName from UserConfig
3> go
Name Here
(1 row affected)
1> delete from UserConfig where DisplayName="name"
2> go

[AnthoUK]

Hi Guys

I am having this exact same issue, when i try the above i get the following error

C:\Documents and Settings\Administrator>osql -E
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

C:\Documents and Settings\Administrator>


I am not too clever with SQL but I am logged in as administrator and dont understand why this is happening, can anyone point me in the right direction please!?

[AnthoUK]

Originally Posted by AnthoUK

Hi Guys

I am having this exact same issue, when i try the above i get the following error

C:\Documents and Settings\Administrator>osql -E
[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

C:\Documents and Settings\Administrator>


I am not too clever with SQL but I am logged in as administrator and dont understand why this is happening, can anyone point me in the right direction please!?

I Have managed to solve this

For anyone else as stupid as me it needed the following

osql -E -S <SERVERNAME>\<DATABASENAME>

[ktecocala]

Originally Posted by kparks4285

Worked like a charm! Thanks.

osql -E

1> use BESMgmt
2> select DisplayName from UserConfig
3> go
Name Here
(1 row affected)
1> delete from UserConfig where DisplayName="name"
2> go

Thanks so much for this! Worked PERFECTLY!