16
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.
Updated or inserted row is bigger than maximum size (%d bytes) allowed for this table.
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.
Use one of these actions to resolve the error:
If error 511 is caused by a table containing rows with more than the maximum row size, divide the table into two or more tables so that no row length is more than the allowable number of characters.
If error 511 error does not appear to be caused by the above situation, call Sybase Technical Support.
All versions
