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



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


Vintage 68040 XC68040RC40M MC68040RC40 CPU 40MHz PGA 1PC Apple Macintosh Amiga picture

Vintage 68040 XC68040RC40M MC68040RC40 CPU 40MHz PGA 1PC Apple Macintosh Amiga

$80.17



New Greaseweazle V4.1 USB Floppy Adapter Flux Reader Writer Amiga 1591 picture

New Greaseweazle V4.1 USB Floppy Adapter Flux Reader Writer Amiga 1591

$28.23



Motorola 68060 68EC060 MC68EC060RC75 CPU / Processor AMIGA unused, new USA stock picture

Motorola 68060 68EC060 MC68EC060RC75 CPU / Processor AMIGA unused, new USA stock

$69.99



New Greaseweazle V4.1 USB Floppy Adapter Flux Reader Writer Amiga PC Case 1598 picture

New Greaseweazle V4.1 USB Floppy Adapter Flux Reader Writer Amiga PC Case 1598

$35.99



Camera Precise Positioning Support Video Record for Acmer Laser Engraving picture

Camera Precise Positioning Support Video Record for Acmer Laser Engraving

$150.78



Mitsubishi FR-A540-0.75K-NA AC DRIVE INVERTER 1 HP 380-480 VAC 50/60 HZ 4.1 AMP  picture

Mitsubishi FR-A540-0.75K-NA AC DRIVE INVERTER 1 HP 380-480 VAC 50/60 HZ 4.1 AMP

$649.99







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