developerWorks  >  Lotus  >  Forums & community  >  Enterprise Integration Forum

Enterprise Integration Forum

developerWorks




Replication "Notes to Notes" and "one to many"
Fritz Bierwolf 11/12/2009 03:53 AM
LEI LEI - 8.0 Windows


Hy,

we use LEI 7.0 with success for Notes to Notes replication to maintain
a lot off 1:N (one to many) update-relationsships.
Updates are carried out - no insertions - no deletions.

This worked for years with LEI 7.0 but does not with
the new LEI 8.5 (on domino 8.5) (same Problem for LEI 8.0.2 and domino 8.0.2).

Unfortunateley these Activities now delete ALL destination documents
and insert new EMPTY ones. Even if delete and insert are flagged
as "Skip Insertions"/"Skip Deletions" within the activity.

The decsadm.nsf on the LEI 8.5 System has been
constructed completely from scratch to get rid of
any "history" problems.

On the other hand, it works perfectly to just
copy and paste the LEI 8.5 activity configuration
to the LEI 7.0 server again.
Updates are carried out - no insertions - no deletions.


Example:

One example is to bring additional partnumber information
(e.g. as flag "needs a batch-number" )
from the part-DB to the customer orders within the order-DB.

ONE order has only ONE part-number (not multivalue).
But there are of course a lot of orders with the same part-number.

schematic structure:

[source: Part-DB] -->
[connection to: part-FORM with Key "partnumber"] -->
[collapse/expand: grouping on "partnumber"] -->
[replication activity] -->
[collapse/expand: grouping on foreign key "iFKpart"] -->
[connection to: order-FORM with foreign Key "iFKpart"] -->
[destination: Order-DB]


Any Ideas what could be wrong betwwen 7.0 and 8.5?
Or was it just an unsupported "feature" of LEI 7.0
on which we based dozens of LEI jobs?

Any hint is highly appreciated.

Go back