[jibi]

Please note that this is an unsupported configuration by RIM. There are known issues and conditions that can potentially cause your messaging (Exchange) server to crash. This is not a recommended solution for large BlackBerry deployments. If you do not have OS 4.5 (currently in beta) on your devices, don't apply this patch. If you do not know what you're doing, don't apply this patch!

I hope that's enough disclaimers and warnings, but if not, I have included a method to disable this feature in the package as well. By applying this patch, you agree that BlackBerryForums.com or Jibi (me) or Research In Motion are not responsible for any damage that may be caused by applying the patch in your environment.

Logical Overview
The logic behind the SQL queries being applied is a two-fold approach - a) enables the feature at the server level, and b) enables the feature at the user level for ALL users.

Pre-Requisite: BlackBerry devices must have OS 4.5 in order to take advantage of the HTML feature found deep within BlackBerry Enterprise Server 4.1 SP5. Please do not request this OS in order to test the BES features, as you may be banned from BlackBerryForums.com for asking. Thanks.

<db name> = BESMgmt by default

To enable HTML email processing:
- Login to your BES as the BES service account
- Extract files to a folder
- Bring up a command prompt and navigate to your folder
- Run the following command:
BBDBUpdate.exe -db <db name> -n <sql server name> -input EnableRichContent.sql

To disable HTML email processing:
- Login to your BES as the BES service account
- Extract files to a folder
- Bring up a command prompt and navigate to your folder
- Run the following command:
BBDBUpdate.exe -db <db name> -n <sql server name> -input DisableRichContent.sql

[TwoThumbs]

Is this feature only accessible to Exchange environments? Can I enable this in my Domino environment with SP5 and OS4.5?

[BBAdmin]

Is this feature only accessible to Exchange environments? Can I enable this in my Domino environment with SP5 and OS4.5?

I would assume yes but I couldn't help you.

Just to elaborate slightly on J's point, the reason it was pulled was due to processor load on the Exchange Server in large environments where companies were sending out distribution wide HTML emails at once. I can't see how they're going to get around this in future releases as all roads lead to the Exchange Server, but I suspect they will figure something out.

[jibi]

...nor why such an issue wasn't found by RIM in the 6-8 prior months of testing, but whatever

This feature should be the same for Domino. I will download the package here shortly to verify the registry change would be the same.

[AlanM]

Jibi, what are you saying? What do you mean I can't hold you responsible? It's how I get myself out of trouble here at work.

Me (to my bosses): Well, this guy, Jibi, on the BB forums said apply this patch. It's not my fault.

Bosses: Well, then, if it's not your fault, everything's OK. But that guy Jibi is fired.

LOL

In reality html email means little to me in my environment, since we have to disable it. (why Oh why, does MS make you disable it at the client only).

[BB Junkie]

Jibi, I have followed your instruction and applied it on BES 4.1.5 with no success. I got the error message:
C:\>BBDBUpdate.exe -db BESTESTDB -input EnableRichContent.sql
BlackBerry Configuration Database Update tool Version 4.1.4.8
Copyright (c) Research In Motion, Ltd. 2000-2007. All rights reserved.
Modification date: Aug 8 2007

[20000] (17:30:08.218):{0x1124} Connect to database server: localhost
[20000] (17:30:08.218):{0x1124} Database name: BESTESTDB
[10000] (17:30:25.000):{0x1124} Failed to open database connection


What did I do wrong?
Thanks!

EDIT:
from BBDBUpate Log

[20000] (04/19 17:30:08.218):{0x1124} Connect to database server: localhost
[20000] (04/19 17:30:08.218):{0x1124} Database name: BESTESTDB
[40000] (04/19 17:30:08.218):{0x1124} Authentication Type: Windows Authentication
[40000] (04/19 17:30:25.000):{0x1124} ...connection failed (ADOConnectionItem::ConnectToDB(): COM Error 0x80004005 - Cannot connect to database: Cannot open database).
[10000] (04/19 17:30:25.000):{0x1124} Failed to open database connection

[BB Junkie]

I forgot to mention that I dont have SQL Server, but rather SQL Server Express or MSDE that comes with BES 4.1.5 installer if that makes the difference. Thanks again.

[hdawg]

SQL Express shouldn't matter at all here.

Have you logged into the server with an account that is a part of the Administrators group on the server?

[BB Junkie]

Originally Posted by hdawg

SQL Express shouldn't matter at all here.

Have you logged into the server with an account that is a part of the Administrators group on the server?

Found the solution to this problem. I had to add this command line:

BBDBUpdate.exe -db <db name> -n <server name> -input EnableRichContent.sql
and it worked! I was able to receive html emails now. Hope that helps for anyone who has the same issue as I did.

[hdawg]

Originally Posted by BB Junkie

Found the solution to this problem. I had to add this command line:

BBDBUpdate.exe -db <db name> -n <server name> -input EnableRichContent.sql
and it worked! I was able to receive html emails now. Hope that helps for anyone who has the same issue as I did.

Were you not running this on the BES / SQL Server?

[BB Junkie]

Originally Posted by hdawg

Were you not running this on the BES / SQL Server?

I used SQL Express edition or MSDE that comes with the BES 4.1.5 installer on the same machine. I dont have full blown MS SQL server.

[hdawg]

Originally Posted by BB Junkie

I used SQL Express edition or MSDE that comes with the BES 4.1.5 installer on the same machine. I dont have full blown MS SQL server.

hmn ... and it was installed as the Default instance?

[BB Junkie]

Originally Posted by hdawg

hmn ... and it was installed as the Default instance?

Yes, thats correct.

[jibi]

I have modified the command-line example to include server name. I don't think SQL 2005 Express changed anything to not process localhost queries, but perhaps it may have. I forgot to take into account remote SQL databases anyhow (I used an 'all under the hood' environment for test, as well).

[Dookie]

Really good job, Jibi! Thanks for that. I have it on my test server and i'm keeping it quiet in our company
At least i know what to expect - user's are asking me when SP6 or BES 5 will be released ...

[Inphektion]

Originally Posted by BBAdmin

I would assume yes but I couldn't help you.

Just to elaborate slightly on J's point, the reason it was pulled was due to processor load on the Exchange Server in large environments where companies were sending out distribution wide HTML emails at once. I can't see how they're going to get around this in future releases as all roads lead to the Exchange Server, but I suspect they will figure something out.

I'm confused as to why the exch server cpu would get hit and not the bes server? Isn't the bes getting the emails the same as any outlook client? It gets html emails now its just the client doesn't display them as such. I would think the client (BB) just needs to know how to translate html...

[BB Junkie]

Hey, I was able to get HTML content working ok on 8310 with 4.5.0.18 beta. I was able to see html content when i receive it, however, if I request for more or more all, I get an error message: HTML Content is not enabled. Would you like to switch to plain text?

What did I do wrong?

Thanks for the help!

[jibi]

Originally Posted by Inphektion

I'm confused as to why the exch server cpu would get hit and not the bes server? Isn't the bes getting the emails the same as any outlook client? It gets html emails now its just the client doesn't display them as such. I would think the client (BB) just needs to know how to translate html...

It only gets 2KB of the message. This was fine for Plain Text, but obviously much different for HTML (in some cases).

[Sith_Apprentice]

it would be amusing to get the first 2kb of an email in HTML. it would be like old dialup modems on a content rich page, loading line by line.

do we know how much of the email is sent via HTML? Plain text is 2kb

[jibi]

Sith, I believe it depends on your options that are set on the BES and device (auto-download of images/rich content), but I could be wrong.