BlackBerry Forums Support Community
              

Closed Thread
 
Thread Tools
Old 09-12-2008, 03:00 PM   #1
aarrarte
New Member
 
Join Date: Sep 2008
Model: 8800
PIN: N/A
Carrier: M3Wireless
Posts: 1
Default BES v4.1 SP6 - Database Upgrade Error

Please Login to Remove!

Hello Everyone,

I am trying to upgrade my BES version 4.1 from SP3 to SP6.
When I run the upgrade process, I get the following error:
"An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement."

In the installation logs, the following error is displayed:
[30000] (09/12 15:56:41.996):{0x1C68} SQL being executed:
CREATE TRIGGER dbo.HistoryBASTraitsTrigger ON dbo.BASTraits
FOR INSERT, UPDATE
NOT FOR REPLICATION
AS
SET NOCOUNT ON
DECLARE @Operation CHAR(1),
@ObjectDefnId INT,
@ServerConfigId INT,
@UserConfigId INT
IF EXISTS (SELECT * FROM deleted)
BEGIN
SET @Operation = 'U'
END
ELSE
BEGIN
SET @Operation = 'I'
END


-- SmartSync
IF EXISTS (SELECT * FROM INSERTED WHERE TraitId BETWEEN 3 AND 8 AND PluginId = 100)
BEGIN
SET @ObjectDefnId = dbo.GetObjectIdForObjectName('SmartSync')

-- Domain level SmartSync
INSERT INTO ServerConfigHistory
(SecDisplayName, ChangeNumber, ObjectDefnId, ConfigId, Operation, Details)
SELECT system_user, Lurnum, @ObjectDefnId, TraitKey, @Operation, 'SmartSync'
FROM inserted i
WHERE TraitId BETWEEN 3 AND 8 AND PluginId = 100

[20000] (09/12 15:56:42.012):{0x1C68} [CBESDBInstaller::ExecuteDDL] COM Error 0x80040E37 - IDispatch error #3127 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Invalid object name 'dbo.BASTraits'." Native error = 208
[20000] (09/12 15:56:42.012):{0x1C68} [CBESDBInstaller::ExecuteDDL] SQL Error for
CREATE TRIGGER dbo.HistoryBASTraitsTrigger ON dbo.BASTraits
FOR INSERT, UPDATE
NOT FOR REPLICATION
AS
SET NOCOUNT ON

DECLARE @Operation CHAR(1),
@ObjectDefnId INT,
@ServerConfigId INT,
@UserConfigId INT

IF EXISTS (SELECT * FROM deleted)
BEGIN
SET @Operation = 'U'
END
ELSE
BEGIN
SET @Operation = 'I'
END


-- SmartSync
IF EXISTS (SELECT * FROM INSERTED WHERE TraitId BETWEEN 3 AND 8 AND PluginId = 100)
BEGIN
SET @ObjectDefnId = dbo.GetObjectIdForObjectName('SmartSync')

-- Domain level SmartSync
INSERT INTO ServerConfigHistory
(SecDisplayName, ChangeNumber, ObjectDefnId, ConfigId, Operation, Details)
SELECT system_user, Lurnum, @ObjectDefnId, TraitKey, @Operation, 'SmartSync'
FROM inserted i
WHERE TraitId BETWEEN 3 AND 8 AND PluginId =
[30000] (09/12 15:57:05.264):{0x1C68} [PIPTOOL]: Exiting PIPTool from DBInfoDlg.


When I look at the BESTMgmt database via SQL Enterprise Mgr (SQL 2000), it is true that the table dbo.BASTraits does not exist.

If anyone has ever seen this or knows how I can get more info about why this table is missing, I would really appreciate it.
The database is running on a local instance of MS SQL 2000 Standard.

I have already tried the following:
1 - Install SP4 and SP5 before SP6. The same error is generated.
2 - Attempt both normal upgrade and MDS service upgrade.
3 - Use both Windows Authentication and SQL authentication

Thanks.
Offline  
Old 09-12-2008, 03:50 PM   #2
bulletooth
Thumbs Must Hurt
 
Join Date: Dec 2007
Model: 9700
PIN: N/A
Carrier: T-Mobile
Posts: 120
Default

I remember a similar issue to this when i upgraded to 4.1.4.

I'm no SQL admin but I do remember we had to run checks on the DB for corrupt tables and fix them BEFORE upgrading the DB. You might want to verify there are no corrupt tables within the DB.

I remember something about reindexing as well.
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

AT24C02 I2C Interface CII EEPROM Intelligent Car Storage Module For
$4.99
AT24C02 I2C Interface CII EEPROM Intelligent Car Storage Module For pictureEEPROM BIOS USB Programador CH341A + SOIC8 Clip+1,8 V0A8 SOIC8 H3J8 V G5J3
$14.72
EEPROM BIOS USB Programador CH341A + SOIC8 Clip+1,8 V0A8 SOIC8 H3J8 V G5J3 pictureEEPROM BIOS USB Programador CH341A + SOIC8 Clip+1,8 H3J8 V SOIC8 V0A8 Q9R2
$10.75
EEPROM BIOS USB Programador CH341A + SOIC8 Clip+1,8 H3J8 V SOIC8 V0A8 Q9R2 pictureEEPROM BIOS USB Programador CH341A + SOIC8 Clip+1,8 V0A8 H3J8 V SOIC8 I1A9
$12.88
EEPROM BIOS USB Programador CH341A + SOIC8 Clip+1,8 V0A8 H3J8 V SOIC8 I1A9 pictureEEPROM BIOS USB Programador CH341A + SOIC8 Clip+1,8 V0A8 SOIC8 H3J8 V A8V0
$14.72
EEPROM BIOS USB Programador CH341A + SOIC8 Clip+1,8 V0A8 SOIC8 H3J8 V A8V0 picture






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