Skip to Content
0
Nov 30, 2020 at 09:53 AM

SBO_SP_TransactionNotification distributed transaction

97 Views

Dear all,

in the SBO_SP_TransactionNotification, updating an item master data, I need to execute a check via PL-SQL select statement to a remote db server via Linked Server.

I use the following command:

EXEC sp_executesql @dynamicsql, N'@ResultCountOut INT OUT', @ResultCountOut=@ResultCount OUT

but I have the following error:

[Microsoft][ODBC Driver 13 for SQL Server][SQL Server]The operation could not be performed because OLE DB provider "SQLNCLI11" for linked server
"REMOTE_SAP_CENTRAL" was unable to begin a distributed transaction. 'Company Info' (CINF) (CINF)

I already tried to enable "allow inbound" and "allow outbound" in the MSDTC Windows Service

and to use the SELECT ... FROM OPENQUERY(<linked server>, @sqlstatement) ...
but the issue is not solved.

Please, can someone give me a solution to execute a remote query into the SBO_SP_TransactionNotification?

Best Regards

Emanuele