BlackBerry® Enterprise Solution

[RSI_Master]

Server is running Windows 2003 SP2  All microsoft updates applied.

3 gigs of RAM

plenty of disk space

Exchange Server (1 of 2 - no mailboxes on this one)

I am trying to upgrade my BB server and it fails.  The current version is 4.1.4 i would like to go to 4.1.6.  I have downloaded the 4.1.6 upgrader and when i run the setup i get the following error.   An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement.   Here is the bottom of my log file.

/****************************************************************************
 UpgradeV99990101.sql
 
 This SQL script will migrate the tables from this release to the latest as
 of this file.
 

 Notes:

 (C) 1997-2004 Research In Motion Limited.
 ****************************************************************************/

/*
 *   Switch to the besmgmt database 
 */

USE "besmgmt"
[30000] (12/09 15:22:13.128):{0x2518} SQL executed successfully
[30000] (12/09 15:22:13.128):{0x2518} SQL being executed:
 set nocount on
[30000] (12/09 15:22:13.128):{0x2518} SQL executed successfully
[30000] (12/09 15:22:13.128):{0x2518} SQL being executed:
 
IF EXISTS (SELECT name FROM sysobjects where name = 'vUserDSUPRequest' AND type = 'V')
    drop view dbo.vUserDSUPRequest
[30000] (12/09 15:22:13.159):{0x2518} SQL executed successfully
[30000] (12/09 15:22:13.159):{0x2518} SQL being executed:
 
create view dbo.vUserDSUPRequest as

SELECT ur.Id as DSUPRequestId, ur.SequenceNumber, ur.DSUPAvailableId, ur.RevertId, ur.UpgradeXml, ur.Status as UpgradeStatus, ur.StatusTime, ur.Command, ur.RollbackExpires,
       sd.ServerTime, sd.ModelName, sd.PlatformVer, sd.AppsVer, sd.PhoneNumber, sd.IMEI, sd.HomeNetwork, sd.VendorID,
       sd.PasswordEnabled, sd.HandheldConfigStatus, sd.HandheldConfigCheckTime, sd.DCID, sd.FlashSize, sd.ITPolicyName,
       sd.ITPolicyTime, sd.IMSI, sd.ICCID, sd.ESN, sd.ScreenLanguage, sd.HardwareId, sd.BootROMVersion,
       a.SourceScmVer, a.DestScmVer, a.MaxDownloadBytes, a.Severity,
       u.*
FROM   (dbo.DSUPRequest ur INNER JOIN DSUPAvailable a ON ur.DSUPAvailableId = a.Id)
        RIGHT OUTER JOIN (dbo.SyncDeviceMgmtSummary sd INNER JOIN dbo.UserConfig u ON u.Id = sd.UserConfigId )
        ON ur.UserConfigId = sd.UserConfigId
[30000] (12/09 15:22:13.253):{0x2518} SQL executed successfully
[30000] (12/09 15:22:13.253):{0x2518} SQL being executed:
 
update GlobalSettings set HandheldMgmtConfigProperties =
    '<HandheldMgmtConfigParms><HandheldSoftwarePath></HandheldSoftwarePath><OTASLLastRefreshTime>0</OTASLLastRefreshTime><OTASLRefreshInterval>86400</OTASLRefreshInterval><OTASLPASUrl>https://%s.otasl.blackberry.com/pas/pas</OTASLPASUrl></HandheldMgmtConfigParms> '
    where Container = 'Site'
[20000] (12/09 15:22:13.315):{0x2518} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Unable to set MDSPushMaxStoredMessages as this feature is disabled for MSDE" Native error = 50000
[20000] (12/09 15:22:13.315):{0x2518} [CBESDBInstaller::ExecuteDDL] SQL Error for
update GlobalSettings set HandheldMgmtConfigProperties =
    '<HandheldMgmtConfigParms><HandheldSoftwarePath></HandheldSoftwarePath><OTASLLastRefreshTime>0</OTASLLastRefreshTime><OTASLRefreshInterval>86400</OTASLRefreshInterval><OTASLPASUrl>https://%s.otasl.blackberry.com/pas/pas</OTASLPASUrl></HandheldMgmtConfigParms> '
    where Container = 'Site'
[30000] (12/09 15:23:42.129):{0x2518} [PIPTOOL]: Exiting PIPTool from DBInfoDlg.
====== END OF LOG ======

[BBsingh]

-search for *install* on your machine and there should be a db_instlall ding and check the time stamp and verfi y its around the time when it failed, post the last few lines from that file.

[bbhorrigan]

Need more info from the log then this,

Check out this link

http://www.blackberry.com/btsc/microsites/search.do?cmd=displayKC&docType=kc&externalId=KB03569&slic...

Message Edited by bbhorrigan on 12-09-2008 03:41 PM

Message Edited by bbhorrigan on 12-09-2008 03:42 PM

[bbhorrigan]

BBsingh hit it on the head

[BBsingh]

???

[bbhorrigan]

I was trying to figure out where you needed to get the info from, and you posted exactly what I was about to type ;p

[RSI_Master]

Not sure if this helps.  I am searching for the file you requested now.

this is in the event viewer

Event Type: Warning
Event Source: BlackBerry Database Consistency Service
Event Category: None
Event ID: 20640
Date:  12/9/2008
Time:  4:01:22 PM
User:  N/A
Computer: LD-DATA2-SRV
Description:
PMDatabaseSQLImp::LoadServerConfig: COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'RichContentEnabled'." - Command "SELECT s.Id, ServiceName, ServerDN, MachineName, MailServerName, LinkStatus, SRPHostName, SRPId, SRPKey, ExternalServicesPort, AdminAcctName, ExternalServices, ExternalServicesPort, GlobalFilter, RPCEndPoint, HRT, DisclaimerText, AutoBCCName, AutoBCCAddr, BESVersion, LicenseKey, EnableSMIME, g.PeerToPeerKeyData, OTAFMSupport, OTAFMEnable, ServerLTKeyPair, SendHeadersOnly, PrePopulationDays, PrePopulationMessage, MigrationComplete, InternalBIPPPort, PolicyResendTimeout, EnabledEncryptionAlgs, OTAFMHardDeleteEnabled, MessageStateDbSize, MaxAttachUploadSize, MaxAttachTotalUploadSize, DisclaimerTextPrepended, DisclaimerTextRule, MaxAttachDownloadSize, GlobalFilterBin, RichContentEnabled, RichContentInlineEnabled, RemoteSearchEnabled, FreeBusyEnabled FROM ServerConfig s, GlobalSettings g WHERE g.Container = 'Site'

[BBsingh]

-that does not help, infact you can disable BlackBerry Database Consistency Service as its not required to be runingon BES. find the file and post the last few lines from that error log.