SAP Knowledge Base Article - Public

2459169 - Error Message: “No Spaces Allowed (Only Alphabets, Numbers & Underscore Allowed)”, While Uploading File in Data Workbench

Symptom

Your requirement is to Delete some records for any Object using Data Workbench. You have added the column To Be Deleted to indicate which row should be deleted and marked it as True. While uploading the CSV file in the Update tab, system throws error:

No spaces allowed (only alphabets, numbers & underscore allowed)

Environment

SAP Hybris Cloud for Customer 1802 and higher.

Reproducing the Issue

To delete records of any Object in Data Workbench, follow the below steps:

  1. Logon to the HTML5 client;
  2. Go to Data Workbench work center;
  3. Go to Export tab;
  4. In the search field, select the Object;
  5. Select Data;
  6. Select Next;
  7. Export Data;
  8. Go to the Monitor tab;
  9. Download the exported file.

Add column To Be Deleted to indicate which row should be deleted and mark it as True and then follow the below steps:

  1. Logon to the HTML5 client;
  2. Go to Data Workbench work center;
  3. Go to the Update tab;
  4. Select the Object;
  5. Select Next and Browse for the file;
  6. Select Upload;
  7. System throws error.

Cause

You have added the column header To Be Deleted with spaces.

Resolution

The column header should not contain spaces. Add the column header ToBeDeleted without spaces.

This is valid for all headers in Data Workbench.

Keywords

tobedeleted, data workbench, delete records, error message, no spaces allowed , KBA , to be deleted , tobedeleted , LOD-CRM-INT-DWB , Data Workbench , How To

Product

SAP Cloud for Customer add-ins all versions