From version 4 on, UBIK® uses the Distributed Transaction Coordinator (MSDTC or DTC) to manage database transactions. However, there's the necessity for correct configuration on both the database server as well as the application server to make it work. This article explains how to do that.
Problem Symptoms
- UBIK® Studio or a UBIK® service can't connect to your database or fails to create a session
- Database view creation or instance data transfer doesn't work because of an exception
- There's an error/exception log entry like: "Communication with the underlying transaction manager has failed"
Solution
See also
- How do I enable MSDTC on SQL Server (StackOverflow)
- Enable Network DTC Access (learn.microsoft.com)
- Configure DTC to work through firewalls (learn.microsoft.com) using custom port range (recommended only if necessary!)
- Powershell New-NetFirewallRule (learn.microsoft.com)
- Test-Dtc (learn.microsoft.com)
- Trouble-shoot MSDTC connectivity issues (learn.microsoft.com)
- Trouble-shooting MSDTC issues with DTCPing (puneet-gupta.github.io)