Table of Contents

Search

  1. Preface
  2. IDR-000000 to IDR-000731
  3. IDR-008001 to IDR-008006
  4. IDR-009001 to IDR-009055
  5. IDR-010002 to IDR-010821
  6. IDR-020001 to IDR-020264
  7. IDR-030001 to IDR-031230
  8. IDR-050001 to IDR-053223
  9. IDR-060002 to IDR-060124
  10. IDR-070002 to IDR-070361
  11. IDR-100001 to IDR-100030
  12. IDR-110030 to IDR-110031
  13. IDR-120001 to IDR-120007
  14. IDR-130001 to IDR-130053
  15. IDR-140001 to IDR-140054
  16. IDR-150001 to IDR-150017
  17. CDCPUB_10001 to CDCPUB_16001

IDR- 070319

IDR-
070319

[INFO] Could not find a logical primary key in the source table
source_table_name
with supplemental logging enabled on its columns. The Applier will apply each Update as a pair of Delete and Insert operations.
To replicate Updates and Deletes in Merge Apply mode, Data Replication requires source tables to have a logical primary key. The Applier uses this logical primary key to uniquely identify rows on the target. If source table definitions include primary keys or unique indexes, Data Replication uses these keys or indexes as the logical primary key. However, the Applier did not find a primary key or unique index with all of its columns supplementally logged for a source table in the configuration. Consequently, the Applier will apply each Update as a pair of Delete and Insert operations for the table.
In the Data Replication Console, ensure that the source table has a primary key or unique index with all of its columns supplementally logged or create a virtual index for the table and enable supplemental logging on its columns.

0 COMMENTS

We’d like to hear from you!