External Tables and distributed transactions

giuseppemaino7

Hi all,
I am a fan of External Tables. I prefer them to the linked objects for their flexibility and no mandatory use of views.
I have a problem with this scenario. I have the SQL instance of Nav on a server while the external table points on a server on another instance SQL.

I have to write in the external table some informations about warehouse receipt lines. If I write with a test function all works fine.
If I call the same function during the post of the warehouse (Codeunit 5760 Whse.-Post Receipt) the records in the external tables are written, the warehouse is deleted but no posted warehouse appear!!

I have configured DTC (Microsoft Distributor Coordinator) in both servers.
Anyone have any suggestion to solve this problem?

The versione of Nav is Business Central 14.0

Thank you

vaprog

Hi,

I did not understand what you do and get exactly. But take note: There is no single transaction that spans the databases. Each database has it's own transaction.

See External Tables - How commits on external tables are handled