Informix Error -9832: Could not find routine routine_name while resolving compare routine.

Cause and resolution

Could not find routine routine_name while resolving compare routine.

Either the comparison routine for one or more key parts of the index no longer exists in the database, or the comparison routine required to perform a sort cannot be found. You need to re-create the compare routine. If an index is involved, the index needs to be dropped.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-9832 fires when a comparison routine needed for an index or a sort can't be found — per the official guidance.

The comparison routine for an index key part no longer existing in the database, per the official guidance — the first named cause; if an index is involved, it must be dropped.
The comparison routine required to perform a sort not being found, per the official guidance — the second named cause.

Solutions / Resolution

Re-create the compare routine, per the official guidance.
If an index is involved, drop it, per the official guidance.

Examples

N/A

No specific triggering statement is documented; the named routine varies.

Diagnostic Checks

Check the system catalog for the named compare routine, and re-create it, or drop the affected index if one is involved.

Related Errors / Related Topics

-9831 — "Could not find opclass id opclass_ID while resolving compare routine for index." A related index-corruption error, on a missing operator class rather than a missing routine.
-9833 — "Could not find extended type type_ID for index." A related index-corruption error, on a missing extended type rather than a missing routine.

The comparison routine needed for an index or sort couldn't be found — re-create it, and drop the index if one is involved.