I'm trying to update our BES server from 5.0.2 to 5.0.3 and during the first step we get an error message. "An attempt to upgrade the database was unsuccessful. An error occurred while executing an SQL Statement." I found a knowledge base article which describes the problem but doesn't give a solution.
http://btsc.webapps.blackberry.com/btsc/viewdocument.do?noCount=true&externalId=KB24111&sliceId=1&cm...
Setup Log:
[20000] (04/11 08:39:29.369):{0x1E18} [CBESDBInstaller::executeRetryDDL] COM Error 0x80040E2F - IDispatch error #3119 - Source: "Microsoft OLE DB Provider for SQL Server" - Description "Violation of PRIMARY KEY constraint 'PK_BASAuthenticationCredentials'. Cannot insert duplicate key in object 'dbo.BASAuthenticationCredentials'." Native error = 2627
[20000] (04/11 08:39:29.370):{0x1E18} [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] (04/11 08:39:29.370):{0x1E18} [CBESDBInstaller::executeRetryDDL] SQL Error for:
IF EXISTS (SELECT * FROM BASAuthenticationCredentials WHERE AuthenticationType=1 AND AuthenticatorIdentifier=111 AND CredentialIdentifier = 'AD')
BEGIN
UPDATE BASAuthenticationCredentials SET CredentialIdentifier = 'AD:'
WHERE AuthenticationType=1 AND AuthenticatorIdentifier=111 AND CredentialIdentifier = 'AD'
END
