Informix Error -26288: API error: GROUP BY field duplicated.
Cause and resolution
API error: GROUP BY field duplicated.
The host fields in the GROUP BY clause in the current EXTRACT statement are duplicated. Correct and rerun the EXTRACT statement.
Oninit® Troubleshooting Guidance
Reasons / Common Causes
-26288 fires when an EXTRACT statement's GROUP BY clause lists the same host field
more than once — per the official guidance.
- A host field duplicated in the
GROUP BYclause, per the official guidance — the direct, only cause.
Solutions / Resolution
- Correct the
EXTRACTstatement to remove the duplicateGROUP BYfield and rerun, per the official guidance.
Examples
N/A
No specific triggering statement is documented beyond a duplicated GROUP BY field.
Diagnostic Checks
- Check the
GROUP BYclause for a repeated field, and remove the duplicate.
Related Errors / Related Topics
- -26287 — "API error: ORDER BY field duplicated." The same class of duplicate-field
error, for
ORDER BYrather thanGROUP BY.
An EXTRACT statement's GROUP BY clause had a duplicated field — remove the duplicate
and rerun.