Hi All,
We are facing an issue with execute store procedure.
The stored procedure involves an OPENQUERY statement that connects to another server's database table and inserts data into it. Previously, we were using the deprecated Execute Stored Procedure method without any issues. As part of our version upgrade, we have updated with Execute Stored Procedure (Native) method, which is not functioning as expected.
Please find the sample query in the stored procedure - INSERT OPENQUERY (<linkedServerName>, 'Select <columns from linked server DB Table>') SELECT <columns from current DB Table>;
Error Message: The operation could not be performed due to the OLE DB provider "MSOLEDBSQL" for linked server "dxbkdb01_edms" being unable to begin a distributed transaction.
Thanks for your guidance in advance!!
Discussion posts and replies are publicly visible
Did you resolve this issue? I
We were unable to resolve the issue despite raising an Appian support ticket, so we opted to use the Execute Stored Procedure Plugin Smart Service as a replacement of Appian's native.