Unable to add users to a BlackBerry Professional Software (BPS) installation

BrightPoint GB

BrightPoint GB

Device Lifecycle Services.

Delivered.

Plan. Market. Customize. Move. Recycle.

More...
Samsung Galaxy S III

Samsung Galaxy S III

Designed For Humans

Inspired By Nature

This sleek and innovative smartphone has the enhanced intelligence to make everyday life easier.

More...
BlackBerry Curve 9320

BlackBerry Curve 9320

Socially Connected

3G capable

Featuring all of the core messaging and social features to keep you connected.

More...
HTC One X

HTC One X

Technology Leader

Quad Core Android 4.0

Perfect for gaming, watching videos and surfing the net

More...
HTC One V

HTC One V

Iconic Design

A great all-rounder

ImageSense technology, Beats Audio, wireless media streaming, cloud storage and more...

More...
ZTE Tania

ZTE Tania

Windows Phone Mango

Fully equipped

Great for business and pleasure

More...
BlackBerry Bold 9790

BlackBerry Bold 9790

BlackBerry OS7

Powerful & Fully Featured

Smooth performance for browsing the web, running apps, working with documents, and enjoying multimedia

More...
HTC Sensation XL

HTC Sensation XL

Feel every beat

With Beats Audio

A multimedia superstar with Beats earphones included.

More...
HTC Titan

HTC Titan

Unlike anything you've ever held before

Office on the move

Windows Phone 7.5 (Mango). With a 4.7-inch screen and big virtual keyboard, the Titan is perfect for both work and play.

More...
HTC Radar

HTC Radar

Real time close

Windows Phone 7.5 (Mango)

Pull all your contacts and social networks together into one place to stay connected with friends and share instantly.

More...
BlackBerry Bold 9900

BlackBerry Bold 9900

Slim yet powerful

Touch and Type in harmony

The Bold 9900 is RIM's thinnest BlackBerry smartphone yet and as lightweight and durable as it is feature-packed.

More...
ZTE Libra

ZTE Libra

Affordable Android

WiFi hotspot, Exchange email, Google Maps and much, much more all at an attractive price.

More...
ZTE MF30/MF60

ZTE MF30/MF60

Portable Internet

USB & WiFi for Windows and Mac

High speed, portable Internet access in your pocket.

More...
Motorola Defy +

Motorola Defy +

Lifeproof

Faster, smarter, richer

Scratch, dust and water-resistant. 1GHz processor, 5MP camera and great pre-loaded apps.

More...
BlackBerry Curve 9380

BlackBerry Curve 9380

BlackBerry OS7

The 1st all-touch Curve

Easily capture and share your favourite moments with family, friends and colleagues.

More...
Samsung Galaxy S2

Samsung Galaxy S2

Faster. Slimmer. Brighter.

Prepare yourself for the Galaxy S II, Samsung's thinnest smartphone.

More...
HTC Sensation XE

HTC Sensation XE

With Beats Audio

Designed to impress

With custom Beats headphones, engineered to deliver extraordinary sound.

More...
ZTE Skate

ZTE Skate

Affordable Android

WiFi hotspot, Exchange email, Google Maps and much, much more all at an attractive price.

More...
HTC Explorer

HTC Explorer

A design that fits your lifestyle

Keep in touch with the people who matter

Jump right into what's most important to you thanks to an improved lockscreen design.

More...
ZTE Tureis

ZTE Tureis

Full Qwerty 2.6-inch touchscreen

Android Gingerbread

Business and social features in a slim package.

More...
Frontpage Slideshow (standalone) | Copyright © 2006-2011 JoomlaWorks Ltd.


Issue

When attempting to add a user to a BPS installation, an error is returned indicating that all available user licenses are already used, despite no users being listed in the BlackBerry Manager, or fewer users than licenses are available for.


Cause

This can be caused by the incorrect permissions being configured on the Exchange server: when a user account is removed from the BlackBerry server, this requires that information be removed from the user's Exchange mailbox, including AES encryption details among other things. Should the BesAdmin service account not have the ability to 'Administer the Information Store' this process will fail and despite the fact that the user is no longer listed within the BlackBerry Manager, that user will still have an entry in the underlying SQL database. This information is not removed from the database until it receives confirmation from the Exchange server that the information has been removed. If the permissions are not configured correctly, this database entry effectively becomes 'orphaned'.


Resolution

Ideally, the resolution is to configure the permissions correctly. For detailed information on how to do this view these articles:

Exchange 2003 - http://blog.brightpointuk.co.uk/bes-41x-50-exchange-2003-pre-requisites
Exchange 2007 - http://blog.brightpointuk.co.uk/bes-41x-50-exchange-2007-pre-requisites

The issue can be resolved by manually editing the SQL database to remove the orphaned database entry. This guide only applies to the MSDE database installation, not a separate SQL Server installation.

On the Blackberry Server, open a Command Prompt window and type in:

osql –E (enter)

A SQL command prompt will be displayed. Now type in the following commands:

1> use BESMgmt
2> select DisplayName from UserConfig
3> go

(the display name will be returned here) followed by the line
(1 row affected)

Now type in:

1> delete from UserConfig where DisplayName="James Liddiard"
2> go

(Note, here you will need to replace “James Liddiard” with the name of your user. DO use double quotes around the name)

Type quit to exit the SQL command instance. That should resolve the problem. A reboot may be in order for good measure.



UPDATE - the same procedure can be followed on a BlackBerry Enterprise Server Express installation. Follow the same steps, but to access the SQL command prompt, use:

sqlcmd -S .\BLACKBERRY