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.
    contact origins.jpg
  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.
    error msg.jpg 
  4. On checking the payloads in detail, you observe that the permissions were imported for different IDs.
    import payload.jpg

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).

import design.jpg

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:

SAP Marketing Cloud – Error accessing Campaign App on a Mobile Device (tablet or smartphone)

You click the the Marketing tile / app via a mobile device and you receive the error: “app could not be opened either due to an incorrect SAP FIORI launchpad configuration or a missing role assignment”.Failed to resolve navigation target “#Initial-manageCampaignFlow”. This is most likely caused by an incorrect SAP Fiori launchpad content configuration or by a missing role assignment.CPG App 2.PNG

The reason this error message appears is that the Campaign App on the SAP Marketing Cloud is not supported on Mobile Devices. This App should only be used on desktop or laptop devices.

SAP Marketing Cloud: Embedding YouTube Videos in the Content Studio does not work

As a marketer you want to embed or insert the YouTube Videos when creating your email content in the Content Studio in SAP Marketing Cloud. However, when you try to emded the iFrame with the YouTube video in the email editor, it is blocked by SAP

Reason for this is that most email clients will block these iframes too, so SAP decided to block this on the email editor a.k.a. Content Studio as well.

Email Client Iframe displays?
AOL Webmail No
Gmail No
Windows Live Hotmail No
MobileMe No
Yahoo! Mail No
AOL 9 No
Apple Mail 3 / 4 Yes
Entourage 2008 No
Lotus Notes 6 / 7 No
Lotus Notes 8 Yes
Outlook 2000 Yes
Outlook Express 6 Yes
Outlook XP / 2003 / 2007 / 2010 No
Thunderbird Yes
Windows Mail Yes
Blackberry No
iPhone / iPad Yes
Symbian S60 Yes
Windows Mobile 5 No
Windows Mobile 6 Yes
Android (default client) Yes
Android (Gmail client) No

Resolution

Use an image of the YouTube video you want to add to your email and link to the video on YouTube instead.

SAP CRM – System Status ‘Contains Errors’ / ‘Not correct’ (I1030) in transaction

When for example business partners are blocked and used in transaction which are replicated to ECC, it is possible that these transactions contain the system status I1030  – Contain Errors. When you check the statuses active for an specific document (at header or item level) the system status ‘Contain Errors’ (I1030) is active even though the document doesn’t have any error message on the header or item level.
This is possible because the system status I1030 Contain Errors typically flags at transaction creation.

Environment
SAP Customer Relationship Management
SAP CRM Web Client User Interface (Web UI)
SAP Graphical User Interface (SAP GUI)

Reproducing the Issue

1. Logon to CRM Web UI using any business role.
2. Search for a business transaction using ‘Status = Contain Errors’ I1030 as criteria.
3. Document <nr> is returned from the search even though there is no message about the error.
4. Go to SAP GUI to double-check the statuses for this document (including its items):
a. Go to Tx SE16 and check table crmd_orderadm_h.
b. Using the document ID you will determine the GUID of this document.
c. Using the GUID check table CRM_JEST.
d. System status I1030 is active.
Resolution

Option #1 : Run the report CRM_MESSAGES_CHECK for the relevant transactions in order to delete the system status I1030
CRM_MESSAGES_CHECK

 

 

Programma CRM_MESSAGES_CHECK_2015-08-19_11-06-51

 

 

Option #2 : Make a change in the document to update table CRM_JEST:
1. Do any change which raises an error in document message log.
2. Undo this change so that the error is deleted.
3. The error status I1030 will also be deleted afterwards.

CRM_MESSAGE_COLLECT, CRM_MESSAGES_CHECK, CRM_MESSAGES_DELETE_LOG, CRM_MESSAGES_CHECK, I1030, I1005, DELETE, ERROR, MESSAGES

——————————————

Remco Jansen is working as a SAP CRM professional for various clients in the Netherlands.