1

enter image description here

Select Date, Email, Name from Kanchan_Staging 

i am getting an error :

Query failed during execution. Error: Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'Kanchan_Sendable'. The duplicate key value is (Jul 24 2017 12:00AM, c@sapient.com).

i have 2 primary keys in sendable data extension (Date and Email )and in other (Staging) data extension there is no primary key.enter image description here

  • i want to append contact with phone number in my sendable DE but no values is able to add in my Sendable DE it gives me error – Kanchan Singh Jul 24 '17 at 9:51
  • You might wanna not let everyone know you work at SapientRazorfish – Samuel Dare Jul 24 '17 at 10:52
  • Are you looking to have one row per email/date combination? What are you using as your SubscriberKey? What is the relationship between All Subscribers and this DE - email = SubscriberKey. Will all of the subscribers in this table have been sent to before and are already in All Subscribers? Are you using the table to send directly to, or is it an Event Entry DE for Journey Builder? – Macca Jul 25 '17 at 11:43
0

Using the date as primary key is not a good idea. In your case it is a combined key so that could make sense in some cases. However your data extension contains an entry twice. This is the row containing the key "Jul 24 2017 12:00AM, c@sapient.com".

I guess you selected the wrong target data extension if you want to write to the data extension without the primary key definition.

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.