[pomc]

Yesterday afternoon our BES 4.0 (local MSDE database) was not allowing new users to be added. Blackberry Manager error message is attached.

I could also not add users to a policy. No error was given, but the # of users on the policy didn't increase when I added a person and their account still showed the old policy.

All the services were stopped and started and still the problem occurred. So we had to reboot last night and that's where the true problem revealed itself.

The Dispatcher service failed to start on reboot, so I checked the Dispatcher log. Here's an excerpt of what I found:

Stopping BlackBerry

[30065] (04/25 20:46:37):{0xFBC} Shutdown complete

[50075] (04/25 21:07:41):{0x1038} Starting BlackBerry Dispatcher mail14 - Version 4.0.0.99

[30221] (04/25 21:07:41):{0x1038} BES Cryptographic Kernel module is initialized and working properly.

[30058] (04/25 21:07:41):{0x1038} Starting Database

[30000] (04/25 21:07:42):{0x1038} CheckConfigurationChanges: SRPKey is "intentionally edited from this message"

[30189] (04/25 21:07:42):{0x1038} External Services ENABLED on this BlackBerry Server

[30231] (04/25 21:07:42):{0x1038} 3DES encryption keys are ENABLED on this server

[30231] (04/25 21:07:42):{0x1038} AES256 encryption keys are DISABLED on this server

[10221] (04/25 21:07:42):{0x1038} UpdateAgentId: COM exception.

[10226] (04/25 21:07:42):{0x1038} COM Error 0x45B680 in UpdateAgentId - Could not allocate space for object 'ServerConfigHistory' in database 'besmgmt' because the 'PRIMARY' filegroup is full. - IDispatch error #3092

[10224] (04/25 21:07:42):{0x1038} Database error in UpdateAgentId (err=0x80040E14, native err=1105) - Could not allocate space for object 'ServerConfigHistory' in database 'besmgmt' because the 'PRIMARY' filegroup is full.

[10260] (04/25 21:07:42):{0x1038} Optimization of BES Agents usage failed

[50004] (04/25 21:07:42):{0x1038} Stopping BlackBerry

[30065] (04/25 21:07:42):{0x1038} Shutdown complete



The database was apparently full, even though the actual size was only 97MB and MSDE has a 2GB database limit. Well, it does have a 2GB limit, but not "out of the box" apparently. Called RIM and was given this command to increase the maximum size of the database. Actually the tech told me to use "brackets" in the command and I was put on hold when I got errors running the command. I Googled the command and found that it was actually parenthesis instead.

We have 690 users and just went over a 100MB database size. Some of you may not even be close to that, so I'm posting this message so it's available for future reference. We'll be moving the database to a SQL server in the future, but are waiting for new hardware to arrive.


To INCREASE THE MAXIMUM SIZE of the databse, do the
following:
1. Open a command prompt from the machine running MSDE.
2. Type osql -E and press enter; 1> is displayed.
3. Type alter database besmgmt modify file (name=besmgmt, maxsize=2gb) and press enter; 2> is displayed.
4. Type go and press enter; 1> is displayed.
5. Type exit and press enter to exit out of osql command.
6. Restart the Dispatcher service.

[bbgirl]

that is great news. I was speaking to RIM earlier and they suggested that I stay with the MSDE engine on one of my BES's because it only has 35 users. On my other bes I have 70 users. I guess I will stay with the MSDE engine on that one also.

they suggested that under 150+ users, I wouldn't need SQL...

but I know eventually i will get there...

[jibi]

i thought the database was initially allocated to 100MB one way or the other?

[bfrye]

You can also set it to unlimited so it doesn't get that message. It will purge the oldest info to make room for the new.

[pomc]

In all my reading, I only saw the part about MSDE having a 2GB database limit. Never read that it would have to be manually increased if needed. Now I'm not a SQL/MSDE guy, I just deal with it because of BES. So all my reading was BES related and I never saw anything about a 100MB limit in any BES documentation.

[bbgirl]

Ditto, pmoc.

I try to avoid it altogether.

[paulmorley]

POMC, I can't tell you how much I appreciate your sharing this info with us. I am in an enterprise corporation with over 600 BB's. We started having this problem at 12:15 am and didn't find your post until 3 hours later. I searched and searched. Of course RIM's free tech knowledge base doesn't have jack squat in it. You really saved my hide. Once again thanks.

[cayzac]

My database is 102 meg so I thought I would run this. I'm getting an error and I don't understand it.
Msg 5041, Level 16, State 1, Server LGESPTBES001, Line 1
MODIFY FILE failed. File 'BESMgmt' does not exist.

The name of my database IS BESMgmt, so I guess I'm confused. Anyone have a suggestion?

[amukhey]

If this is the case for MSDE on the BES Server, what if we have a dedicated SQL Server for the BESMGT Db and the attachment service. This dedicated server will be used for 3 BES Servers with a total of 1200 users. Is there a db limit if using ms sql 2000?