[aarrarte]

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.

[bulletooth]

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.