Symptom
Your requirement is to upload Suppliers with their Contact information using Migration of Suppliers. During the simulation, you receive the below error:
Field PERSON-NAME-FAMILY_NAME contains at least one invalid character
Environment
SAP Business ByDesign
Reproducing the Issue
- Go to Business Configuration work center
- Select Implementation Projects view or Overview
- Search and Open the activity Migration of Suppliers
- Select Migrate suppliers using the migration tool
- Upload the Migration File
- Execute Migration for the respective Migration File with Migration Mode Add new records
- You receive the mentioned error
Cause
In the Contacts sheet of the migration file, in the field Last Name, you have entered one or more invalid characters.
Resolution
Special characters like zero-width space characters are not allowed for Business ByDesign Name fields. The invalid characters cannot be processed when creating Suppliers manually or using migration. Enter valid characters in the Contacts sheet and proceed with the migration activity.
Note:
The following characters and entries are not allowed for First Name or Last Name of the Contacts.
Carriage return
Line feed
Tab characters
Leading or trailing spaces
Internal sequences of two or more spaces
Keywords
Zero-width space characters, invalid characters, Last Name, First Name, Name, space, tab character, Supplier, Contact , KBA , tab character , name , space , supplier , zero-width space characters , invalid characters , contact , first name , last name , SRD-MD-BP-SUP , Suppliers , Problem