KB38826: Violation of PRIMARY KEY constraint...

Expand / Collapse

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

Article ID: 50992 - Last Review: October 21, 2010


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


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 ---


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




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.


CCM version 5.7 SP1

Keywords: 38826

Rate this Article:

Add Your Comments

Name: *
Email Address:
Web Address:
Verification Code:

Last Modified:Friday, January 21, 2011
Last Modified By: kmiddlemiss
Article not rated yet.
Article has been viewed 2,923 times.