SAP Knowledge Base Article - Public

3651338 - Error "Data validation failed, Create an Incident" while importing customer payment data

Symptom

  • Data validation failed during the import of customer payment data through Mass Data Maintenance
  • Error message displayed: "Data Validation failed, Create an Incident".

Environment

SAP Business ByDesign

Reproducing the Issue

  1. Go to Mass Data Maintenance work center
  2. Select the "Export Customers" link > Redirected to the Export Of Customers page
  3. Choose Go in additional fields below
  4. Select the required tab below where data is to migrated
  5. Choose Export data to CSV file
  6. Maintain the required data in the exported file.
  7. Return to the Mass Data Maintenance work center and select the "Import Customers" link
  8. Select Upload Data from Text File > select the updated CSV file
  9. Attempt to import the file and observe the error message: "Data Validation failed, Create an Incident".

Cause

  • Duplicate entries in the imported CSV file can lead to data validation errors.
  • Missing data entry for all the required rows

Resolution

  1. Open the CSV file where data was maintained and was used for the import of Customer Data
  2. Identify and remove any duplicate entries in the file.
  3. Ensure that data is maintained in all the required rows
  4. Save the corrected CSV file.
  5. Retry the import process using the corrected file.

See Also

KBA 2633570 - Error "File validation failed. Create an incident" While Enhancing Customers Data via Migration Activity

Keywords

data validation failed, import customers, duplicate entries, credit limit missing, CSV file error, migration content, customer payment data, file validation failed, create an incident, data maintenance, mass data maintenance , KBA , SRD-CC-MIG-CNT , Migration: Content , Problem

Product

SAP Business ByDesign all versions