BCM System Configurator, Distributed transaction error

[former_member342317]

Hello!

There was a following problem when remove any queue (Queue Management -> Queue ->Delete)
The log history record appears:

Deleting failed to enlist connection to DTC transaction (CONFIG/25S12/[Microsoft][ODBC SQL Server Driver]Distributed transaction error)

when creating a queue of such an error does not occur...

what changes need to be made to solve the problem
thanks!

[former_member582809]

Hi Ramil!!

have you been able to solve this issue?, I have exactly the same but it occurs when importing OB campaigns.

I did all the recommended tests on the web (even those of sap) for this problem (even the DTCPing!), everything seems to be fine; but the error continues.

I would greatly appreciate your help.

Thank you very much,.

Cheers...

[former_member187604]

Hello

Please note, that you need to have the MSDTC correctly configured on all application and SQL server in the system, and firewalls should not block the traffic in relevant ports/directions. The firewall issue is earier to control if you specify certain predefined and fixed port range for MSDTC on all you servers. Please review the following MS links:

• Configuring MS DTC Services
• Configuring Microsoft Distributed Transaction Coordinator (DTC) to work through a firewall
• How to Configure MSDTC to Use a Specific Port in Windows Server 2012/2012R2

To test whether the MSDTC communication is working properly, you could try Microsoft's DTCPING tool.

BR
-Lasse

[Former Member]

From the document describing the installation with five servers:

[former_member342317]

changes have not helped. the error persists

[Former Member]

Try enabling the "allow remote clients" checkbox. I checked our configuration and we have it enabled.

[former_member342317]

unfortunately it did not help checked.

prompt, these changes in msdtc to be done only on the machine where installed SC or right at all (BD \ RP \ ect)?

[Former Member]

I'm not sure what your server landcape is like, but these settings should be probably changed where the database instance lives - be it one server or a cluster.

We have the databases in a failover cluster so the changes would be made on the servers hosting the failover nodes.

[former_member342317]

the service is running, but the error is present.

there are detailed instructions for configuring the driver?