Port 1352

I recently blogged about how to manually urge BES along in processing certain pending actions.

Along those same lines, it's a little known fact that there is a service, called "SQLSERVERAGENT," available to automatically run pre-configured SQL maintenance jobs for BES versions 4.0 and 4.1 (except those configured to use Microsoft SQL Server 2005 Express Edition).  See this if you use Express Edition.

By default, the Startup type for the SQLSERVERAGENT service is set to Manual. If the Startup type is set to Automatic, all BlackBerry Enterprise Server maintenance jobs execute regularly on a pre-set schedule.

Here's a link to the details:
How to run Microsoft SQL Server maintenance jobs for the BlackBerry Configuration Database

...and, while you at it, don't forget to tweak your "Debug log maximum daily file age" settings!

"Rock Over London, Rock on Chicago;   Wheaties, the breakfast of champions!

From time to time I've encountered the following error for a BES account that refuses to purge:
User "user's name" is in delete pending state on server "CN=user's server name", please recover the user before adding user to server.



It's tempting to just switch to the "User's Pending Delete" tab and manually complete the process, but BES Manager then gives you a warning that basically indicates that you probably don't want to do that...



No love from the BlackBerry Technical Solution Center for this error in Domino (just something for Groupwise), but I found a solution here that might very well do the same thing as manually following through on the Users Pending Delete tab, but it "feels" like a better solution.

Here's the solution posted in the link above:

1. Open command prompt
2. Type "osql -E"
3. 1>use BESMgmt
4. 2>go
5. 1>delete from userconfig where mailboxsmtpaddr=''<email address>''
6. 2>go

If your command was successful, you'll get the response "(1 row affected)".
Checking the "Users Pending Delete" tab will now confirm the account is fully purged.