BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 10-19-2009, 05:58 PM   #1 (permalink)
New Member
 
Join Date: Aug 2007
Model: 8800
PIN: N/A
Carrier: TDC
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default BES 4.1.6 to BES 5 fails during SQL upgrade

Please Login to Remove!

Hello all,

I'm trying to upgrade BES 4.1.6 for Domino BES 5 using a single server upgrade. But the upgrade fails during the SQL database upgrade. The following is the error statements from the log:

[30000] (10/19 22:46:35.023):{0x9E0} SQL being executed:
DELETE FROM BASMetaDataDefinitions WHERE PlugInId = 106
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, DefaultValue,
DoesModifyRequireRestartWarning, IntegerMaximumValue, IntegerMinimumValue,
StringValidationType, StringLengthMinimumValue, StringLengthMaximumValue)
VALUES(1,106,2,'QueryLimit',1,50,0,65535,1,null,nu ll,null)
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, DefaultValue,
DoesModifyRequireRestartWarning, IntegerMaximumValue, IntegerMinimumValue,
StringValidationType, StringLengthMinimumValue, StringLengthMaximumValue)
VALUES(2,106,0,'EnableDataCompression',1,0,0,null, null,null,null,null)
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, Def
[20000] (10/19 22:46:35.131):{0x9E0} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'rsaAuthSupport'." Native error = 207
[20000] (10/19 22:46:35.131):{0x9E0} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E14 - IDispatch error #3092 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid column name 'rsaAuthSupport'." Native error = 207
[20000] (10/19 22:46:35.131):{0x9E0} [CBESDBInstaller::ExecuteDDL] SQL Error for:
DELETE FROM BASMetaDataDefinitions WHERE PlugInId = 106
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, DefaultValue,
DoesModifyRequireRestartWarning, IntegerMaximumValue, IntegerMinimumValue,
StringValidationType, StringLengthMinimumValue, StringLengthMaximumValue)
VALUES(1,106,2,'QueryLimit',1,50,0,65535,1,null,nu ll,null)
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId, Name, IsMandatory, DefaultValue,
DoesModifyRequireRestartWarning, IntegerMaximumValue, IntegerMinimumValue,
StringValidationType, StringLengthMinimumValue, StringLengthMaximumValue)
VALUES(2,106,0,'EnableDataCompression',1,0,0,null, null,null,null,null)
INSERT INTO BASMetaDataDefinitions(MetaDataDefinitionId, PlugInId, DataTypeId
[10000] (10/19 22:46:35.131):{0x9E0} An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement.
[30000] (10/19 22:46:46.137):{0x17A0} <5>Oct 19 22:46:46 blackberry01 {0x1798} 0204: (#30000) [PIPTOOL]: Cancelling PIPTool from CDBInfoDlg.
[30000] (10/19 22:46:46.137):{0x17A0} <3>Oct 19 22:46:46 blackberry01 {0x1798} 0205: (#10000) [PIPTOOL]: Executing stop from CDBInfoDlg.
[40000] (10/19 22:46:46.137):{0x17A0} LogReceiver: Code on closing = 10038
[30000] (10/19 22:46:46.137):{0x17A0} [DIAG] EVENT=Unregister_thread, THREADID=0x17A0, THREADNAME="InstLogReceiver"

I have searched high and low for any indication, bu no luck.. Any help would be appreciated.

TIA
Offline  
Old 10-19-2009, 06:41 PM   #2 (permalink)
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Post Thanks: 0
Thanked 17 Times in 16 Posts
Default

Are you using MSDE or SQL?
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 10-19-2009, 06:43 PM   #3 (permalink)
New Member
 
Join Date: Aug 2007
Model: 8800
PIN: N/A
Carrier: TDC
Posts: 14
Post Thanks: 0
Thanked 0 Times in 0 Posts
Default Using MSDE

But would have no problem going to SQL Express 2005 or later
Offline  
Closed Thread


Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On





Copyright 2004-2014 BlackBerryForums.com.
The names RIM and BlackBerry are registered Trademarks of BlackBerry Inc.