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
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.
Thank you