zoltan2 beke 21.Mar.13 06:41 PM a Web browser LEILEI - 8.0Windows
We use TimeStamp Replications for daily pump our data from Notes to Oracle.
Tha appl. server is 8.5.3 on as400, the lei server is 8.5 on windows 2003. The oracle is 10.2g.
We have two serious problem.
1. Some of TimeStamp replications work as Direct Transfer, which means that replicate all documents every time, without reference to the used timestamp (@modified).
We use view at selection option in Notes Connection doc. After a successfull replication this view contains a lot of '1' value in first column (it means, it dosn't have to replicate this doc.?),
so it seems that the activity take no notice of these '1'. The selection formula of this view comes from activity document, where at 'Data Option\Conditional Clause for Source'
we set allways a simple formula (eg. Form="xxxx") and in first column the LEI calculate this sign 1 or 2 according to timestamps.
Very interesting, that we use same methodology when we configure all Replications and Connections documents, some of them work correctly, some of them fail.
2. We noticed that at the target side missing some records or not updated after the replication. These situations also happend with TimeStamp replications.
After replication we examined the situation. At the source side we found (in the mentioned view with sign '2' « must replicate.?) the missing document,
but the activity missed to insert or update this record.
Now we use Direct Transfer as a workaround, it allways transfers the records correctly.
We have read related guides and we still don't know how to deal with these situations.