all groups > sql server replication > april 2004 >
You're in the

sql server replication

group:

Insert Duplicate Key Row


Insert Duplicate Key Row Mike
4/29/2004 3:19:37 PM
sql server replication:

I received error message indicating:

Cannot insert duplicate key row in
object 'MFA_XferPriceValue' with unique
index 'COP_XferPriceValueInWorkPK'.

The record has inserted in the both databases.

Please help me resolve this problem, are a work around to
this problem.

Thank You,

Mike


Last Command:

insert into "MFA_XferPriceValue" values (1683546,
20040429160002, {ts '2004-04-29 16:00:00'}, 10, 'NAWC',
111126, 235, 227, 1661, NULL, NULL, NULL, NULL, 19, 3,
NULL, 'S', NULL, {ts '2078-12-31 00:00:00'}, 'W', 'ramq2',
{ts '2004-04-29 16:00:00'}, 'ramq2', {ts '2004-04-29
16:00:00'})
Transaction sequence number and command ID of last
execution batch are 0x0000965C00000E59008800000000 and
17474.

Error Message:

Cannot insert duplicate key row in
object 'MFA_XferPriceValue' with unique
index 'MFA_XferPriceValue' .

Error details:

Cannot insert duplicate key row in
object 'MFA_XferPriceValue' with unique
index 'MFA_XferPriceValue'.
(Source: MFAKSQL2\VSQL_REPT (Data source); Error number:
2601)

RE: Insert Duplicate Key Row Denny
4/29/2004 4:06:01 PM
Sounds like the issue in MS Article 81349

http://support.microsoft.com/default.aspx?scid=kb;en-us;81349
AddThis Social Bookmark Button