Server Error Messages 1900-1999 854
1937 10 Warning: Clustered index '%.*s' has been c reat ed on the pa rtit ione d tabl e '%. *s' with % d
partitions using the segment %d with %d devices. For complete I/O parallelism, each
partition should be on a separate device.
Explanation: This is an informational message but may require follow-up action.
Contact your System Administrator.
1938 16 Cannot create index or unique constraint because cursor '%.*s' is still open. Close the
cursor(s) before creating index or constraint.
Explanation: Re–try the query after taking the indicated action.
1939 16 Cannot create a clustered index with sorted_data option on the 11.0 partitioned table
'%.*s'. This option isn't allowed. To create the index do not use this option.
Explanation: Re–try the query using the recommended action.
1940 16 Cannot create clustered index on table '%.*s' because there are one or more isolation level
0 scans, or RE ORG command, active on the table.
Explanation: Retry the command after the scans are complete.
1941 10 Warning: Clustered index '%.*s' has been created with ignore_dup _row on table '%.*s',
which uses data-only locking. ignore_dup_row cannot be enforced for sub sequent
insertions and updates.
Explanation: This is an informational message but may require follow-up action.
Contact your System Administrator.
1942 16 You cannot drop and re-create the same clustered index with sorted data for object ID %ld
in database '%.* s' in a single transaction. Transaction rolled back.
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.
1944 16 The clustered index cannot be created on a partitioned table using serial sort. The
CONSUMER value specified in the CREATE INDEX command must be greater than 1.
Explanation: Modify your DDL command to meet the Adaptive Server requirement for
the objects or variables shown in the error message.
Number Severity Text and Explanation