CRM

XmenAS
Member

Attribute cannot be NULL

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?

 

Schermafbeelding 2024-11-07 085323.png

 

Thanks in advance! 

0 Upvotes
6 Replies 6
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Attribute cannot be NULL

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

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
XmenAS
Member

Attribute cannot be NULL

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.

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Attribute cannot be NULL


@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.

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
XmenAS
Member

Attribute cannot be NULL

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.

0 Upvotes
karstenkoehler
Hall of Famer | Partner
Hall of Famer | Partner

Attribute cannot be NULL

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

Karsten Köhler
HubSpot Freelancer | RevOps & CRM Consultant | Community Hall of Famer

Beratungstermin mit Karsten vereinbaren

 

Did my post help answer your query? Help the community by marking it as a solution.

0 Upvotes
XmenAS
Member

Attribute cannot be NULL

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.

 

Schermafbeelding 2024-11-07 112705.jpg

 

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.

 

 

Schermafbeelding 2024-11-07 112249.jpg

 

 

0 Upvotes