Error 414

Severity

16

Message text

The current query would generate a key size of %d for a work table.  This exceeds the maximum allowable limit of %d.

Explanation

When you execute a query, Adaptive Server may need to create work tables to temporarily store query results. For example, a work table is used when duplicate rows must be removed in processing a query with an aggregate function. A sysindexes row is built for the work table after checking that the specified command does not violate any limitations on keys for user tables.

Error 414 is raised when you execute a query containing an aggregate function, and the total length of columns named in the group by clause of the query exceeds the maximum limit. The maximum limit depends on the Adaptive Server page size:

Adaptive Server page

Maximum bytes

2K

600

4K

1250

8K

2600

16K

5300

Action

Check the command for possible violations of the maximum size limit. You can correct the problem by doing one of the following:

Versions in which this error is raised

All versions