Welcome!

Welcome to the official BlackBerry Support Community Forums.

This is your resource to discuss support topics with your peers, and learn from each other.

inside custom component

BlackBerry® Enterprise Service 10

Reply
Contributor
mkozak
Posts: 22
Registered: ‎04-12-2010
My Device: z10

BES 5.0.2 upgrade to 5.0.3, An error occured while executing an sql statement

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

Please use plain text.
Guru III
knottyrope
Posts: 30,622
Registered: ‎06-25-2008
My Device:

I'm rockin the BlackBerry Passport, Z30, Z10, Q10, BlackBerry Mini Stereo Speaker, 64 gig PlayBook, BlackBerry Wireless Headset HS-700

My Carrier: I am on AT&T. Please edit your Personal Profile with your DEVICE TYPE, DEVICE OS and Carrier

Re: BES 5.0.2 upgrade to 5.0.3, An error occured while executing an sql statement

Workaround

 
Please contact support to obtain the Microsoft® SQL Server® script to remove the entry from the database.

 




Click here to Backup the data on your BlackBerry Device! It's important, and FREE!


Click "Accept as Solution" if your problem is solved. To give thanks, click thumbs up
Click to search the Knowledge Base at BTSC and click to Read The Fabulous Manuals

BESAdmin's, please make a signature with your BES environment info.


SIM Free BlackBerry Unlocking FAQ
Follow me on Twitter @knottyrope


Want to thank me? Buy my KnottyRope App here


BES 12 and BES 5.0.4 with Exchange 2010 and SQL 2012 Hyper V


Please use plain text.