Skip to Content
0

BCM System Configurator, Distributed transaction error

Dec 06, 2016 at 12:43 PM

260

avatar image

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!

10 |10000 characters needed characters left characters exceeded

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...

0
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member Dec 07, 2016 at 12:27 PM
1

From the document describing the installation with five servers:




dtcconf.png (69.3 kB)
Show 4 Share
10 |10000 characters needed characters left characters exceeded

changes have not helped. the error persists

0
Former Member
Ramil Zinnatullin

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

0

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)?

0
Former Member
Ramil Zinnatullin

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.

0
avatar image
Former Member
Dec 13, 2016 at 07:58 AM
1

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:

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

BR
-Lasse

Share
10 |10000 characters needed characters left characters exceeded
Ramil Zinnatullin Dec 07, 2016 at 04:24 AM
0

the service is running, but the error is present.

there are detailed instructions for configuring the driver?


odbc1.png (12.5 kB)
odbc2.png (39.8 kB)
Share
10 |10000 characters needed characters left characters exceeded