Symptom
You have a requirement to update/enhance the few parameters/attibutes in your Supplier Master Data. When you try to perform this activity through Migration, system throws below error message:
Insertion of data failed; data with key XYZ already exists for node ROOT
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Configuration work center
- Select Implementation Projects view or Overview.
- Search and Open the migration activity for Suppliers.
- Execute Migration for the respective Migration File
Note: Migration Mode for the respective file is Enhance already existing records
Cause
The cause for the issue is that you are trying to modify the already existing data of the Supplier XYZ.
The general functionality of the migration mode Enhance already existing records is to enhance the Supplier. In this case, the enhance mode will work only if there is no Data maintained for the Suppliers in the particular tab (EX: Purchasing). Which means, you have not maintained any information related to Purchasing in the Supplier and you can use this mode to add those information. But, if you have already maintained a purchasing information and trying to modify that, then it is not possible through this mode or through migration.
Resolution
This is expected system behavior.
You can use this mode to enhance the Purchasing Data of Suppliers only if there is no Purchasing information maintained in the system.
See Also
KBA: 2511426 - Error Message: “Insertion of data failed; data with key XXXXX already exists for node ROOT” While Migrating Suppliers
Blog: Mass Changes of ByD Data using Excel and ByD Web Services
Keywords
KBA , SRD-MD-OM , Organizational Management , How To