KB38826: Violation of PRIMARY KEY constraint 'PK_tblSubscriptions_1'. Cannot insert duplicate key in object 'dbo.tblSubscriptions'. error

PROBLEM

A Violation of PRIMARY KEY constraint 'PK_tblSubscriptions_1'. Cannot insert duplicate key in object 'dbo.tblSubscriptions'. error may been seen.

SYMPTOMS

Periodically, you may see the following error in the ConfigService, EnterpriseServicesProxyManagement, or the EnterpriseServer log:

System.Data.SqlClient.SqlException: Violation of PRIMARY KEY constraint 'PK_tblSubscriptions_1'. Cannot insert duplicate key in object 'dbo.tblSubscriptions'.
The statement has been terminated.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at prairieFyre.DataAccess.Commands.Communications.proc_InsertUpdatetblSubscriptions.Execute()
at prairieFyre.EnterpriseServices.SubscriptionManager.AddSubscriptionToSQL(SubscribeRequest aRequest, Guid aSubscriptionID, DateTime aExpiry)
at prairieFyre.EnterpriseServices.SubscriptionManager.AddSubscription(SubscribeRequest request)--- End Exception Stack ---

CAUSE

When an existing subscription record was found, the proc_InsertUpdatetblSubscriptions would try to update the tblSubscriptions SubscriptionID field with a new guid.

WORKAROUND

None.

RESOLUTION

This hotfix, along with all other CCM version 5.7 sp1 hotfixes created before January 2010, have been rolled up into one single hotfix.
The 5.7 sp1 Rollup of Hotfixes is available at the following link: KB41351

The original hotfix for this specific issue is no longer available and you must install the rollup.

APPLIES TO

CCM version 5.7 SP1

Keywords: 38826