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

Error Message When Trying to Access Integration Tables

(0) Share

Report

Posted on by eaf-joseph

Greetings,

This is for the Cloud version of Business Central 16.

We are getting this error message when we attempt to access Integration tables for CDS/Sales. We get the error when we attempt to update an integration table via a CodeUnit or try to access the table via a URL to view what is in it. Example: businesscentral.dynamics.com/.../

Table connection for table type CRM must be registered using 
RegisterTableConnection or cmdlet New-NAVTableConnection before 
it can be used.

Any ideas on how to resolve it would be appreciated! Thanks.

Categories:

Dynamics 365 Business Central

I have the same question (0)

All responses (9)

Answers (0)

anthonywestphal 35 on at

Like (1)

Report

Hi,

Yes, we are getting the same error when attempting to access the "Accounts - Common Data Service" list in the front end. We also receive it on occasions when accessing certain fields in "Integration Tables and Mapping" after running a full sync.

It is also, I believe, causing issues with the synchronisation between the common data service and BC. I tried running a full sync on "Customers" in which Sales had 82000 records and BC had 0. The intent was to have the sync created the 82000 records in BC (something we have previously been able to do prior to the April update ). The sync only created 500 of the records in BC. On checking the log the remaining 80000+ records were nowhere to be seen. Not under "failed" or "skipped". I assume this is to do with the above error.

(Yes, the sync only coupled records was un-ticked.)

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (1)

Report

Hello,

Does this issue also happen when doing similar things via WebClient?

Thanks.

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

Could you please disable user mapping from the connection setup page and then perform a test connection. From there, try to see if it does work from the GUI only.

Thanks.

Was this reply helpful? Yes No
eaf-joseph 42 on at

Like (1)

Report

Marco,

They are disabled. It does the same thing via GUI and API.

Please see attached settings.

These are our current settings in our Sandbox, same setup in Production. Same issues on both.

Thanks

Was this reply helpful? Yes No
Suggested answer

Marco Mels on at

Like (0)

Report

Hello,

Best would be to raise this issue via your partner to Microsoft for further analysis. Maybe it is a time out when synch is running, but maybe this or maybe that are not very helpful. I guess a ticket would be best thing here.

Thanks.

Was this reply helpful? Yes No
anthonywestphal 35 on at

Like (0)

Report

I lodged a ticket with Microsoft and got this response:

Looks like its in their hands now.

Was this reply helpful? Yes No
mobatali 15 on at

Like (0)

Report

Any luckeaf-joseph with this issue? we're having the same problem with BC V20.

Thanks a lot

Was this reply helpful? Yes No
Suggested answer

Nitin Verma 21,698 Moderator on at

Like (0)

Report

Hi eaf-joseph ,

Can you please try synchronize setup again and then try again? See the below image.

Was this reply helpful? Yes No
mobatali 15 on at

Like (0)

Report

Hi Nitin,

That's not an option since my code is running on an event subscription to read a CRM Contact Table.

Thanks

Mo

Was this reply helpful? Yes No