CHAPTER 6 Adaptive Server Error Messages
853
1923 16 A table cannot have more than one primary key, attempt to define a second primary key
failed on table `%.*s'.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
1924 16 You cannot create an index on the sysaudits table.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
1927 25 Create Index failed because user curwrite level is not equal to the level of table `%.*s'.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
1928 16 Cannot create clustered index '%.*s' on '%.*s' which has %d partitions because the
maximum number of partitions allowed on a table with clustered index is %d.
Explanation: Refer to the writeup for this error.
1929 20 Failed to reserve/initialize allocation hints space in index `%.*s' on table `%.*s'.
Explanation: Adaptive Server encountered an internal error affecting the current
process. Report the error to your System Administrator.
1930 16 Cannot specify more than %d column names for index key list. %d specified. Chec k
sp_dboption for nonunique index option, it has added an extra key f or indent ity coulu mn.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
(Discontinued in 11.9.2).
1931 16 You cannot re-create the same non-clustered index (ID %d) for object ID %ld in database
`%.*s' because you dropped it twice in a single transaction. Transaction rolled back.
Explanation: For a database which has been marked for `ddl in tran', a non-clustered
index cannot be re-created if it has already been dropped twice within a transaction.
1932 16 You cannot re-create the same clustered index for object ID %ld in database `%.*s' more
than once in a single transaction. Transaction rolled back.
Explanation: For a database which has been marked for `ddl in tran', a clustered index
cannot be re-created more than once within a transaction.
1933 12 The object `%.*s' is not a partitioned table. UPDATE PARTITION STATISTICS can only
be run on partitioned tables.
Explanation:
1934 16 Invalid partition number %d. Valid partition number is a positive integer.
Explanation: Re-try the query using a valid number.
1936 10 Warning: Clustered index '%.* s' has be e n cre a te d on the em p t y pa rtitioned table '%.*s'.
All insertions will go to the first partition. To distribute the data to all the partitions, re-
create the clustered index after loading the data.
Explanation: This is an informational message. Take the indicated actio n if you wish to
distribute data across partitions.
Number Severity Text and Explanation