BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 10-19-2009, 04:58 PM   #1
danishrulez
New Member
 
Join Date: Aug 2007
Model: 8800
PIN: N/A
Carrier: TDC
Posts: 14
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, 05:41 PM   #2
x14
BlackBerry Extraordinaire
 
Join Date: Jul 2005
Location: NYC
Model: 9800
OS: 6.0.0.546
Carrier: AT&T
Posts: 2,344
Default

Are you using MSDE or SQL?
__________________
Exchange 2007/BES 5.0.2 MR2
Offline  
Old 10-19-2009, 05:43 PM   #3
danishrulez
New Member
 
Join Date: Aug 2007
Model: 8800
PIN: N/A
Carrier: TDC
Posts: 14
Default Using MSDE

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



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

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


Semiconductor Refrigeration Cooler Thermoelectric Peltier Cold Plate 240W SALE  picture

Semiconductor Refrigeration Cooler Thermoelectric Peltier Cold Plate 240W SALE

$34.20



150mm/6

150mm/6" Semiconductor 15-Tray Wafer Cassette/Magazine for Robotic Inspection

$349.00



Peak, Atlas DCA55 Semiconductor Tester,  picture

Peak, Atlas DCA55 Semiconductor Tester,

$97.99



Dual Range Transistor Diode Semiconductor & Passive Curve Tracer Tester/Tracker picture

Dual Range Transistor Diode Semiconductor & Passive Curve Tracer Tester/Tracker

$26.99



5pcs STK412-170 Original Pulled Sanyo Semiconductor picture

5pcs STK412-170 Original Pulled Sanyo Semiconductor

$49.00



Red P P4 phos semiconductor grade . 99% pure. 25grams picture

Red P P4 phos semiconductor grade . 99% pure. 25grams

$55.00







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