Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
fazle_rabbee
Yak Posting Veteran
63 Posts |
 Posted - 2012-08-11 : 12:55:02
|
| At the time of doing a task its showing an Error: Cannot insert duplicate key row in object 'dbo.MSmerge_tombstone'with unique index'uc1MSmerge_tombstone'. Looking to hearing from you.fazle rabbee |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-11 : 16:47:37
|
| question is vague. which task? is it sql agent job? where are you creating it?the error is explicit thoughyou're trying to insert duplicate values to column containing unique constraint. so modify the insert statement to insert only distinct value for field------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
fazle_rabbee
Yak Posting Veteran
63 Posts |
Posted - 2012-08-12 : 00:01:26
|
| The task is Billing. It was going nice and smooth till yesterday afternoon. From the evening the problem begin to occur. We are using merge Replication with Push subscription. Any other info needed??fazle rabbee |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-12 : 11:51:41
|
quote:
Originally posted by fazle_rabbee
The task is Billing. It was going nice and smooth till yesterday afternoon. From the evening the problem begin to occur. We are using merge Replication with Push subscription. Any other info needed??fazle rabbee
is insert done using a procedure? check the logic. it seems the relationship used between tables is not proper causing it to return duplicates------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Error at the time of doing a task