Oninit
Talk to an expert →

Informix Error -8115: There may be no more than 8 sort columns specified in the ORDER BY command.

Cause and resolution

There may be no more than 8 sort columns specified in the ORDER BY command.

ACEGO limits the number of columns that can be ordered. You must reduce the number of columns that are listed following ORDER BY.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-8115 fires when ORDER BY lists more than 8 sort columns — per the official guidance, ACEGO limits the number of columns that can be ordered.

  1. More than 8 columns listed in ORDER BY, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Reduce the number of columns listed after ORDER BY, per the official guidance, to 8 or fewer.
Examples
Too many ORDER BY columns
ORDER BY col1, col2, col3, col4, col5, col6, col7, col8, col9
-- -8115: 9 columns exceeds the 8-column limit
Diagnostic Checks
  1. Count the columns listed after ORDER BY, and reduce to 8 or fewer.
Related Errors / Related Topics

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

ORDER BY lists more than 8 sort columns — reduce to 8 or fewer.