Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics CRM (Archived) / HasDuplicatesPlugin Er...
Microsoft Dynamics CRM (Archived)

HasDuplicatesPlugin Error in Dynamic 365

(0) ShareShare
ReportReport
Posted on by nilesh karale 130

Hello, 

Below error is getting for some users on Dynamic 365 Online CRM while saving/updating records (Lead, Account and Contact) in CRM. 

I tried to resolve this by disabling duplicate detection rules, etc


Please help.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=8.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail:
<OrganizationServiceFault xmlns:i="www.w3.org/.../XMLSchema-instance" xmlns="schemas.microsoft.com/.../Contracts">
<ActivityId>8a871c67-8961-4ba6-9819-d6b0cc734166</ActivityId>
<ErrorCode>-2147204784</ErrorCode>
<ErrorDetails xmlns:d2p1="schemas.datacontract.org/.../System.Collections.Generic" />
<Message>Generic SQL error.</Message>
<Timestamp>2017-04-26T11:07:21.1337178Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil="true" />
<InnerFault i:nil="true" />
<OriginalException i:nil="true" />
<TraceText>

[Microsoft.Crm.DuplicateDetection: Microsoft.Crm.HasDuplicatesPlugin]
[65cabb1b-ea3e-db11-86a7-000a3a5473e8: HasDuplicatesPlugin]


</TraceText>
</OrganizationServiceFault>

*This post is locked for comments

  • Verified answer
    Nishant Rana Profile Picture
    Nishant Rana 11,320 Microsoft Employee on at
    RE: HasDuplicatesPlugin Error in Dynamic 365

    Try this

    prashantmayur.wordpress.com/.../dynamics-365-crm-duplicate-detection-error-generic-sql-error-microsoft-crm-duplicatedetection-microsoft-crm-hasduplicatesplugin

  • awad Profile Picture
    awad on at
    RE: HasDuplicatesPlugin Error in Dynamic 365

    Published all worked for me .

  • Suggested answer
    razdynamics Profile Picture
    razdynamics 17,304 User Group Leader on at
    RE: HasDuplicatesPlugin Error in Dynamic 365

    Hi Nilesh, Sometimes it may take some time for the duplicate rules to propagate, also try and perform a publish of all customisations to force the update

  • nilesh karale Profile Picture
    nilesh karale 130 on at
    RE: HasDuplicatesPlugin Error in Dynamic 365

    Thanks Gopalan for your reply.

    I've just set duplicate detection rule for email -  exact match. Now I have disabled all the duplicate detection rules on these entities. Still getting same error.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: HasDuplicatesPlugin Error in Dynamic 365

    Hi,
    This issue seems due to Duplicate detection rule on that entity.
    You can disable duplicate detection rules on entity where you are facing this issue and try again.

  • Gopalan Bhuvanesh Profile Picture
    Gopalan Bhuvanesh 11,401 on at
    RE: HasDuplicatesPlugin Error in Dynamic 365

    Hi

    Find out what are the values you are setting when creating and updating the records.

    Please refer the following:

    stackoverflow.com/.../microsoft-crm-duplicatedetection-microsoft-crm-hasduplicatesplugin

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Vahid Ghafarpour – Community Spotlight

We are excited to recognize Vahid Ghafarpour as our February 2025 Community…

Tip: Become a User Group leader!

Join the ranks of valued community UG leaders

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,307 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans