Oninit
Talk to an expert →

Informix Error -1800

-1800 Invalid transaction state.

You must commit or rollback the current transaction before you disconnect.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-1800 fires when a disconnect is attempted while a transaction is still active — per the official guidance, the current transaction must be committed or rolled back before disconnecting.

  1. A DISCONNECT attempted with an open transaction, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Commit or rollback the current transaction before disconnecting, per the official guidance.
Examples
Disconnecting with an open transaction
BEGIN WORK;
UPDATE orders SET status = 'shipped' WHERE order_id = 42;
DISCONNECT CURRENT;
-- -1800: the transaction was never committed or rolled back
Corrected
BEGIN WORK;
UPDATE orders SET status = 'shipped' WHERE order_id = 42;
COMMIT WORK;
DISCONNECT CURRENT;
Diagnostic Checks
  1. Check whether a transaction is currently open on the connection before attempting to disconnect.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -1800 in this set yet.

An active transaction wasn't closed before disconnecting — commit or rollback first.