RE: LEI Replication Activity Creating Duplicate Daniel W Heichel 22.Jan.13 09:25 AM a Web browser LEI LEI - 7.0All Platforms
For the problem activity, might you possibly have Skip Deletions checked? You might have a sort order issue, which can lead to the performance problem of unnecesary inserts and deletions - but if Skip Deletions is checked on this one activity, the activity will be unable to self-correct. The net result is that you wind up with duplicate documents being created.
Another possibility - are there any formulas, scripts, or other agents acting on the data on the back-end for this one activity? If the back-end key field is being altered or if the data is being hidden, then LEI will regard the back end as legitimately not having these records, and will insert "duplicates" accordingly.
Normally I would also ask if the key fields were unique, and if they contained special characters or NULLs. These concerns can all wreak havoc on relational databases. But if the data really is identical for all four activities, and three of them run fine, then that would discount a data issue. We should be absolutely certain that the data is identical before writing off this possibility, though.
Return to top
. . RE: LEI Replication Activity Creati... (Daniel W Heiche... 22.Jan.13)
Print this page
