Oninit
Talk to an expert →

Informix Error -3037

-3037 The column column-name is not a composite column. Build

your form again.

The column column-name is mentioned as part of a COMPOSITE in the INSTRUCTIONS section of the form specification. However, no composite index (an index over all the columns of a composite key) exists over this column and its fellows in the database. After the form was compiled, the composite index was dropped. Either it should be restored, or the form should be revised.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-3037 fires at runtime when a column named as part of a COMPOSITE in the form's INSTRUCTIONS section no longer has a corresponding composite index in the database — per the official guidance, the composite index was dropped after the form was compiled.

  1. The composite index over the column and its fellow columns was dropped, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Either restore the composite index, or revise the form, per the official guidance.
Examples
Restoring the composite index
CREATE INDEX idx_order_items ON order_items (order_id, item_seq);
Diagnostic Checks
  1. Check whether a composite index still exists over the column and its fellow composite columns, and either restore it or revise the form to drop the COMPOSITE reference.
Related Errors / Related Topics

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

A composite index the form's COMPOSITE instruction relies on was dropped — restore it, or revise the form and rebuild.