Oninit
Talk to an expert →

Informix Error -19992: Cannot perform insert/delete/update operations on a replicated table while the table is in alter mode

Cause and resolution

Cannot perform insert/delete/update operations on a replicated table while the table is in alter mode

The specified operation cannot be performed on a table defined for replication if the table is in Enterprise Replication alter mode. If you want to perform the specified operation, you must unset the Enterprise Replication alter mode.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19992 fires when DML is attempted on a table currently in Enterprise Replication (ER) alter mode — per the official guidance.

  1. INSERT/DELETE/UPDATE attempted while the table is in ER alter mode, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Unset the ER alter mode, per the official guidance, before performing DML.
Examples
Clearing alter mode
$ cdr alter --off mydb:myowner.mytable
Diagnostic Checks
  1. Check the table's ER alter-mode state, and clear it before retrying the DML operation.
Related Errors / Related Topics
  • -19991 — "Table is not in Enterprise Replication alter mode" The mirror-image restriction, about an operation needing alter mode set rather than DML being blocked while it IS set.

DML is blocked while the table is in ER alter mode — clear alter mode first.