Oninit
Talk to an expert →

Informix Error -19816: Cannot perform this operation on a table defined for replication.

Cause and resolution

Cannot perform this operation on a table defined for replication.

The specified operation cannot be performed on a table if Enterprise Replication is defined on the table. If you want to perform the specified operation, you must delete all replicates defined on this table.

If the table is being captured using the Change Data Capture interface, then you must use CDC API functions to stop data capture and disable full row logging on the table.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-19816 fires when an operation is attempted on a table with Enterprise Replication (ER) defined on it — per the official guidance.

  1. A table with active ER replicates, per the official guidance — the first named cause.
  2. A table being captured via the Change Data Capture (CDC) interface, per the official guidance — the second named cause.
Solutions / Resolution
  1. Delete all replicates defined on the table, per the official guidance, if ER is the cause.
  2. Use CDC API functions to stop data capture and disable full row logging on the table, per the official guidance, if CDC is the cause.
Examples
N/A

No specific triggering statement is documented beyond the operation being blocked by replication/CDC.

Diagnostic Checks
  1. Check for ER replicates or active CDC capture on the table, and remove/stop them before retrying the operation.
Related Errors / Related Topics
  • -19812 — "Illegal usage of replication shadow columns." A related replication restriction, about the CRCOLS themselves rather than operations on a replicated table generally.

The table is defined for ER replication or CDC capture — remove replicates or stop CDC capture before retrying.