Informix Error -19814: Cannot drop CRCOLS when table does not have replication shadow columns.
Cause and resolution
Cannot drop CRCOLS when table does not have replication shadow columns.
The specified table was not created with the WITH CRCOLS syntax, or it has not been altered to include the CRCOLS. You cannot alter this table and drop the CRCOLS because these columns do not exist on this table.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-19814 fires when ALTER TABLE tries to drop CRCOLS from a table that was never created (or
altered) WITH CRCOLS — per the official guidance.
- A table without CRCOLS altered to drop CRCOLS, per the official guidance — the direct, only cause.
Solutions / Resolution
- Skip the
ALTER TABLE ... DROP CRCOLS— the table has no replication shadow columns to drop, per the official guidance.
Examples
Dropping CRCOLS from a table that never had them
CREATE TABLE mytab (id INT);
ALTER TABLE mytab DROP CRCOLS;
-- -19814: mytab has no replication shadow columns
Diagnostic Checks
- Check whether the table was created or altered
WITH CRCOLS, before attempting to drop them.
Related Errors / Related Topics
- -19812 — "Illegal usage of replication shadow columns." The general restriction this is a specific case of.
- -19813 — "Cannot add CRCOLS when table already has replication shadow columns." The mirror-image error, about adding existing CRCOLS rather than dropping nonexistent ones.
The table has no replication shadow columns to drop — skip the DROP CRCOLS alteration.