1. superdave67's Avatar
    I've recently setup BES for Google Apps and is working fine with the exception of HTML emails. I know there is an option to enable this in other, newer, versions of BES (or BPS in this case), but is it available in 4.1.4.3?

    Thanks all,
    Dave


    [Update]

    I found this article: blackberrynews_com/2008/05/18/howto-enable-disable-html-email-processing-bes-4-1-sp5/
    but am getting an error when running the command:

    [30000] (08/31 09:04:50.015):{0x16E0} Current Date: 2009/08/31
    [30000] (08/31 09:04:50.015):{0x16E0} [DIAG] EVENT=Thread_report, THREADID=0x16E0, THREADNAME="DebugLogger"
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Current Process: C:\install\BES_HTML_Update\BBDBUpdate.exe
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Current Process logged on as: GBES\BESAdmin, Start Time: Aug 31 2009 09:04:49, Uptime (seconds): 1
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Current Process id: 5724
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Computer Host Name: GBES, OS Version: 5.2, Build number 3790, ServicePack Major 2, ServicePack Minor 0
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Processor Identifier: x86 Family 15 Model 2 Stepping 5
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Processor Vendor Identifier: GenuineIntel
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Processor Name String: Intel(R) Xeon(TM) CPU 3.06GHz
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Number of Processors: 1
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] 41 percent of memory in use.
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Total size of physical memory: 1535436 KB
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Size of physical memory available: 903688 KB
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Size of the committed memory limit: 2569728 KB
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Size of available memory to commit: 1959856 KB
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Total size of the user mode portion of the virtual address space of the BES process: 2097024 KB
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Size of unreserved and uncommitted memory in the user mode portion of the virtual address space of the BES process: 2076320 KB
    [30000] (08/31 09:04:50.015):{0x16E0} [ENV] Total HD bytes: 32210157568, Total free bytes = 18392363008
    [30000] (08/31 09:04:50.046):{0x16E0} [ENV] System up time: 2 days 17 hrs 56 mins 31 secs
    [30000] (08/31 09:04:50.046):{0x16E0} [ENV] Local Time Zone: Eastern Daylight Time (GMT-05:00)
    [30000] (08/31 09:04:50.046):{0x16E0} [ENV] TCP/IP provider (Winsock) File Version: 5.2.3790.0 (C:\WINDOWS\System32\wsock32.dll)
    [30000] (08/31 09:04:50.046):{0x16E0} [ENV] Unable to provide HostName
    [30000] (08/31 09:04:50.046):{0x16E0} [ENV] Winsock2 file: Network Location Awareness (NLA) Namespace, Version: 5.2.3790.4318 (C:\WINDOWS\System32\mswsock.dll)
    [30000] (08/31 09:04:50.046):{0x16E0} [ENV] Microsoft XML Parser 4.0: C:\WINDOWS\system32\msxml4.dll, Version: 4.20.9818.0
    [30000] (08/31 09:04:50.046):{0x16E0} [ENV] MDAC version: 2.82.3959.0
    [30000] (08/31 09:04:50.046):{0x16E0} [ENV] MSADO15.DLL: C:\Program Files\Common Files\System\ado\msado15.dll, Version: 2.82.3959.0
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: System
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: smss.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: csrss.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: winlogon.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: services.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: lsass.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: vmacthlp.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: svchost.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: svchost.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: svchost.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: svchost.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: svchost.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: spoolsv.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: msdtc.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BBAttachServer.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: bmds.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BESAlert.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: svchost.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: inetinfo.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: sqlservr.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: svchost.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: snmp.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: sqlwriter.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: VMwareService.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BlackBerryController.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BlackBerryDispatcher.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: ITAdminServer.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BlackberryRouter.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BlackBerrySyncServer.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BlackBerryAgent.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: svchost.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: dllhost.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: alg.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: explorer.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: VMwareTray.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: VMwareUser.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: jusched.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: MagicDisc.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: wuauclt.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: wmiprvse.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: SMBbbmgrw32.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: RIMDeviceManager.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BbDevMgr.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: jucheck.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BBConvert.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BBConvert.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: cmd.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BBConvert.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BBConvert.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: wmiprvse.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: wmiprvse.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: wmiprvse.exe
    [30000] (08/31 09:04:50.062):{0x16E0} [ENV] Running Process: BBDBUpdate.exe
    [30000] (08/31 09:04:50.062):{0x14A4} [DIAG] EVENT=Register_thread, THREADID=0x14A4, THREADNAME="TimerThread"
    [40000] (08/31 09:04:50.062):{0x14A4} [DEBUG] EVENTMSG="TimerThread thread started"
    [40000] (08/31 09:04:50.124):{0x77C} BlackBerry Configuration Database Update tool
    [40000] (08/31 09:04:50.124):{0x77C} BlackBerry Configuration Database Update tool Version 4.1.4.8
    [40000] (08/31 09:04:50.124):{0x77C} Modification date: Aug 8 2007
    [20000] (08/31 09:04:50.124):{0x77C} Connect to database server: localhost
    [20000] (08/31 09:04:50.124):{0x77C} Database name: BESMgmt
    [40000] (08/31 09:04:50.124):{0x77C} Authentication Type: Windows Authentication
    [20000] (08/31 09:04:50.296):{0x77C} Database connection opened!
    [20000] (08/31 09:04:50.296):{0x77C} Reading input file: EnableRichContent.sql
    [40000] (08/31 09:04:50.296):{0x77C} ----------------------------------------------------------------------------
    [40000] (08/31 09:04:50.296):{0x77C} -- EnableRichContent.sql
    [40000] (08/31 09:04:50.296):{0x77C} --
    [40000] (08/31 09:04:50.296):{0x77C} -- This will turn on the Rich Content options for all
    [40000] (08/31 09:04:50.296):{0x77C} -- BlackBerry Enterprise Servers managed in the target database.
    [40000] (08/31 09:04:50.296):{0x77C} --
    [40000] (08/31 09:04:50.296):{0x77C} -- (C) 2008 Research In Motion Limited.
    [40000] (08/31 09:04:50.296):{0x77C} ----------------------------------------------------------------------------
    [40000] (08/31 09:04:50.296):{0x77C} UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
    [40000] (08/31 09:04:50.296):{0x77C} UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
    [40000] (08/31 09:04:50.296):{0x77C} UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
    [40000] (08/31 09:04:50.296):{0x77C} UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
    [40000] (08/31 09:04:50.296):{0x77C} ExecuteStatement: Unable to run the statement:
    ----------------------------------------------------------------------------
    -- EnableRichContent.sql
    --
    -- This will turn on the Rich Content options for all
    -- BlackBerry Enterprise Servers managed in the target database.
    --
    -- (C) 2008 Research In Motion Limited.
    ----------------------------------------------------------------------------
    UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
    UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
    UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
    UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
    [40000] (08/31 09:04:50.296):{0x77C} ExecuteStatement: Error: [ADOConnectionItem::ExecuteUpdateSQL(): Could not execute SQL Command "----------------------------------------------------------------------------
    -- EnableRichContent.sql
    --
    -- This will turn on the Rich Content options for all
    -- BlackBerry Enterprise Servers managed in the target database.
    --
    -- (C) 2008 Research In Motion Limited.
    ----------------------------------------------------------------------------
    UPDATE ServerConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
    UPDATE ServerConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0
    UPDATE UserConfig SET RichContentEnabled = 1 WHERE RichContentEnabled = 0
    UPDATE UserConfig SET RichContentInlineEnabled = 1 WHERE RichContentInlineEnabled = 0".]
    [10000] (08/31 09:04:50.296):{0x77C} Problem occured while executing SQL commands.


    Anyone got any ideas? I'm new to BES so I'm not sure on where to start. This is actually BPS 4.1.4.3 (Blackberry Professional Software).

    Thanks,
    Dave
    Last edited by superdave67; 08-31-09 at 08:24 AM.
    08-31-09 07:31 AM
LINK TO POST COPIED TO CLIPBOARD