SAP Knowledge Base Article - Public

3339288 - Error: Sales: Duplicate record detected with key value 'XYZ' while performing Migration of Materials for Sales Data

Symptom

You are trying to perform the Migration of Materials a sales data, system throws below error message.

"Sales: Duplicate record detected with key value 'XYZ'"

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Business Configuration work center
  2. Select Implementation Projects view or Overview
  3. Search and Open the activity Migration of Materials
  4. Choose Migrate materials using the migration tool
  5. Upload the file and go to properties change to enhance already existing records
  6. Execute migration step by step you get the below error message as shown below:

Error:  "Sales: Duplicate record detected with key value 'XYZ' "

Sales data migration.jpg

Cause

Migration file has the duplicate entries, which is causing this error message.

Resolution

Please check your Migration file for duplicates and remove the duplicate entries.

Once you remove the duplicates please start the migration, this should work without any issues.

Keywords

Migration of Materials, Sales Data Migration, Enhance already existing data, Sales, Duplicate Record detected. , KBA , migration of materials , enhance already existing data , sales , duplicate record detected , sales: duplicate record detected , migration of materials , SRD-CC-MIG-DMC , Migration: Tool , SRD-CC-MIG-CNT , Migration: Content , Problem

Product

SAP Business ByDesign all versions