2459684 - Error Message: "Invalid Boolean Type Entered" in Data Workbench

SAP Knowledge Base Article - Public

2459684 - Error Message: "Invalid Boolean Type Entered" in Data Workbench

Symptom

Using Data Workbench, you require to update the Sales Support Block for Individual Customers to True or False. Therefore, you Export the Individual Customers from the Export view and update the Sales Support Block Indicator to T or F. On uploading the file in the Update view, system throws the error:

Cannot import the data file. Please correct the following errors:

CSVHeader: SalesSupportBlockingIndicator

Error Information: Invalid boolean type entered

Correct format - Valid boolean values are true/false, TRUE/FALSE or X/""

Reproducing the Issue

  1. Login to the HTML5 client
  2. Go to Data Workbench workcenter
  3. Go to Export tab
  4. In the search field, select the object Individual Customers
  5. Select Data
  6. Select field ID Equals To XXXXX
  7. Select Next
  8. Export Data
  9. Go to the Monitor tab
  10. Download the exported file
  11. Update the field Sales Support Block with T or F

 

To Upload the file:

  1. Login to the HTML5 client
  2. Go to Data Workbench workcenter
  3. Go to the Update tab
  4. Select the object Individual Customers
  5. Select Next and Browse for the file
  6. Select Upload
  7. Choose Next

System throws error regarding Boolean type.

Cause

There could be multiple causes,

1. You entered the values T or F

or

2. You left the Boolean field empty

Resolution

Data Workbench accepts Boolean types as True/False or X/" ". If the field is mandatory then ensure that you provide the input

Keywords

KBA , SRD-CC , Cross Components , How To

Product

SAP HYBRIS C4C 1705 ; SAP Hybris Cloud for Customer 1702 ; SAP Hybris Cloud for Customer 1708