2919487 - Product Material is not Migrated but System Indicates that the Material Exists

During the migration of materials, the system shows the following error:

'Error detected in source record with key value XYZ' 'Similar entry already exists' (where XYZ represents the Material ID)

SAP Business ByDesign

1. Go to the Business Configuration work center
2. Select Implementation Projects view
3. Click on Open Activity List
4. Find Migration of Materials
5. Select Migrate materials using the migration tool
6. Migrate the relevant migration file
7. An error appears: 'Error detected in source record with key value XYZ' 'Similar entry already exists'
8. Now go to the Product Data work center
9. Navigate to the Materials subview
10. There is no material existing with a similar description or ID number

Check the Logistics tab on the sheet. The error occurs due to a duplication of Site IDs. In the Convert Values step -> Edit Value Conversion for Site ID, the converting Site IDs are incorrectly used in the Logistics tab, for example several IDs are converted to the same ID.

Example:

The Site IDs AAA and BBB both are getting converted to BBB (where AAA and BBB represent the Site IDs)

Correct the conversion and simulate migration again. The errors shouldn't appear anymore.

Material existed, Migrate materials, Error detected in source record with key value, Similar entry already exists, SAP Business Bydesign , KBA , AP-PRD-MIG , Product Data Migration and Replication , Problem