Strange error on lookup CRM 365

As described in the title, today I had to fix a pretty strange error that was appearing on two Lookups whenever I tried to change their values in the form. Basically, after clicking on any of these two fields, CRM was throwing the next error:

Unhandled Exception: System.ServiceModel.FaultException`1[[Microsoft.Xrm.Sdk.OrganizationServiceFault, Microsoft.Xrm.Sdk, Version=6.0.0.0, Culture=neutral,
PublicKeyToken=31bf3856ad364e35]]: System.Xml.XmlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #D7E22C20Detail:
<OrganizationServiceFault xmlns:i=””>
<ErrorCode>-2147220970</ErrorCode>
<ErrorDetails xmlns:d2p1=”” />
<Message>System.Xml.XmlException: Microsoft Dynamics CRM has experienced an error. Reference number for administrators or support: #D7E22C20</Message>
<Timestamp>2018-01-24T15:46:19.4975466Z</Timestamp>
<InnerFault i:nil=”true” />
<TraceText i:nil=”true” />
</OrganizationServiceFault>

One of the biggest problems I faced while trying to fix this issue was that the error above was not specifying anything. At the beginning, I thought that this error was related to a Script, Plugin, Workflow or Business rule. However, after disabling every single customization attached to this entity, I noticed that it was still appearing. I did research over different blogs and this error was very hard to fix, some said that it was related to the browser and others that they had to delete and re add the field to fix it, this of course was not a solution for me so I had to try other workarounds that didn’t either.

Solution

After digging on how this Lookup field was populated, I came across that all records in this entity were created by an external integration and many of them had issues due to this. So, the problem was related directly to the data itself and not to any customization. To fix the issue, we had to remove some special characters that the records had, once we did this, the error didn’t appear anymore.

Hope it helps.

 

Leave a Reply

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