Oninit
Talk to an expert →

Informix Error -8102

Cause and resolution

There may be only one AFTER or BEFORE GROUP OF clause for any single column specified in the ORDER BY command.

The report contains more than one AFTER GROUP OF clause for a certain column or more than one BEFORE GROUP OF clause. Only one of each can name a given column. However, you can combine the statements from the multiple clauses into a single clause.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8102 fires when a report has more than one AFTER GROUP OF (or more than one BEFORE GROUP OF) clause for the same column — per the official guidance.

  1. More than one AFTER GROUP OF clause naming the same column, per the official guidance — the first named case.
  2. More than one BEFORE GROUP OF clause naming the same column, per the official guidance — the second named case.
Solutions / Resolution
  1. Combine the statements from the multiple clauses into a single clause, per the official guidance.
Examples
Duplicate AFTER GROUP OF clauses
ORDER BY customer_id
...
AFTER GROUP OF customer_id
  PRINT "Subtotal:"
AFTER GROUP OF customer_id
  SKIP 1 LINE
-- -8102: two AFTER GROUP OF clauses for customer_id
Corrected
AFTER GROUP OF customer_id
  PRINT "Subtotal:"
  SKIP 1 LINE
Diagnostic Checks
  1. Check every ORDER BY column for more than one AFTER GROUP OF/BEFORE GROUP OF clause, and combine duplicates into one.
Related Errors / Related Topics
  • -8103 — "In order for the BEFORE or AFTER GROUP OF clause to function properly, the column specified in the clause must also have been specified as a sort column in the ORDER BY command..." A related GROUP OF-clause restriction, about the column matching ORDER BY rather than being duplicated.

A column has more than one AFTER GROUP OF or BEFORE GROUP OF clause — combine them into one.