Informix Error -25849: The indexkey size exceeds the catalog column size.
Cause and resolution
The indexkey size exceeds the catalog column size.
The error occurred due to encoded indexkey size excceds the szie of sysindcies.indexkey column. If you used functional index with constants reduce the size of the constant.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-25849 fires when a functional index's encoded index-key size exceeds the size of the
sysindices.indexkey catalog column — per the official guidance.
- An encoded index key too large for
sysindices.indexkey, per the official guidance — the direct, only cause.
Solutions / Resolution
- If using a functional index with constants, reduce the size of the constant, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond an oversized encoded index key.
Diagnostic Checks
- Check the size of any constant arguments in the functional index, and reduce them.
Related Errors / Related Topics
- -25848 — "The functional key argument is invalid." A related functional-index error, on argument validity rather than encoded key size.
A functional index's encoded key exceeded the sysindices.indexkey catalog column
size — reduce the size of any constant arguments.