BlackBerry Enterprise Server Data Dictionary

If you have a BlackBerry Enterprise server (BES) you have a configuration database that is used to manage pretty much every aspect of the server and all of your BlackBerry devices.

Periodically, I need to access this database directly to retrieve information that is not exposed via the BlackBerry Manager console. But it can take a while to work out which view or table contains the information that I am after. And sometimes the name of a column doesn’t necessarily reflect its contents. So there are plenty of test SQL queries that I need to do to suss out which pieces I need.

After checking online I could see zero references to a data dictionary for this configuration database. Even checking RIM’s own tech site yielded no clues so I called them up and asked for it directly. The tech told me this was the first time anybody had asked that question (presumably of him, not ever). He didn’t know but he checked and soon sent me the following note:

Hello Marc,

Thank you for contacting BlackBerry Customer Support.

Unfortunately the information requested is not publicly available.

Should you require further information on this subject, please don’t hesitate to contact us. Thank you again for contacting us.

Sincerely,

Alan
BlackBerry Customer Support
Research In Motion Limited
Tel:
NA Toll Free: 1-877-255-2377
UK Toll Free: 0808 100 7466
Europe: +44 1753 558400
Worldwide: +1-519-888-6181
Email: help@blackberry.net
Web: www.blackberry.com

So there you have it. If anybody knows differently I’d love to hear it, but apparently we are not to have a reference to this central resource and must continue to guess our way through our reporting.

Google Buzz

Posted under Blackberry

This post was written by Marc
on March 5, 2010 at 8:00 pm

Verizon Pushes BING to Certain BlackBerry Devices

In a shady deal that alters settings on end user devices without their permission or knowledge, Microsoft and Verizon have agreed to make BING the default search engine on certain BlackBerry devices. Those I know of for certain are the 8830, the Tour and the Storm 2.

I am told that you can select other search engines but only BING can be the default.

Also, apparently a new BING icon also appears on the devices after a hard reset (pull the battery).

This may be OK for new devices where end users expect a lot of extra stuff that they do not require and will clean up. What is NOT expected is for new stuff to show up suddenly unannounced. It is confusing and it is invasive.

I expected better of Verizon.

Google Buzz

Posted under Blackberry

This post was written by Marc
on January 8, 2010 at 7:06 pm

Memory leak issue for RIM Blackberry Devices – Especially 8830

*** Update May 8, 2009 ***

Verizon finally did see fit to release the OS 4.5 update and, so far, it appears that it is addressing the issue for us. We set a date of May 15 (approximately 3 weeks after upgrading) as our “OK Date”. This means that folks in our pilot group would have gone 100% longer than before without a recurrence of their messages vanishing.

So, while the memory does still dip significantly in the devices I’ve seen, it appears that the updated OS is addressing the worst of the memory symptoms. Kudos! From the below you could see I was entirely not expecting this.

*** End Update May 8, 2009 ***

We have been having a problem for a while know that has surged to the forefront of our corporate consciousness at the beginning of spring break (April 4, 2009).

Folks on that day began reporting in droves (basically about 5% of my total blackberry user base) that some or all of their email had disappeared, many on that Saturday, but many others on the days after that.

In looking into the issue I discovered that our Blackberry help desk has been fielding similar issues on the order of (anecdotally) 5-10 such incidents per week.

The problem has been largely experienced by our 8830 users. Made more awful by the fact that only this past summer we upgraded most of our handhelds to the new 8830 model.

Facts that I have at my disposal:

  • RIM claims that the memory manager in the 4.5 OS addresses this issue
  • I have a BOLD (OS 4.6.x) that shows massive memory consumption that is corrected by removing and replacing the battery or by simply performing a reset (Alt – Right Shift – Del).
  • People are complaining about this issue whether their devices communicate with a corporate BES or not (in the various forums that I have been reading)
  • The vanishing messages are a normal function of the low memory manager on the Blackberry OS. The priority is to allow new incoming messages and (supposedly) the last resort is to delete the oldest or least accessed existing messages to make that room

This is what I am thinking:

  • The problem is device related and is a memory handling issue
  • The problem has not been resolved with OS 4.5 but rather folks now receive a warning at about 400K of memory so they can take action before messages begin to vanish
  • The problem manifests in devices other than the 8830 but newer devices have so much memory that the issue is masked and wreaks less havoc. My bold can easily get to 6 Megabytes of file free out of 37 that are normally available. That’s 31 Megabytes of space that’s being wasted. That’s also more than double the maximum File Free that I used to have on my old 8830. Except for those apps supplied with the bold, my 3rd party apps are the same on this device as I had on my 8830.
  • The sudden surge in reports stems more from the fact that so many people were going to be out of the office and needed their email accessible on their handheld devices than any sudden change in the environment (indeed, I had been out of the office for the 2 days prior to this issue and I’m the only one making changes to our BES). Unless Verizon is monkeying around with stuff on their network.

RIM is insistent that the issue is resolved in the 4.5 OS. Since Verizon is our primary service provider and they’ve been unable to certify the 4.5 OS for their devices for about a year now, this is not a reasonable solution for us.

Plus, it seems that there are a fair number of other Blackberry users out there who are encountering this issue regardless of their handheld version or OS.

What needs to happen:

  • Short term: I need to create an application that would reset the device on a schedule. One of my team members has found one called “QuickPull” that *almost* fits the bill but needs some tweaks (see below) and can’t be distributed via BES.
  • Long Term:  RIM needs to get off its behind and acknowledge this memory management issue and actually address it. Pull back on the whiz-bang (crappy storm for example) and make sure that the basics are rock solid. Folks needing to reset their devices on a daily basis is just silly.
  • Long Term as well: What’s with this limited memory in these devices? We should be able to upgrade or add memory as we need to. The advice from RIM to “remove applications” and “minimize what you store” belongs back in the late-80’s along with a 640K memory limit and QEMM software!

Specs for reset application:

Since it is going to be necessary to create a workaround to allow folks to use their devices with the security of a corporate email system (i.e. messages not disappearing) I need to find or create a reset application that -

  • Resets the device (reclaims all that wasted memory)
  • Is distributable by BES (ALX and COD files)
  • Operates on a schedule that is user configurable but has a default time set by policy. That time is localized (i.e. 3 am is 3 am your timezone).
  • Prompts user to allow delay or skip of reset
  • Recognizes phone in use and delays reset
  • Can be set to only reset if device is locked
  • Inexpensive

That’s what I have. So far I’ve gotten to the point where I can produce a “Hello World!” app on my handheld. Let’s see how long it takes to address this workaround.

We’ve been working unproductively with RIM – they keep wanting us to delete applications / themes etc.

We’ve been working with Verizon, they’re promising the 4.5 OS RSN (Real Soon Now).

Google Buzz

Posted under Blackberry, Opinions, Tech Stuff, Work Portfolio

This post was written by Marc
on April 16, 2009 at 4:25 pm

TCP APN for Verizon Blackberry 8830’s

It took me a while to figure this out so I’m documenting this mostly for myself but if it helps anybody else then that’s icing on the cake!

In a few words, don’t touch, save, change or in any way alter the contents of these fields!  Ever.

The following applies if you have a Blackberry communicating with a BES (Blackberry Enterprise Server). I cannot say if this will work for folks outside the corporate sphere but I see no reason why not.

Verizon support is clueless about TCP APN settings. Basically, if someone is using an application that doesn’t work and the solution is to update the APN, what you *really* need to do is:

  • Use desktop manager to backup the device
  • Wipe the device (you should be able to retain 3rd party apps if it asks)
  • Restore the device and turn on the radio <– it should automatically Activate itself – no need for Enterprise Activation.

Excerpt from the Crackberry forums posted by CrackBerry Genius:

!!!WARNING!!!

If you messed with your APN settings on a VZW8830 by putting something in, even if you clear it out and save it’s still messed up. If you’ve done this programs like BBWeather and Opera Mini WILL NOT WORK.

You must do an OS reload or possibly just a Wipe on the handheld to get this fixed. I personally did an OS reload to fix it, but never tried to do just a Wipe from the Security/General menu to see if that was sufficient.

I performed the above operation and got BBWeather to work just fine. I was having a similar problem with Jott for Blackberry but since then they’ve made that app a paid-only service and the price is much steeper than the value that I feel I’d get from it (but I’d love to try it again to see if it works at all).

Google Buzz

Posted under Blackberry, Tech Stuff

This post was written by Marc
on December 2, 2008 at 8:04 pm