CHAPTER 6 Adaptive Server Error Messages
851
Server Error Messages 1900-19991837 16 CREATE DATABASE failed to create a dedicated data segment. The specified data
segment size is too small to accommodate the data from the model database
.
Explanation: Adaptive Server could not perform the requested action. Check que ry and
retry.
Number Severity Text and Explanation
Number Severity Text and Explanation
1901 16 Column `%.*s' -- Can't create index on a column of BIT data type.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
1902 16 Cannot create more than one clustered index on table `%.*s'. Drop the existing c lustered
index `%.*s' before creating another
Explanation: Refer to the writeup for this error.
1903 16 %d is the maximum allowable size of an index. Composite index specified is %d bytes.
Explanation: Refer to the writeup for this error.
1904 16 Cannot specify more than %d column names for index key list. %d specified.
Explanation: A composite index is any index that uses more than one column. Error
1904 occurs when more than 31 columns are combined in a single composite index .
Change your create index statement to include no more than the maximum number of
columns allowed.
1905 21 Could not find `zero' row for index `%.*s' the table in sysindexes.
Explanation: Adaptive Server encountered an internal error affecting all processes in
the current database. Report the error to your System Administrator. Adaptive Server
must be restarted and dbcc diagnostics run.
1906 11 Cannot create an index on table `%.*s', because this table does not exist in dat a bas e
`%S_DBID'.
Explanation: Command failed. Check your database for the object not found and re-
enter the command with the correct name.
1907 10 Create index on non-empty table not supported yet
Explanation: This is an informational message but may require follow-up action.
Contact your System Administrator.