Informix Error -32140: File handle and tabid are not consistent.

Cause and resolution

File handle and tabid are not consistent.

This message indicates an internal error. The table handle that is provided to an ISAM function is not a legal handle for the table whose tabid is also provided as a function argument.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32140 fires when the table handle passed to an ISAM function isn't a legal handle for the table identified by the tabid argument in the same call — per the official guidance, this is reported as an internal error.

A mismatched table handle and tabid argument passed to an ISAM function, per the official guidance — the direct, only cause.

Solutions / Resolution

Note all circumstances and contact IBM Informix Technical Support, since this is reported as an internal error with no further user-actionable detail.

Examples

N/A

No specific triggering statement is documented — this is an internal error.

Diagnostic Checks

Note the ISAM function and the table/handle involved, and escalate to IBM Informix Technical Support.

Related Errors / Related Topics

-32104 — "Internal error; no table descriptor." A related internal table-consistency error, on a missing descriptor rather than a mismatched handle/tabid pair.

An ISAM function received a table handle inconsistent with its tabid argument — this is an internal error; contact IBM Informix Technical Support.