CHAPTER 6 Adaptive Server Error Messages
847
1765 10 Unable to start a level zero scan on table '%.*s' for UPDATE STATISTICS. This can
happen if some DDL command like ALTER/CREATE INDEX/REORG/DROP is active
on the table.
Explanation: Retry the scan after completing the DDL command.
1766 16 Cannot create syscoordinations tables in any database other than sy bsystemdb.
Explanation: Adaptive Server could not perform the requested action. Modify your
command to meet the Adaptive Server requirement for the objects or variables shown in
the error message.
1767 16 Number of variable length columns exceeds limit of %d for allpage locked
tables. %s for ’%.*s’ failed.
Explanation: Adaptive Server could not perform the requested action. Modify your
command to meet the Adaptive Server requirement for the objects or variables shown in
the error message.
1768 10 Warning: Potential offset of column ’%.*s’ (%d bytes) an d subsequ ent v ariable -
length columns in table %.*s exceeds limit of %d bytes for column-offset of
variable-length columns in DOL tables. Future inserts to this table may fail.
Explanation: This informational messages indicates that your DDL command may
cause problems at future inserts into the DOL table. Check and modify the DDL to meet
the Adaptive Server requirement shown in the error message.
1769 16 Variable-length column ’%.*s’ starts at column-offset %d bytes and is non-
nullable. This will prevent inserting any data into that column as the column
offset exceeds the limit of %d bytes for column-offsets in DOL tables. %s ’%.*s’
failed.
Explanation: Modify your DDL command to meet the Adaptive Server requirement for
the objects or variables shown in the error message.
1770 16 %s failed. Addition of column ’%.*s’ to table ’%.*s’ exceeds maximum row
width. Rows must be between %d bytes and %d bytes.
Explanation: Adaptive Server could not perform the requested action. Modify your
DDL command to meet the Adaptive Server requirement for the objects or variables
shown in the error message.
1771 10 Warning: Maximum row size exceeds allowable width. It is being rounded down
to %d bytes.
Explanation: This informational message indicates that your DDL is being modified to
meet the Adaptive Server requirement for the objects or variables shown in the error
message.
1772 10 Warning: Update of SYSSTATISTICS row (sequence no %d, format ID %d,
column IDs: %s) failed. Statistics row deleted. Regenerate statistics for these
columns.
Explanation: Adaptive Server could not perform the requested action. Modify your
command to meet the Adaptive Server requirement for the objects or variables shown in
the error message.
Number Severity Text and Explanation