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


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

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

Forum Jump


Schneider 140CPU65150 Processor/Controller MODICON Quantum NEW picture

Schneider 140CPU65150 Processor/Controller MODICON Quantum NEW

$2899.00



PROFACE PFXSP5B10 Processor Module picture

PROFACE PFXSP5B10 Processor Module

$1500.00



AlphaSmart Neo2 Laptop Word Processor, . picture

AlphaSmart Neo2 Laptop Word Processor, .

$90.00



WAGO PFC200 Gen.2 CPU (750-8212) New with Seal  picture

WAGO PFC200 Gen.2 CPU (750-8212) New with Seal

$646.92



New Allen-Bradley AB 1747-L532 /D SLC 500 SLC 5/03 CPU Processor Unit 1747L532 picture

New Allen-Bradley AB 1747-L532 /D SLC 500 SLC 5/03 CPU Processor Unit 1747L532

$394.70



AB 1756-L73 SER B ControlLogix Logix5573 Processor 1756-L73 New Factory Sealed picture

AB 1756-L73 SER B ControlLogix Logix5573 Processor 1756-L73 New Factory Sealed

$2926.50







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