cancel
Showing results for 
Search instead for 
Did you mean: 

SBO_SP_TransactionNotification distributed transaction

EmanueleCroci
Explorer

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

Accepted Solutions (0)

Answers (1)

Answers (1)

EmanueleCroci
Explorer

Solved activating the "allow inbound" and "allow outbound" option in the MS DTC component service settings on both sql server machines (source and destination).

Best Regards

Emanuele