10-28-2012 03:50 AM
[30000] (10/28 00:23:37.177):{0x14A4} SQL being executed:
IF 'ExchangeX' IN ('Exchange','ExchangeX')
BEGIN
DECLARE @BASpluginid INT
DECLARE @pluginid INT
DECLARE @capabilityKey INT
SET @BASpluginid = 0
DELETE FROM BASRoleCapabilityScopeInstances WHERE CapabilityDefinitionKey IN (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId IN (101, 102))
DELETE FROM BASRoleCapabilities WHERE CapabilityDefinitionKey IN (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId IN (101, 102))
DELETE FROM BASCapabilityDefinitions WHERE PlugInId IN (101, 102)
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 0)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 0, 1, 0)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 1, ScopeDomainType = 0 WHERE PlugInId = 100 AND CapabilityId = 0
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 1)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 1, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 1
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 2)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 2, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 2
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 3)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 3, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 3
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 4)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 4, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 4
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 5)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 5, 0, 0)
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 6)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 6, 0, 1)
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 7)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 7, 0, 0)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 0 WHERE PlugInId = 100 AND CapabilityId = 7
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 8)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 8, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 8
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 9)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 9, 1, 0)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 1, ScopeDomainType = 0 WHERE PlugInId = 100 AND CapabilityId = 9
END
DECLARE @roleId INT
SET @roleId = (SELECT NameAndDescriptionInstanceId
FROM BASLocaleNamesAndDescriptions
WHERE NameAndDescriptionTypeId = 8
AND PlugInId = 0
AND Locale = 'en_US'
AND Sequence = 1
AND Name = 'Security Administrator')
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 0)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 1)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXISTS (SELECT * FROM BASRoleCapabilityScopeInstances
WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey AND ScopeId = -1)
BEGIN
INSERT INTO BASRoleCapabilityScopeInstances (RoleId, CapabilityDefinitionKey, ScopeId) VALUES (@roleId, @capabilityKey, -1)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 2)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXISTS (SELECT * FROM BASRoleCapabilityScopeInstances
WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey AND ScopeId = -1)
BEGIN
INSERT INTO BASRoleCapabilityScopeInstances (RoleId, CapabilityDefinitionKey, ScopeId) VALUES (@roleId, @capabilityKey, -1)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 3)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXISTS (SELECT * FROM BASRoleCapabilityScopeInstances
WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey AND ScopeId = -1)
BEGIN
INSERT INTO BASRoleCapabilityScopeInstances (RoleId, CapabilityDefinitionKey, ScopeId) VALUES (@roleId, @capabilityKey, -1)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 4)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXISTS (SELECT * FROM BASRoleCapabilityScopeInstances
WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey AND ScopeId = -1)
BEGIN
INSERT INTO BASRoleCapabilityScopeInstances (RoleId, CapabilityDefinitionKey, ScopeId) VALUES (@roleId, @capabilityKey, -1)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 5)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 6)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXISTS (SELECT * FROM BASRoleCapa
[20000] (10/28 00:23:37.802):{0x14A4} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E2F - IDispatch error #3119 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "The DELETE statement conflicted with the REFERENCE constraint "FK_BASRoleCapabilityScopeInstances_BASRoleCapabil ities". The conflict occurred in database "BESMgmt", table "dbo.BASRoleCapabilityScopeInstances"." Native error = 547
[20000] (10/28 00:23:37.802):{0x14A4} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E2F - IDispatch error #3119 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "The statement has been terminated." Native error = 3621
[20000] (10/28 00:23:37.802):{0x14A4} [CBESDBInstaller::executeRetryDDL] SQL Error for:
IF 'ExchangeX' IN ('Exchange','ExchangeX')
BEGIN
DECLARE @BASpluginid INT
DECLARE @pluginid INT
DECLARE @capabilityKey INT
SET @BASpluginid = 0
DELETE FROM BASRoleCapabilityScopeInstances WHERE CapabilityDefinitionKey IN (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId IN (101, 102))
DELETE FROM BASRoleCapabilities WHERE CapabilityDefinitionKey IN (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId IN (101, 102))
DELETE FROM BASCapabilityDefinitions WHERE PlugInId IN (101, 102)
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 0)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 0, 1, 0)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 1, ScopeDomainType = 0 WHERE PlugInId = 100 AND CapabilityId = 0
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 1)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 1, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 1
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 2)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 2, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 2
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 3)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 3, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 3
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 4)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 4, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 4
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 5)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 5, 0, 0)
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 6)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 6, 0, 1)
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 7)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 7, 0, 0)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 0 WHERE PlugInId = 100 AND CapabilityId = 7
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 8)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 8, 0, 2)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 0, ScopeDomainType = 2 WHERE PlugInId = 100 AND CapabilityId = 8
END
IF NOT EXISTS (SELECT * FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 9)
BEGIN
INSERT INTO BASCapabilityDefinitions (PlugInId, CapabilityId, ClassificationType, ScopeDomainType) VALUES (100, 9, 1, 0)
END
ELSE
BEGIN
UPDATE BASCapabilityDefinitions SET ClassificationType = 1, ScopeDomainType = 0 WHERE PlugInId = 100 AND CapabilityId = 9
END
DECLARE @roleId INT
SET @roleId = (SELECT NameAndDescriptionInstanceId
FROM BASLocaleNamesAndDescriptions
WHERE NameAndDescriptionTypeId = 8
AND PlugInId = 0
AND Locale = 'en_US'
AND Sequence = 1
AND Name = 'Security Administrator')
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 0)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 1)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXISTS (SELECT * FROM BASRoleCapabilityScopeInstances
WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey AND ScopeId = -1)
BEGIN
INSERT INTO BASRoleCapabilityScopeInstances (RoleId, CapabilityDefinitionKey, ScopeId) VALUES (@roleId, @capabilityKey, -1)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 2)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXISTS (SELECT * FROM BASRoleCapabilityScopeInstances
WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey AND ScopeId = -1)
BEGIN
INSERT INTO BASRoleCapabilityScopeInstances (RoleId, CapabilityDefinitionKey, ScopeId) VALUES (@roleId, @capabilityKey, -1)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 3)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXISTS (SELECT * FROM BASRoleCapabilityScopeInstances
WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey AND ScopeId = -1)
BEGIN
INSERT INTO BASRoleCapabilityScopeInstances (RoleId, CapabilityDefinitionKey, ScopeId) VALUES (@roleId, @capabilityKey, -1)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 4)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXISTS (SELECT * FROM BASRoleCapabilityScopeInstances
WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey AND ScopeId = -1)
BEGIN
INSERT INTO BASRoleCapabilityScopeInstances (RoleId, CapabilityDefinitionKey, ScopeId) VALUES (@roleId, @capabilityKey, -1)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 5)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
SET @capabilityKey = (SELECT CapabilityDefinitionKey FROM BASCapabilityDefinitions WHERE PlugInId = 100 AND CapabilityId = 6)
IF NOT EXISTS (SELECT * FROM BASRoleCapabilities WHERE RoleId = @roleId AND CapabilityDefinitionKey = @capabilityKey)
BEGIN
INSERT INTO BASRoleCapabilities (RoleId, CapabilityDefinitionKey) VALUES (@roleId, @capabilityKey)
END
IF NOT EXIS
[10000] (10/28 00:23:37.818):{0x14A4} An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL statement.
I'm not a DB guy. I think the problem is indicated by this error:
[20000] (10/28 00:23:37.802):{0x14A4} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E2F - IDispatch error #3119 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "The DELETE statement conflicted with the REFERENCE constraint "FK_BASRoleCapabilityScopeInstances_BASRoleCapabil ities". The conflict occurred in database "BESMgmt", table "dbo.BASRoleCapabilityScopeInstances"." Native error = 547Can someone help please?
I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier
10-29-2012 09:32 AM
I dont see much on that Native error = 547
you will need to call support assuming you did the install while logged in as BESAdmin and not a domain admin
Click here to Backup the data on your BlackBerry Device! It's important, and FREE!
BESAdmin's, please make a signature with your BES environment info. SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope
10-29-2012 04:03 PM
I did use BESAdmin. I'll call support shortly.
I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier
10-31-2012 10:12 AM
did you get it fixed?
Click here to Backup the data on your BlackBerry Device! It's important, and FREE!
BESAdmin's, please make a signature with your BES environment info. SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope
10-31-2012 11:46 AM