Error Message: Decimal separator cannot be the empty string
Symptoms: When doing uploads with Data Workbench Version 9.5.43, Uploads Fail and the message returned contains "Decimal separator cannot be the empty string.;"
Cause: As a new feature of Data Workbench, we call an RFC provided by SAP to get the decimal format expected by SAP for each decimal field. SAP provides three different types of Decimal Notations but the RFC only actually handles two of them. When the decimal notation default contains a space in the thousandths place, the RFC provided does not handle it correctly. Data Workbench calls the RFC and the returned value is blank, which throws the above error message.
This problem will be fixed in all versions after Data Workbench Version 9.5.43 but a fix until then is stated below. This will change the default decimal notation to one that is handled correctly.
1. Login to the SAP system with the SAP GUI.
2. Select 'System' --> 'User Profile' --> 'Own Data'.
3. Select the 'Default' Tab.
4. Under 'Decimal Notation', select a decimal format that does not contain a space as the thousandths place separator. For Example, 1.234.567,89 or 1,234,567.89 not 1 234 567,89 which is highlighted below in Figure 1.
Figure 1 - the decimal notation highlighted is the option that is problematic.