Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

Reply
New Contributor
Posts: 2
Registered: ‎12-09-2008
My Device: Not Specified

Upgrade from 4.1.4 to 4.1.6 fails when trying to upgrade SQL database.

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 ======

Forums Veteran I
Posts: 1,546
Registered: ‎04-01-2008
My Device: 8120, Storm, 8200

Re: Upgrade from 4.1.4 to 4.1.6 fails when trying to upgrade SQL database.

-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.
*****************************************************************************
Click on KUDOS to appreciate our efforts and mark the thread RESOLVED if your issue is resolved.
Forums Veteran I
Posts: 2,036
Registered: ‎12-04-2008
My Device: 8900

Re: Upgrade from 4.1.4 to 4.1.6 fails when trying to upgrade SQL database.

[ Edited ]
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
******************************************************************


If someone helped you give them kudos. Research all info!
Forums Veteran I
Posts: 2,036
Registered: ‎12-04-2008
My Device: 8900

Re: Upgrade from 4.1.4 to 4.1.6 fails when trying to upgrade SQL database.

BBsingh hit it on the head
******************************************************************


If someone helped you give them kudos. Research all info!
Forums Veteran I
Posts: 1,546
Registered: ‎04-01-2008
My Device: 8120, Storm, 8200

Re: Upgrade from 4.1.4 to 4.1.6 fails when trying to upgrade SQL database.

???
*****************************************************************************
Click on KUDOS to appreciate our efforts and mark the thread RESOLVED if your issue is resolved.
Forums Veteran I
Posts: 2,036
Registered: ‎12-04-2008
My Device: 8900

Re: Upgrade from 4.1.4 to 4.1.6 fails when trying to upgrade SQL database.

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
******************************************************************


If someone helped you give them kudos. Research all info!
New Contributor
Posts: 2
Registered: ‎12-09-2008
My Device: Not Specified

Re: Upgrade from 4.1.4 to 4.1.6 fails when trying to upgrade SQL database.

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'

Forums Veteran I
Posts: 1,546
Registered: ‎04-01-2008
My Device: 8120, Storm, 8200

Re: Upgrade from 4.1.4 to 4.1.6 fails when trying to upgrade SQL database.

-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.
*****************************************************************************
Click on KUDOS to appreciate our efforts and mark the thread RESOLVED if your issue is resolved.