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


DATALOGIC ADC, GRYPHON I GD4410 2D IMAGER IBM46XX/OEM USB/RS-232 MULTI-INTERFACE picture

DATALOGIC ADC, GRYPHON I GD4410 2D IMAGER IBM46XX/OEM USB/RS-232 MULTI-INTERFACE

$259.63



NEW Genuine OEM IBM Quietwriter NON-Correctable Yellow Box #1299790 Ribbon picture

NEW Genuine OEM IBM Quietwriter NON-Correctable Yellow Box #1299790 Ribbon

$13.00



IBM CASH DRAWER KEY'S #9960 SET OF 2 KEYS. AFTERMARKET KEY'S SAME AS OEM 33G3360 picture

IBM CASH DRAWER KEY'S #9960 SET OF 2 KEYS. AFTERMARKET KEY'S SAME AS OEM 33G3360

$18.00



OEM IBM Selectric III Typewriter Replacement Keys Black picture

OEM IBM Selectric III Typewriter Replacement Keys Black

$30.00



IBM Selectric Spintite Typewriter Nut Driver Repair Tool  1/4 5/16 9900242 OEM picture

IBM Selectric Spintite Typewriter Nut Driver Repair Tool 1/4 5/16 9900242 OEM

$35.10



OEM  IBM Type 5441 WheelWriter 3 1356658 1362400-02 Main Boards Tested Working picture

OEM IBM Type 5441 WheelWriter 3 1356658 1362400-02 Main Boards Tested Working

$34.99







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