I'm getting following error during update activity. Query failed during execution. Error: Violation of PRIMARY KEY constraint. Cannot insert duplicate key in object 'Enq_opp_Parallel_ContactView'. The duplicate key value is (0061M000010wwpLQAQ)

Getting this error even though source table contains unique values. Also this error only occurs during update activity. If I do override then it's works fine.

Here is the sql query i'm using -

DISTINCT(OS.Id) as RecordId, CS._ContactKey as ContactKey,  'Opportunity' as RecordType,
'Contact' as ParentRecordType, AcS.AESL_Email_status__c  as EmailStatus, 
OS.AESL_Lead_Score__c as LeadScore,
OS.StageName as StatusStage, OS.AESL_Subdisposition__c as SubDisposition,
OS.AESL_Transaction_Status__c as TransactionStatus, OS.LastModifiedDate as LastModifiedDate

from Opportunity_Salesforce as OS
inner join Account_Salesforce as Acs on OS.AccountId = AcS.Id
inner join Contact_Salesforce as CS on AcS.Id = CS.AccountId
/* finding previous days date using current server datetime */
where convert(date,OS.LastModifiedDate) = convert(date,dateadd(minute,-30,dateadd(hour,-12,Getdate())))

Please not that RecordId is primary key here.

  • Try removing the DISTINCT, this will make every item in the SELECT statement as a PKEY, which could potentially be what is causing the issue as it will be telling the system to add something that may be an update (due to only a single PKey on DE) - causing a Primary Key error. Mar 22, 2019 at 17:51
  • Tried without distinct as well, still getting same error.
    – ASHISH
    Mar 23, 2019 at 8:04

1 Answer 1


Found the root cause. This is happening because there are multiple rows exists in "Contact" object against single "Student" which usually is not the case in sales cloud. Because of this even if "Opportunity" object contains unique ids, post inner join I was getting multiple rows with same Opportunity Id (recordId).

I've found solution on the other thread on stackexchange only. Here is the link - Violation of PRIMARY KEY constraint. Cannot insert duplicate key

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .