Overview:
When running a source subscription, an error appears in the Job Error History section:
"Unique index or primary key violation: "ARCHIVE_PRIMARY ON ARCHIVE.ARCHIVE(VDM_ENTITY_ID) VALUES ('000XXXCF:0CE4BFFFD5DXXXXX', 2)"; SQL statement: CREATE PRIMARY KEY IF NOT EXISTS archive.ARCHIVE_PRIMARY ON archive.ARCHIVE (VDM_ENTITY_ID) [XXXXX-XXX] "
Root Cause:
There are duplicate ids in the source file.
Solution:
Always check the source files for duplicates when an error about duplicates occurs. Remove those duplicates.
Related Documentation:
N/A
Thank you