Pete Rawlings 2.Nov.06 08:09 PM a Web browser LEILEI - 6.5Windows NT
I am trying to get Timestamp replication working between Notes and DB2, and no matter what I try I cannot get it to work. All traces and logs show that it should work it just doesnt.
I have stripped it down to 5 fields , One key , two data, two datetime .
Empty DB2 table with same 5 fields.
Notes is Source and Db2 Target . Order connectors set on both sides. Replicate Timestamps unticked in activity . Only Skip Deletions ticked in Activity both sides. Reduced Precision selected
Create record in notes , run activity ..... fine record in DB2.
Go into DB2 update one of the data fields and one datetime field using CURRENT TIMESTAMP .
Check that time is later than SrcTimeStamp and DestTimeStamp and later than in record . It is.
Run job again Get conflict with Data field BUT the DB2 record is overwritten with the original data where I expect the Notes side to be updated .
Save the conflict metadata and can see data and timestamp and its as expected . I cannot understand why the Notes side is not updated , it looks like Primary key replication with the timestamp being ignored.
This is the log :
ZSTAMPU is the Timesatmp field and KeyValue and ZNOTESID are the key fields .
11/02/2006 06:29:07 PM Activity started
11/02/2006 06:29:10 PM Trace Statement: <SELECT ZNOTESID,ZPMAKE,ZSTAMPC,ZSTAMPU,ZVEND FROM ORB.ORBTMIWV WHERE (ZSTAMPU > TIMESTAMP ('2006-11-02-18.16.14.59') AND ZSTAMPU <= TIMESTAMP ('2006-11-02-18.29.09.43') ) ORDER BY ZNOTESID>, Connector 'Pete DB2', Method -Select-
11/02/2006 06:29:11 PM Trace Statement: <SELECT * FROM ORB.ORBTMIWV WHERE 0 = 1>, Connector 'Pete DB2', Method -Update-
11/02/2006 06:29:11 PM Trace Statement: <UPDATE ORB.ORBTMIWV SET ZPMAKE=?,ZVEND=?,ZSTAMPC=?,ZSTAMPU=? WHERE ZNOTESID=?>, Connector 'Pete DB2', Method -Update-
11/02/2006 06:29:11 PM *Replication Conflict* Action: Update at Connector B;
Mismatch in field 'ZPMAKE';
Record key values: KeyValue = "K4541"
11/02/2006 06:29:11 PM Activity finished
If anybody can shed any light on this I would be extremely grateful as I have been pulling my hair out for 3 days and there is not much left.
Return to top
Timestamp Replication - completey b... (Pete Rawlings 2.Nov.06)
. . 
Print this page
