Violation of PRIMARY KEY constraint in Replication

Question

Post reply

Violation of PRIMARY KEY constraint in Replication

phani404

SSC Veteran

Points: 281
More actions
October 21, 2013 at 3:28 am

#284063

Violation of PRIMARY KEY constraint 'PK_table_access_id'. Cannot insert duplicate key in object 'dbo.table_access_id'. The duplicate key value is (268435492, 1). (Source: MSSQLServer, Error number: 2627)
Get help: http://help/2627
Can any one please help how to get sequence numbers to check in sp_browsereplcmd?

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sean Pearce SSCoach Points: 15999 More actions · Answer 1

Is this error on the subscriber?

The SQL Guy @ blogspot[/url]

@SeanPearceSQL

About Me[/url]

deep_kkumar Hall of Fame Points: 3243 More actions · Answer 2

there must be some other process on the subscriber which might have inserted that row. Try to delete that row from the subscriber after saving the data. The replication should re insert that row.

durai nagarajan SSCoach Points: 15778 More actions · Answer 3

phani404 (10/21/2013)
Violation of PRIMARY KEY constraint 'PK_table_access_id'. Cannot insert duplicate key in object 'dbo.table_access_id'. The duplicate key value is (268435492, 1). (Source: MSSQLServer, Error number: 2627)
Get help: http://help/2627
Can any one please help how to get sequence numbers to check in sp_browsereplcmd?

Is that a identity column?

Regards
Durai Nagarajan