SAP Knowledge Base Article - Public

3552862 - Error: Relationship with role Contact Person Relationship already exists between xxxxxx and yyyyyy

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

  1. Click on User Menu
  2. Go to Settings
  3. Go to All Settings facet
  4. Go to Data Import and Export
  5. Go to Import and Export Data
  6. Click on Import and click Create
  7. Select Entity as Contact
  8. Select Individual Sub-Entities
  9. Check Is contact person for
  10. Select the File Type Click on Browse Files
  11. Select the file and click on Import Data
  12. Go to Tasks section under Import and Export Data
  13. Observation: Status is Completed with Errors
  14. Download and Open the file
  15. 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

Product

SAP Sales Cloud and SAP Service Cloud Version 2 1.0