Kbase P26021: PeerDirect first replication fails
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/28/2003 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1D
FACT(s) (Environment):
PeerDirect 6.1
SYMPTOM(s):
PeerDirect first replication fails
Service Pack 5 and TF 15 applied
E 01aa 0516-15:07:48 ODBC Error -1: (23000) '[DataDirect][ODBC PROGRESS driver][PROGRESS]Integrity constraint violation:uniqueness constraint violation (7518)' <-10102,SQLExecute>
E 01aa 0516-15:07:48 ODBC statement failed: -1 from function Execute
E 01aa 0516-15:07:48 ODBC statement: INSERT INTO "PUB".<table> (<fields>) VALUES (<values>)
E 01aa 0516-15:07:48 Unable to insert new record into table <table> having key:
<primary key index values>
E 01aa 0516-15:07:48 FSM:{An ODBC error occurred}: Unable to store next PDZIJW5Y002.<table> record from partner's data list (key:PDCID(<id_number>))
I 01aa 0516-15:07:48 SMSG: (pdre,33236)-Update of <table> in <remote DB> ) - PDZIJW5Y002 failed
E 01aa 0516-15:07:48 Update of of <table> in <remote DB> - PDZIJW5Y002 failed
E 01aa 0516-15:07:48 An error occurred in the sync session envelope.
W 01aa 0516-15:07:48 Rolling back uncommitted transactions
CAUSE:
Databases are out of sync and PeerDirect replication does not start correctly since it needs both databases to be correctly synchronized
FIX:
Restore the main database, and restart the full PeerDirect replication start up procedure.