2550522 - Error While Importing E-Mails Using Data Workbench

SAP Knowledge Base Article - Public

2550522 - Error While Importing E-Mails Using Data Workbench

Symptom

Your requirement is to import EMail with status Completed using Data Workbench. But you are not able to proceed due to processing error:

Action NOTIFY_OF_RECPT not possible; action is disabled

CorrespondenceTransmissionStatusCode does not fit to InitiatorCode

Reproducing the Issue

  1. Go to Data Workbench work center
  2. Select Import
  3. Select the Object EMail
  4. Select Next
  5. Upload the template
  6. Select Import
  7. In the Monitor tab, check for the respective Task ID to understand the status of the Import
  8. The Task is Finished with Errors 

Cause

Leading zeros of Code values like DocumentType and Category are truncated while updating the CSV file.

When you want to upload the EMail with status Completed, you cannot directly set the Status to Completed. Instead, both TransmissionStatusCode and InitiatorCode need to be set correctly.

Once the EMail is uploaded, backend logic will set it to status Completed.

Resolution

Once you Export the CSV file, open the same file with Notepad++ , Fill the CSV file with the leading zeroes for Code values for DocumentType and Category fields.

As you want to upload EMail with status Completed, you may leave the Status and StatusText fields empty and fill the other fields.

After editing the file, follow the below steps:

  1. Go to Menu and select the option Encoding
  2. Select the option Convert to UTF-8
  3. Save the file on Menu->File->Save as
  4. Name the file and add the extension .CSV
  5. Example: filename.csv
  6. Upload this file in Data Workbench

Note: You may use software which is approved by your organization/IT.

Further, refer DWB documentation, on guidelines to update CSV files.

https://help.sap.com/doc/2360ff1a103d4b8e8c16c21178f051ba/1708/en-US/Data_Workbench.pdf

Keywords

KBA , SRD-CC-FED , Feeds , How To

Product

SAP Hybris Cloud for Customer 1708 ; SAP Hybris Cloud for Customer 1711