BlackBerry Forums Support Community               

Closed Thread
 
LinkBack Thread Tools
Old 09-12-2008, 03:00 PM   #1 (permalink)
New Member
 
Join Date: Sep 2008
Model: 8800
PIN: N/A
Carrier: M3Wireless
Posts: 1
Post Thanks: 0
Thanked 0 Times in 0 Posts
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 (permalink)
Thumbs Must Hurt
 
Join Date: Dec 2007
Model: 9700
PIN: N/A
Carrier: T-Mobile
Posts: 120
Post Thanks: 0
Thanked 0 Times in 0 Posts
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

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.