Small and medium business | Business Central, N...

Custom Dataverse integration, error on Default Connection Setup

(8) Share

Report

Posted on by HT1980

Hi all,

I'm customizing the standard Dataverse integration. When resetting integration Table Mapping by selecting Use Default Connection Setup on the Dataverse Connection Setup age, I get the following error. See below for the full message:

"The Field does not exist. Identification fields and values: TableNo='50111',No.='0'"

The table 50111 is a custom virtual table. When i remove this table from the customizations, the error is still thrown. Resetting the connection also does not work.

Hope someone can help me!:)

If requesting support, please provide the following details to help troubleshooting:

Error message:
The Field does not exist. Identification fields and values: TableNo='50111',No.='0'

Internal session ID:
fa36b73a-7fea-4fa4-8b25-00b76fa0bb4f

Application Insights session ID:
c6308431-4290-4c0a-ae6d-0c285a7ff796

Client activity id:
cc8e1f75-3547-464c-871c-ce863eb44a17

Time stamp on error:
2025-07-31T14:00:23.8821150Z

User telemetry id:
de786224-5e9a-412c-92e8-2391981557e2

AL call stack:
"Integration Table Mapping"(Table 5335)."Integration Table UID Fld. No. - OnValidate"(Trigger) line 5 - Base Application by Microsoft
"Integration Table Mapping"(Table 5335).CreateRecord line 10 - Base Application by Microsoft
"Integration Table Mapping"(Table 5335).CreateRecord line 11 - Base Application by Microsoft
"Man. Integration Table Mapping"(Table 5380).InsertIntegrationTableMapping line 2 - Base Application by Microsoft
"Manual Int Mapping Events"(CodeUnit 5369).HandleOnAfterResetConfiguration line 10 - Base Application by Microsoft
"CDS Setup Defaults"(CodeUnit 7204).OnAfterResetConfiguration(Event) line 2 - Base Application by Microsoft
"CDS Setup Defaults"(CodeUnit 7204).SetCustomIntegrationsTableMappings line 2 - Base Application by Microsoft
"CDS Setup Defaults"(CodeUnit 7204).ResetConfiguration line 26 - Base Application by Microsoft
"CDS Connection Setup"(Page 7200)."ResetConfiguration - OnAction"(Trigger) line 5 - Base Application by Microsoft

Categories:

Dynamics 365 Business Central

All responses (7)

Answers (0)

Suggested answer

Mohana Yadav 60,341 Super User 2025 Season 2 on at

Like (0)

Report

Custom Dataverse integration, error on Default Connection Setup

Could you please open the 5335 table records from table information and filter Integration table id field with 50111?
HT1980 48 on at

Like (0)

Report

Custom Dataverse integration, error on Default Connection Setup

Hi All,

Thanks for your answers!

I looked at all your suggestions but I'm still stuck.. I removed the Integration Table Mappings that were referencing the custom table, but still got the same error.

After that I removed all custom Integration Table mapping and unpublished my extension in Extension Management, but still got the error!

I'm really at a loss now, hope any of you has any ideas?
Suggested answer

Jeffrey Bulanadi 4,684 on at

Like (1)

Report
Custom Dataverse integration, error on Default Connection Setup

Hi,

The error you're seeing typically occurs when the system tries to validate a mapping against a custom table that no longer exists or is improperly registered. Even if you’ve removed the table from your customizations, the integration metadata may still reference it internally.

The error message:

"The Field does not exist. Identification fields and values: TableNo='50111',No.='0'"

suggests that the system is trying to resolve a field from your custom virtual table (50111) during the reset process, but it can’t find a valid record. This often happens when the integration table mapping still contains a reference to that table, even if the table object has been deleted or unpublished.

To resolve this:

First, manually remove any lingering entries in the Integration Table Mapping (Table 5335) that reference TableNo 50111. You may need to expose this table via a list page or query to clean it up.

Then, recompile and publish your extension to ensure all custom integration objects are properly registered.

Finally, retry the Use Default Connection Setup action. If the error persists, consider resetting the integration via the assisted setup guide instead of the manual page action.

If you’re customizing the Dataverse integration, make sure your virtual tables are correctly defined and that each has a valid primary key and field mapping. Also confirm that your integration user has access to the corresponding Dataverse entities.

Helpful References:
Connect to Microsoft Dataverse – BC
Customizing Dataverse Integration – Dynamics 365 Lab
Dataverse Connection Setup Guide – Dynamicssquare

If you find this helpful, feel free to mark this as the suggested or verified answer.

Cheers
Jeffrey
Suggested answer

YUN ZHU 87,790 Super User 2025 Season 2 on at

Like (1)

Report

Custom Dataverse integration, error on Default Connection Setup

Please remove the following portion of your custom code from codeunit, which appears to be still in your code.

PS:

Dynamics 365 Business Central: Customizing an Integration with Microsoft Dataverse (Integrate custom tables)

https://yzhums.com/17065/

Hope this helps.

Thanks.

ZHU
Suggested answer

Akash Raj 102 on at

Like (3)

Report

Custom Dataverse integration, error on Default Connection Setup

Hi @HT1980

If you're encountering this error in the Sandbox environment, please verify whether the dependent extension has been deployed. This could be a potential reason for the issue.

If the extension is missing, kindly install it and the error should be resolved.

Regards,
Akash Raj
Suggested answer

Mansi Soni 7,736 Super User 2025 Season 2 on at

Like (5)

Report

Custom Dataverse integration, error on Default Connection Setup

Hello,

Hope this will give you some hints:

https://community.powerplatform.com/forums/thread/details/?threadid=a29cb6ec-314c-466b-9341-65f5e2c612c7
https://learn.microsoft.com/en-us/power-apps/developer/data-platform/reference/entities/importmap
https://learn.microsoft.com/en-us/fabric/data-factory/connector-troubleshoot-dynamics-dataverse

Regards,
Mansi Soni
Suggested answer

Jainam M. Kothari 11,929 Super User 2025 Season 2 on at

Like (3)

Report

Custom Dataverse integration, error on Default Connection Setup

May this can help : https://learn.microsoft.com/en-us/troubleshoot/power-platform/dataverse/data-integration/data-integrator-error-management

https://community.dynamics.com/forums/thread/details/?threadid=4663c63b-7553-4e6b-8306-256495e61be3