Informix Error -29012: One or more tables have been dropped, altered, or renamed.

Cause and resolution

One or more tables have been dropped, altered, or renamed.

A prepared statement is no longer valid because the schema of the tables that it references has changed. You must prepare the statement again.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-29012 fires when a prepared statement's referenced tables have had their schema changed — per the official guidance, the prepared statement is no longer valid.

A schema change (drop/alter/rename) on a table the prepared statement references, per the official guidance — the direct, only cause.

Solutions / Resolution

Prepare the statement again, per the official guidance.

Examples

N/A

No specific triggering statement is documented beyond a schema change invalidating a prepared statement.

Diagnostic Checks

Check whether the referenced tables' schema recently changed, and re-PREPARE the statement.

Related Errors / Related Topics

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

A prepared statement's referenced table schema changed, invalidating it — prepare the statement again.