SAP Knowledge Base Article - Public

2646487 - Error: "Update of Sales Data Key Not Allowed With Active ERP Data Exchange" While Updating Account Sales Data in Data Workbench

Symptom

You are trying to update account sales data using the Data Workbench tool, but you are receiving the following error message in the error log:

"Update of Sales Data key not allowed with active ERP data exchange"

Environment

SAP Hybris Cloud for Customer - all its versions.

Reproducing the Issue

  1. Go to the Data Workbench work center, in Import view.
  2. Click on the radio button 'Individual Objects'.
  3. Click on the 'Update' button.
  4. Select the object 'Account Sales Data'.
  5. Click on Next.
  6. Upload your CSV file, click on 'Next'.
  7. Finish the Import.
  8. Go to the Monitor view.
  9. Download the error file and see the error message.

Cause

The error message is caused because there is an integration active between Hybris Cloud for Customer and an external system, which involves the replication of customer accounts. This will prevent any mass changes to be performed in the sales data of accounts, by using any of the tools available in the system (mass data maintenance, data workbench or migration tool in modify or enhance modes).

Resolution

There is a workaround that will allow you to massively update data while still having the master data of accounts integration active in the system.

Please note: This workaround should be done with caution, because it may affect the master data maintained in Hybris Cloud for Customer and the data maintained in the external system.

To achieve that it requires that you temporarily remove the External ID mapping of the Accounts you want to update massively:

  1. In the Administrator work center under Common Tasks, choose Edit ID Mapping for Integration.
  2. Take note of the external IDs and the accounts they belong to.
  3. Remove the external IDs of the accounts you would like to update.
  4. Perform the mass update.
  5. Go back to the Administrator work center under Common Tasks, choose Edit ID Mapping for Integration.
  6. Add the external ID mappings back to the system.

Keywords

external ID mapping, data workbench error, sales data update, account sales data , KBA , LOD-CRM-INT-DWB , Data Workbench , LOD-CRM-ACC , Account , Problem

Product

SAP Cloud for Customer all versions