March 20, 2012 at 3:58 am
I get the following error
Cannot insert duplicate key row in object 'dbo.HBL_WORK_GROUP' with unique index 'HBL_WORK_GROUP0'. (Source: MSSQLServer, Error number: 2601)
Get help: http://help/2601
what concerns me is that the source and target table are currently identical and there are no changes in the source that need to be updated or inserted into the target table
March 20, 2012 at 4:37 am
You say the tables are identical... are you talking about data and schema?
An extra unique index or additional/different trigger on the subscriber could cause problems.
March 20, 2012 at 5:38 am
Data, schema and index's are all the same.
Its a very small table there are only 30 rows
March 20, 2012 at 5:47 am
Which replication agent are you getting the error from?
March 20, 2012 at 5:52 am
The Distribution to Subscriber,
my assumption is that one of the other tables in the list of articles is causing a problem beacause ther arent any changes to apply on this table from the source.
March 20, 2012 at 8:39 am
This may be because of the object HBL_WORK_GROUP is added in two publications .
Execute the below query in transaction DB and find the publication name
select sa.name,sp.name from syspublications sp
inner join sysextendedarticlesview sa
on sp.pubid= sa.pubid
where sa.name='HBL_WORK_GROUP'
if exists in two publication remove it from any one of them.
March 21, 2012 at 6:20 am
That was it, it was updated so infrequently the problem never became apparent until now. removed it from one of the two and re-initialised and its all back to normal thanks
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply