Oninit
Talk to an expert →

Informix Error -32190: Cannot aggregate label column.

Cause and resolution

Cannot aggregate label column.

Check if label column is supplied to an aggregate function.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-32190 fires when a label column is passed to an aggregate function — per the official guidance.

  1. A label column supplied to an aggregate function, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Remove the label column from the aggregate function, per the official guidance's implication, and aggregate a different column instead.
Examples
N/A

No specific triggering statement is documented beyond aggregating a label column.

Diagnostic Checks
  1. Check the aggregate function's argument for a label column, and replace it with a non-label column.
Related Errors / Related Topics
  • -32132 — "Cannot order by label." A related label-column restriction, on ORDER BY rather than aggregate functions.

A label column was supplied to an aggregate function, which isn't legal — aggregate a different column instead.