Attribute cannot be NULL

[XmenAS]

Hi all, 

I'm experiencing an issue where my Leads in Dynamics occasionally sync successfully, but at other times they do not. I can't determine where the problem occurs within Dynamics, and there are no error logs available to investigate further.

I’ve included a screenshot of the error message below. Can someone clarify its specific meaning and advise on how to resolve this issue in Dynamics?

Thanks in advance! 

[karstenkoehler]

Hi @XmenAS,

It looks like Microsoft Dynamics 365 is expecting a value in the company name field – but it's not receiving any value. Have you checked if the "Company name" field on the record you're trying to sync has a value and is not empty?

Best regards

[XmenAS]

Hi Karsten, 

Thank you for your fast response.

These leads have not yet been synchronized with Dynamics, so they are created in Dynamics using information from HubSpot. This means the initial value in Dynamics will always be null, correct? Please correct me if I'm mistaken. The error message is causing some confusion for me.

[karstenkoehler]

---

@XmenAS wrote:

These leads have not yet been synchronized with Dynamics, so they are created in Dynamics using information from HubSpot.

---

I'm not following here, unfortunately. Where is the origin of the records, where do you want to sync them?

---

@XmenAS wrote:

This means the initial value in Dynamics will always be null, correct?

---

Not necessarily, you can assign a value at the time of the record creation or shortly after, which should resolve the issue.

Have you tried filling the company name field? That would be the first step in troubleshooting as the error occurs due to the missing value.

[XmenAS]

Hi Karsten,

Apologies for the confusion. The process is that leads are imported from a website into HubSpot, and then from HubSpot into Dynamics. Leads displaying the error message "This record didn't sync because of a Microsoft Dynamics Error" have not yet been synced to Dynamics. Note that the company name field in the HubSpot record is filled in. As a result, I'm unsure where exactly the issue lies.

[karstenkoehler]

@XmenAS there is both a "Company name" field on the contact object and the company name of the associated company. Have you checked both?

[XmenAS]

Hi Karsten, 

Thank you for the tip. I reviewed the records, and the company properties are both filled in. I noticed that for records that failed to sync to Dynamics, the company name does not appear in the contact details section above. Please see the screenshot for reference.

For records that successfully synced, the company name appears between the full name and email address. Could this be the issue? How can I ensure the company name is displayed in this area?

Below is a screenshot example. Client data has been removed for privacy, but it shows how successful records are displayed.