duplicate value found: Zuora__SubscriptionNumber__c duplicates value on record error in sync

[joel_buaron]

Issue: when performing a sync, it returned a sync error "DUPLICATE_VALUE:duplicate value found: Zuora__SubscriptionNumber__c duplicates value on record with id: <Salesforce Id>:--" and needed to know why this error showed up and how to fix it.

[vu_phan · Accepted solution]

Solution

Manually delete the subscription (whose Id is listed in the error message) from Salesforce.  This approach is safer than performing a cleanup.