Microsoft Dynamics 365 | Integration, Dataverse...

Error "The field Primary Contact No. of table Customer contains a value ({00000000-0000-0000-)"

(2) Share

Report

Posted on by JE-04121251-0

I’m having issues with Dataverse synchronization when syncing Account/customer data between D365 Sales and BC. My synchronization is configured as "FromIntegrationTable" and I receive the following error: "The data could not be updated because of the following error: The field Primary Contact No. of table Customer contains a value ({00000000-0000-0000-) that cannot be found in the related table (Contact)."

In this case, the Dataverse column "PrimaryContactId" is empty, which is expected. Consequently, I anticipate that the Contact in BC should be removed. However, instead, I get the mentioned error.
Could anyone provide a solution to address this issue?

Categories:

Power Platform integration

All responses (3)

Answers (0)

Suggested answer

Amit Katariya007 8,699 Super User 2024 Season 1 on at

Like (1)

Report

Error "The field Primary Contact No. of table Customer contains a value ({00000000-0000-0000-)"

You can check the payload in respective request. May be it is adding this value if given lookup is null.
JE-04121251-0 8 on at

Like (1)

Report

Error "The field Primary Contact No. of table Customer contains a value ({00000000-0000-0000-)"

Thank you @Amit Katariya007 for your response.

Although "PrimaryContactId" is NULL in my Dataverse table, I have attempted to update the column by deleting any data present, but still encounter the same error during the integration process. Any assistance in resolving this issue would be greatly appreciated.
Amit Katariya007 8,699 Super User 2024 Season 1 on at

Like (1)

Report

Error "The field Primary Contact No. of table Customer contains a value ({00000000-0000-0000-)"

It should be null not guid with zeros.

Because system will still consider it as guid and try to find an contact with respective guid.