The data could not be updated

(8) Share

Report

Posted on by Mahek Mehta

288

Hi, I am facing this error when synchronizing can anyone help to resolve the conflict , if requesting support, please provide the following details to help troubleshooting:

Error message:
The data could not be updated because of the following error: Table CRM Contact must be mapped to table Customer to transfer value between fields rw_ContactId and ClientID.

Internal session ID:
2a7b8060-6a63-4d30-a808-07179a9f6577

Application Insights session ID:
5e6f9ce4-af16-4acf-8543-2ce118aff7c5

Client activity id:
966d01ed-d5be-4725-bee8-d2c6e03bcc00

Time stamp on error:
2025-11-06T06:11:34.3850722Z

User telemetry id:
21af773b-ab72-429f-9802-d3b34208efe8

AL call stack:
"Integration Synch. Error List"(Page 5339)."Message - OnDrillDown"(Trigger) line 14 - Base Application by Microsoft version 26.5.38752.41466

Custom dimensions:
[{"Item1":"Call Stack","Item2":"\"CRM Synch. Helper\"(CodeUnit 5342).AreFieldsRelatedToMappedTables line 26 - Base Application by Microsoft version 26.5.38752.41466\\\"CRM Int. Table. Subscriber\"(CodeUnit 5341).OnTransferFieldData line 151 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Record Synch.\"(CodeUnit 5336).OnTransferFieldData(Event) line 2 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Record Synch.\"(CodeUnit 5336).TransferFieldData line 9 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Record Synch.\"(CodeUnit 5336).TransferField line 25 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Record Synch.\"(CodeUnit 5336).TransferFields line 8 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Record Synch.\"(CodeUnit 5336).OnRun(Trigger) line 2 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Rec. Synch. Invoke\"(CodeUnit 5345).TransferFields line 8 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Rec. Synch. Invoke\"(CodeUnit 5345).SynchRecord line 53 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Rec. Synch. Invoke\"(CodeUnit 5345).OnRun(Trigger) line 3 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Table Synch.\"(CodeUnit 5335).Synchronize line 49 - Base Application by Microsoft version 26.5.38752.41466\\\"CRM Integration Table Synch.\"(CodeUnit 5340).SynchCRMTableToNAV line 27 - Base Application by Microsoft version 26.5.38752.41466\\\"CRM Integration Table Synch.\"(CodeUnit 5340).PerformScheduledSynchFromIntegrationTable line 14 - Base Application by Microsoft version 26.5.38752.41466\\\"CRM Integration Table Synch.\"(CodeUnit 5340).OnRun(Trigger) line 24 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Synch. Job Runner\"(CodeUnit 5339).RunIntegrationTableSynch line 3 - Base Application by Microsoft version 26.5.38752.41466\\\"Integration Synch. Job Runner\"(CodeUnit 5339).OnRun(Trigger) line 5 - Base Application by Microsoft version 26.5.38752.41466\\\"Job Queue Start Codeunit\"(CodeUnit 449).OnRun(Trigger) line 18 - Base Application by Microsoft version 26.5.38752.41466\\\"Job Queue Dispatcher\"(CodeUnit 448).HandleRequest line 24 - Base Application by Microsoft version 26.5.38752.41466\\\"Job Queue Dispatcher\"(CodeUnit 448).OnRun(Trigger) line 30 - Base Application by Microsoft version 26.5.38752.41466\\"}]

Categories:

Dynamics 365 Business Central

Microsoft Dynamics RMS

Microsoft Dynamics NAV

Dynamics 365 Business Central migration

I have the same question (0)

All responses (8)

Answers (1)

Gerardo Rentería Ga... 25,555 Most Valuable Professional on at

Like (3)

Report
Copy link

Link copied!

Hi

How are you synchronizing? Is this field customized rw_ContactId?

Best

GR

Was this reply helpful? Yes No
Suggested answer

Pallavi Phade 5,420 Super User 2026 Season 1 on at

Like (4)

Report
Copy link

Link copied!

Namaste @Mahek Mehta

Can you check field mapping for Table CRM_Contact Integration setup

Check feild mapping and direction . Or have your written any AL script to update any custom field

Regards

Pallavi Phade

Was this reply helpful? Yes No
Suggested answer

Jainam M. Kothari 15,732 Super User 2026 Season 1 on at

Like (3)

Report
Copy link

Link copied!

May this can help : https://learn.microsoft.com/en-us/dynamics365/business-central/admin-how-to-modify-table-mappings-for-synchronization

1 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

RockwithNav 8,941 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Seems like you are using Sales Integration, first question from my side would be that, Is this the only pain and others getting syncing in successfully?

Did you modify anything?

Was this reply helpful? Yes No
Suggested answer

YUN ZHU 99,055 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi, hope the following can give you some hints.

https://learn.microsoft.com/en-us/dynamics365/business-central/marketing-integrate-dynamicscrm?tabs=new-experience#couple-records

Thanks.

ZHU

Was this reply helpful? Yes No
Suggested answer

OussamaSabbouh 12,766 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hello,

Your sync error means the CRM Contact ↔ Customer tables aren’t mapped, so BC can’t transfer lookup fields (rw_ContactId ↔ ClientID).

Fix:

Go to Integration Table Mappings.

Add or enable mapping Customer ⇄ Contact (Dataverse Contact).

Ensure related field mappings exist for both lookup fields.

Re-couple records (Customer → Set Up Coupling → Synchronize).

After saving, rerun the job queue — the sync will complete normally.

Regards,
Oussama Sabbouh

2 people found this reply helpful.

Was this reply helpful? Yes No
Suggested answer

Khushbu Rajvi. 22,106 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Not sure but please check this if it provide some hint: https://learn.microsoft.com/en-us/dynamics365/business-central/admin-how-to-modify-table-mappings-for-synchronization

https://www.youtube.com/watch?v=LhmYwr1GAWo

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

Mahek Mehta 288 on at

Like (1)

Report
Copy link

Link copied!
Hi all,

I was able to resolve this issue. The problem occurred because in CRM the Contact table can be related to both Contact and Customer, which caused a conflict during synchronization in Microsoft Dynamics 365 Business Central when transferring values between rw_ContactId and ClientID.

To fix the issue, we did the following:

Created a new table field mapping for Customer and Contact to avoid ambiguity during synchronization.

Added a new GUID field in Business Central to store the Account/Contact GUID coming from CRM.

Mapped this GUID field in the Integration Table Mapping.

Added a proper table relation and mapping and coupling with Customer so the system can identify the correct record.

Synced all existing Contacts to Customers after updating the mapping.

After updating the mapping and relations, synchronization is now working correctly without conflicts.

Hope this helps someone facing the same issue.

Was this reply helpful? Yes No