SAP Marketing Cloud – Permission Import failing due to duplicate Records

Symptom

A marketing permission import containing several permissions in the payload is failing with the following error:

“Multiple permissions with the same key at &1 found. Processing rejected.”

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental.

Environment

SAP Marketing Cloud Edition
SAP Marketing OnPremise starting with release 1709

Reproducing the Issue

1. Create a contact with with different source IDs but similar communication details like email, mobile or phone ID.
   
2. Import marketing permissions either via API API_MKT_CONTACT_SRV or via the Data File Load app. The API or CSV payload contains permissions records for the same contact.
3. Observe that the permissions import is failing with the following error in the import monitor.
    
4. On checking the payloads in detail, you observe that the permissions were imported for different IDs.
   

Cause

Marketing permission import requires two pairs of contact IDs – one pair of contact ID origin and ID for identifying the contact (CONTACT_ORIGIN and CONTACT_ID) and one pair of contact ID origin and ID for setting the marketing permission (PERMISSION_FACET_ID_ORIGIN and PERMISSION_FACET_ID).

The CONTACT_ORIGIN and CONTACT_ID pair is used for identifying the contact. After the contact is determined, the CONTACT_ORIGIN and CONTACT_ID information is discarded, as the permission processing happens on contact level but not on ID level – after the contact is determined, technically the processing happens via CONTACT_KEY and PERMISSION_FACET_ID_ORIGIN and PERMISSION_FACET_ID.

The CONTACT_ORIGIN and CONTACT_ID information is not persisted after the import.

Resolution

1. Avoid importing permission data with payloads for the same contact and permission IDs (so CONTACT_KEY and PERMISSION_FACET_ID_ORIGIN and PERMISSION_FACET_ID).
2. One suggestion to avoid that error is to separate the permission imports from different sources, so to implement the permissions from each source system individually.

See Also

Please also refer to the following KBAs for information about further permission import errors:

• 2941319 – SAP Marketing – Permission import failing due to wrong communication ID
• 2940770 – SAP Marketing – Permission import failing due to outdated timestamp

SAP Marketing Cloud – Import Monitor does no longer visualize Data for Imports

After the SAP Marketing Cloud tenant upgrade to Release 1911, the ‘Data’ bubble in the Import Monitor is no longer working – the payload for failed imports can no longer be displayed.

Reproducing the Issue

1. Open the Import Monitor and navigate to an import in status error.
2. Use the ‘Data’ bubble to visualize the payload for the failed import.
   
3. Observe that the payload is not displayed as expected. Instead the ‘Data’ bubble disappears.
   

Cause

SMC Release 1911 introduced new authorization control for displaying payloads of imported data. Authorizations are now controlled via business catalog ‘Marketing – Settings for Import Header Payload’ SAP_CEC_BC_MKT_IHP_PC.

Resolution

• Open the related business role of the affected user in the ‘Maintain Business User’ app
• Assign the business catalog ‘Marketing – Settings for Import Header Payload’ to the business role

• Enable display authorization in the business role restrictions settings as required either for ‘Error’ or ‘Success’ Imports or both

Export button and Import button are invisible in Contact(s) app for SAP Marketing Cloud release 1911

If you open the Contact(s) app and check the buttons in menu, you do not see the export and import button anymore since release 1911.

The reason for this is that new catalogs are shipped with 1911 to provide option to control Export button and Import button in Contact app.

Please add the delta catalogs for the affected users.

• SAP_CEC_BC_MKT_ICA_PC (Marketing – Import Contact and Accounts)
• SAP_CEC_BC_MKT_ECA_PC (Marketing – Export Contacts and Accounts)

Cheers!