1

Context:

Someone in charge of customer journeys discovered duplicates in a resulting dataset based on one of our data extensions; we are now tasked with routing out the source of said duplicates.

The odd thing about it is that these duplicates exist despite a three part primary key across the entries. Below is included examples of the data extension in question and the violating entries within them.

Below is the data sets of the duplicates enter image description here The selected entries are those in violation.

And below is a screen cap of the primary keys, First is the actual set, the second is a manual created one. Keys

This did leave us quite perplexed as our earlier experiments showed us that we were not able to violate the primary keys in this way.

Therefore we took a ‘copy’ of the dataextention in question, and tried to populate it with duplicate data, we were allowed to do that until we reached about 3 entries then we would have to delete some to insert more duplicates. However this behavior ceased to happen around 09:00 am (EST) yesterday.

Now whenever I try to upsert the involved data entries I am met with either a response 200 from the REST api, I assume it updates, or a generic error message in the sales force marketing cloud UI.

The duplicate entries still exist though, I am just unable to replicate the behavior that created them at the moment.

Questions are as follows.

  1. Do Primary keys work as one would assume? (unique not null, more than one makes it composite
  2. How did I insert the duplicate values?
  3. Have anyone else experience something similar?

I hope that someone within the community is able to shed some light on these events.

Minor note: i was not able to replicate the duplicating experience if i manually created a new data extension with an identical setup only, if i did a 'copy',does this mean that it is possible to 'corrupt' a data extension?

1
  • Did you try to also post this question on the developer forums? This is quite complex so I would post it in there aswell Jun 21 '16 at 10:47
0

We are implementing a similar scenario to avoid API Duplicate events so did some testing (only with two primary keys)

1) They seem to work, API events which try to violate Primary keys are just igored, but still return a successful HTTP Code 201

2) That would generally be the million dollar question right? I would suggest Salesforce Support Ticket

3) So, no cannot say we have seen this anywhere

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.