Sybase 11.9.x-12.5 User Manual

Page 173

Advertising
background image

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 sybsystemdb.

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) and subsequent variable-
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

Advertising