Dynamics 365 CRM Duplicate detection error : Generic SQL error.[Microsoft.Crm.DuplicateDetection: Microsoft.Crm.HasDuplicatesPlugin]

Prashant Kumar Maurya

Today we were facing a weird issue with one of CRM user. User was getting below error on create/update of Lead record.

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=, Culture=neutral, PublicKeyToken=31bf3856ad364e35]]: Generic SQL error.Detail:
<OrganizationServiceFault xmlns:i=”http://www.w3.org/2001/XMLSchema-instance” xmlns=”http://schemas.microsoft.com/xrm/2011/Contracts”>
<ErrorDetails xmlns:d2p1=”http://schemas.datacontract.org/2004/07/System.Collections.Generic” />
<Message>Generic SQL error.</Message>
<ExceptionSource i:nil=”true” />
<InnerFault i:nil=”true” />
<OriginalException i:nil=”true” />

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


1 – We unpublished all duplicate detection rules on lead entity but no luck.

2 – Then we unpublished duplicate detection rule for all entity in the organization still same issue,

3 – Then we tried various combination of publish and un-publish but issue was not resolve.

Seems like CRM was stuck in a state for this user where it was not able to recover from :(.

next thing we tried is to disable duplicate detection rule from duplicate detection settings and it worked :).

To disable…

View original post 32 more words

Author: Nishant Rana

I love working in and sharing everything about Microsoft.NET technology !

Please share your thoughts

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.