I have a connection between LEI and Oracle. A notes database is updateing the oracle database, one way only. Everything works great except if there is a field in Oracle that Notes is not touching, this field gets erased and set to blank. Is there anything I can do to stop this? It feels like notes is always inserting the documents by deleting everything in Oracle and Replacing it by the notes database information, instead of updating and inserting new data…
Anyone with any ideas
thankx
Subject: LEI 6 & Oracle
This is a year late… but its rare I have a definitive answer to share.
Ensure that you have the Skip Deletions checked under the Target Restrictions area of the Replication Acvtivity.
Subject: LEI 6 & Oracle
Hi Mike,
If you are using a “Direct Transfer” activity then make sure under the “Direct Transfer Options”… “Target Data”, you have Try Update Before Insert selected. And make sure you are specifying the valid “Key” field(s).
HTH.
Mark
Subject: RE: LEI 6 & Oracle
Mark, unfortunatly it is not a “direct transfer” activity, it is a replication activity, and it still deletes all data and then it inserts… this is not how relplication should work…
any ideas?
thanks
Subject: RE: LEI 6 & Oracle
Hi Mike,
This is not how it should work.
Sounds like a sorting issue to me. You may need to use an Order Connection to stop this from happening. Try to determine how both sides are sorting the data. What generally happens is the table on the relational side is in the reverse order of the view on the Notes side. When they replicate they look line to line and the keys don’t match so they delete and create instead of updating.
HTH