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] "
There are duplicate ids in the source file.
Always check the source files for duplicates when an error about duplicates occurs. Remove those duplicates.
Send us your feedback: We're always looking for advice to help improve our Knowledge Base! Please let us know if this article was helpful or provide feedback on how we can improve your experience here.