Symptom
You get the Error: Relationship with role Contact Person Relationship already exists between xxxxxx and yyyyyy when creating a Contact and Contact Relationship using Data Impex tool.
Environment
-
SAP Sales Cloud and SAP Service Cloud Version 2
Reproducing the Issue
- Click on User Menu
- Go to Settings
- Go to All Settings facet
- Go to Data Import and Export
- Go to Import and Export Data
- Click on Import and click Create
- Select Entity as Contact
- Select Individual Sub-Entities
- Check Is contact person for
- Select the File Type Click on Browse Files
- Select the file and click on Import Data
- Go to Tasks section under Import and Export Data
- Observation: Status is Completed with Errors
- Download and Open the file
- Error: Relationship with role Contact Person Relationship already exists between xxxxxx and yyyyyy
Cause
The link of the Contact to be created to the Account was maintained twice, i.e., in both - Contact (Root Entity) and Is contact person for Excel file. We have the redundancy explicitly in the entities to also allow the maintenance of the default account via the Contact (Root Entity) directly.
Resolution
Remove the Account Technical ID or Account ID field data from the Contact (Root Entity) file and maintain it only in the Is Contact Person for Excel file.
Keywords
error, relationship, exists, already, contact, account, data, upload, impex, unable , KBA , CEC-CRM-CON , Contact for SAP Sales/Service Cloud , CEC-CRM-IMX , Data Import/Export for SAP Sales/Service Cloud , CEC-CRM-ACC , Account for SAP Sales/Service Cloud , Problem