Friday, January 11, 2008

2 - Not able to initialize admin object definitions against db ...

So I was tasked with automating the creation and deletion of BlackBerry users. According to RIM, the recommended way of doing this is by using their BlackBerry Resource Kit -- namely the BlackBerry User Admin Service and Tool.

I've never done anything with BlackBerry before, so needless to say I spent some time making noob errors when trying to install the Admin Service. First off, I was getting this funky error:

MAPILogonEx() failed (80040111) for profile:

Okay, that's easy enough to see what's going on. A missing or invalid MAPI profile. I needed a MAPI profile locally (dammit Jim, I'm a developer, not an admin!). I created one using a tool from Microsoft's website: http://support.microsoft.com/kb/228736

I eventually did get to a sticking point when google no longer helped:

"2 - Not able to initialize admin object definitions against db"

I ran SQL profiler to make sure the service was successfully connecting to the proper database (BESMgmt) and it had rights to do everything -- yep everything was cherry. Still no love though. It seemed to point at a database-related error. I fired up Query Analyzer and looked for a table relating to 'object definitions'. Sure enough, an ObjectDefn table existed. Here's a partial sample record:

<AdminObject name="ServerConfig" dbtable="ServerConfig"><Property clientname="Id" dbname="Id" type="56" length="4" isnullable="0" key="1" /><Property clientname="ServiceName" dbname="ServiceName" type="231" length="512" isnullable="1" /><Property clientnam...


Then it dawned on me: they're storing xml in the database. I didn't verify that msxml 4.0 was installed (per the Admin User Documentation from RIM). So I grabbed MSXML 4.0 from Microsoft's website and installed it. Sure enough, the service could finally start. Yay.

Moral of the story: verify your prereq's before banging your head against the wall.

Long story short:
2 - Not able to initialize admin object definitions against db == wrong version of MSXML installed

Hopefully somebody googles this and doesn't have to recreate my madness :-)

8 comments:

Anonymous said...

Brock,

Thank you for making this post. I had the same exact issue and the MSXML 4.0 wasn't installed. Your directions worked perfectly.

Oddly enough, you originally posted this on my birthday. I suppose this was a birthday present I forgot to open.

Thanks again.

acrile said...

Saved the day again Brock ;)

Anonymous said...

Googled the error, came here and got the issue fixed. Thanks a lot for sharing!

Anonymous said...

Good dispatch and this mail helped me alot in my college assignement. Thank you for your information.

Anonymous said...

Amiable fill someone in on and this enter helped me alot in my college assignement. Thank you for your information.

Anonymous said...

Il semble que vous soyez un expert dans ce domaine, vos remarques sont tres interessantes, merci.

- Daniel

Anonymous said...

top [url=http://www.c-online-casino.co.uk/]uk online casino[/url] check the latest [url=http://www.casinolasvegass.com/]free casino games[/url] free no consign perk at the chief [url=http://www.baywatchcasino.com/]redeem casino
[/url].

Packers and Movers in Bangalore said...

Very Helpful Article, Thanks for sharing the informative article. I appreciate your efforts to let people know about the moving and packing facility within the city or outside the city with 100% trusted Professional Packers and Movers Bangalore Compare Charges of Movers and Packers To know more about us kindly visit our website

Packers and Movers in Hyderabad
Packers and Movers in Delhi