Dbvisit Community Dbvisit home       

Go Back   Dbvisit Community > Dbvisit Replicate - Technical > Dbvisit Replicate - Conflicts

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 06-20-2012, 11:00 PM
Arjen Visser Arjen Visser is offline
Dbvisit Team
 
Join Date: Jan 2008
Location: Auckland, New Zealand
Posts: 381
Default Command affected 2 row(s).

There is a conflict.
The message is: Command affected 2 row(s).

The conflicting SQL is (obtained from running dbvrep> list conflict):
delete from ELOARCHIV."ELOFTREL" where (1=1)and WORDID = 590 and DOCID = 1880243

Solution
What is the primary key for this table (both on source and target)?
What is the result of:
select * from ELOARCHIV."ELOFTREL" where (1=1)and WORDID = 590 and DOCID = 1880243

For replication to work ONE of the following must be true:
  1. The target table has a primary key, or
  2. The target table has a unique key, or
  3. Each record in the table must be uniquely identifyable
If none of the above conditions hold true, then there will be a conflict. The data or structure of the data must be adjusted so that one of the above conditions is true.
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +12. The time now is 07:14 PM.