Error 511

Severity

16

Message text


Version 12.5 and later

Attempt to update or insert row failed because resultant row of size %d bytes is larger than the maximum size (%d bytes) allowed for this table.

Version 12.0.x and earlier

Updated or inserted row is bigger than maximum  size (%d bytes) allowed for this table.

Explanation

This error occurs when you try to insert or update a row that is longer than the maximum allowable length. The maximum allowable row size that includes row overhead depends on the Adaptive Server page size:

Adaptive Server page max

APL row length max

DOL row length

2K

1962

1964

4K

4010

4012

8K

8016

8108

16K

16298

16298

The use of variable or fixed columns will alter the size of the overhead required for a row.

Error 511 is caused by database design errors (for example, a table designed with the potential for rows containing more than the maximum allowable characters). The following warning is given when you create a table that has the potential for rows exceeding the maximum row size (that is, the maximum length of all columns added up is greater than the allowable number of characters):

Msg 1708, Level 16, State 1:Warning: Row size could exceed row size limit, 
which is %d bytes.

Action

Use one of these actions to resolve the error:

Versions in which this error is raised

All versions