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.


Thank you for visiting the BlackBerry Support Community Forums.

BlackBerry will be closing the BlackBerry Support Community Forums Device Forums on April 1st (Developers, see below)

BlackBerry remains committed to providing excellent customer support to our customers. We are delighted to direct you to the CrackBerry Forums, a well-established and thorough support channel, for continued BlackBerry support. Please visit http://forums.crackberry.com or http://crackberry.com/ask. You can also continue to visit BlackBerry Support or the BlackBerry Knowledge Base for official support options available for your BlackBerry Smartphone.

"When we launched CrackBerry.com 10 years ago, we set out to make it a fun and useful destination where BlackBerry Smartphone owners could share their excitement and learn to unleash the full potential of their BlackBerry. A decade later, the CrackBerry community is as active and passionate as ever and I know our knowledgeable members and volunteers will be excited to welcome and assist more BlackBerry owners with their questions."

- Kevin Michaluk, Founder, CrackBerry.com

Developers, for more information about the BlackBerry Developer Community please review Join the Conversation on the BlackBerry Developer Community Forums found on Inside BlackBerry.


Reply
Highlighted
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.