Oninit
Talk to an expert →

Informix Error -19989: Enterprise Replication is not in active state

Cause and resolution

Enterprise Replication is not in active state

The specified operation cannot be performed on a table defined for replication if Enterprise replication is not in active state. If you want to perform the specified operation, you must start Enterprise Replication.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19989 fires when an operation is attempted on a table defined for replication while Enterprise Replication (ER) isn't active — per the official guidance.

  1. ER not active on a table defined for replication, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Start Enterprise Replication, per the official guidance, before retrying the operation.
Examples
Checking ER status
$ cdr list server
Diagnostic Checks
  1. Check whether ER is running (cdr list server), and start it if needed.
Related Errors / Related Topics
  • -19816 — "Cannot perform this operation on a table defined for replication." A related replication-state error, about a table having active replicates/CDC capture generally rather than ER being inactive.

ER isn't active on a table defined for replication — start ER before retrying.