Informix Error -11420: The MSDTC transaction is no longer active.
Cause and resolution
The MSDTC transaction is no longer active.
The MSDTC transaction is no longer active. This problem could be the result of a short transaction timeout in your application or MSDTC configuration.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-11420 fires when an operation targets an MSDTC transaction that's no longer active — per the official guidance.
- A short transaction timeout in the application or MSDTC configuration, per the official guidance — the named, likely cause.
Solutions / Resolution
- Increase the transaction timeout in the application or MSDTC configuration, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond acting on an already-inactive transaction.
Diagnostic Checks
- Check the application's and MSDTC's configured transaction timeout, and increase it if transactions are becoming inactive before use.
Related Errors / Related Topics
- -11419 — "The connection could not be enlisted with MSDTC." The same underlying cause (short timeout), manifesting as a failed enlistment rather than an inactive transaction.
- -11402 — "Not in DTC transaction." A related MS DTC error, also potentially caused by a low transaction timeout value.
The MSDTC transaction was no longer active, likely due to a short timeout — increase the transaction timeout.