Error when syncing Affiliations offline: duplicate value found: External_Id_vod__c duplicates value on record with id.
There are several ways this error can occur:
- A user creates an Affiliation Online, does not sync the changes, and then creates the affiliation again Offline. On the next sync, the rep returns a Duplicate Affiliation error, since it already exists Online.
- A User creates an affiliation and syncs the record Online. A different user creates the same affiliation and tries to sync the record Online. The other user receives the Duplicate Affiliation error because the affiliation already exists.
- The Data team loads affiliations for the reps. A User creates an affiliation Offline that is loaded Online. Since the user did not run the sync, the affiliation does not appear immediately Offline. The user syncs. A Duplicate Affiliation error occurs because it exists online.
- The user should have edit FLS to the Disable_Trigger_vod__c field on the Affiliations object.
If a user has Delete Permissions to Affiliation_vod__c, the user is able to delete these records using the Errors tab Offline.
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.