SAP Knowledge Base Article - Public

2518838 - Error Message: “Hierarchy with ID XXXXX already exists. Hierarchy node with ID XXXXX already exists“ While Migrating Customer Hierarchies

Symptom

Your requirement is to link new Accounts to the existing Account Hierarchies in your system. Upon trying to migrate using the Migration of Customer Hierarchies, system throws error:

Hierarchy with ID XXXXX already exists
or
Hierarchy node with ID XXXXX already exists

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 Customer Hierarchies
  4. Select Migrate customer hierarchies using the migration tool
  5. Upload the Migration File
  6. Execute Migration for the respective Migration File with Migration Mode Add new records

Cause

Migration of Account Hierarchy is only capable to create complete Account Hierarchies. Adding more Account Hierarchy Nodes or further Accounts using a delta-migration is not supported by the system.

Resolution

Once a Migration is done, adding of further Accounts or Nodes needs to be done manually by a user.
Further, neither a deletion nor a mass-deletion of Account Hierarchies is supported by the system.

Keywords

Migration of Account Hierarchy, Migration of Customer Hierarchies, Delete Account Hierarchy , KBA , migration of customer hierarchies , account hierarchies , delete account hierarchy , SRD-MD-PRD-PRD , Product , How To

Product

SAP Business ByDesign all versions