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

Prashant 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=8.0.0.0, 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”>
<ActivityId>68953102-d03e-4a6e-9da4-98695fddff4e</ActivityId>
<ErrorCode>-2147204784</ErrorCode>
<ErrorDetails xmlns:d2p1=”http://schemas.datacontract.org/2004/07/System.Collections.Generic” />
<Message>Generic SQL error.</Message>
<Timestamp>2018-03-25T09:32:10.3819266Z</Timestamp>
<ExceptionRetriable>false</ExceptionRetriable>
<ExceptionSource i:nil=”true” />
<InnerFault i:nil=”true” />
<OriginalException i:nil=”true” />
<TraceText>

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

</TraceText>
</OrganizationServiceFault>

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 !

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 )

w

Connecting to %s