Troubleshooting Sybase Error Code from Error 21110 to 22000


Sybase Error Code 21110
Sybase SQL Code –1000281L
Column %2 has unsupported data type for index rebuild. %1
Sybase Error Code 21111
Sybase SQL Code –1010017L
You cannot create tables on a query node without a local IQ Store. %1
Sybase Error Code 21112
Sybase SQL Code –1010018L
Shared and local tables cannot participate in a JOIN INDEX. %1
Sybase Error Code 21113
Sybase SQL Code –1010019L
A Query node may not modify objects in the main IQ Store. %1

Sybase Error Code 21114
Sybase SQL Code –1010020L
Nothing to backup: Query node has no local store. %1
Sybase Error Code 21115
Sybase SQL Code –1010021L
Foreign key constraint on a local table cannot reference a shared table. %1
Sybase Error Code 21116
Sybase SQL Code –1000282
DBCC must be restricted to the MAIN or LOCAL store only. %1
Sybase Error Code 21117
Sybase SQL Code –1010022L
Cannot modify main store from a multiplex query server. %1
Sybase Error Code 21118
Sybase SQL Code –1009154L
Cannot alter dbspace when a backup is in progress

Sybase Error Code 21119
Sybase SQL Code –1006267L
%2 blocks is greater than the partition size of %3 blocks %1
Sybase Error Code 21120
Sybase SQL Code –1001062L
IQ does not support ASE extended group by syntax (%2) with OLAP function %1
Sybase Error Code 21121
Sybase SQL Code –1010023L
IQ does not support updatable cursor with JOIN/UNION/GROUP BY/DISTINCT/SET,OLAP function. %1
Sybase Error Code 21122
Sybase SQL Code –1010024L
Column ‘%2’ is not updatable if it is long binary/varchar, rowid, referenced in the select list, or not in FOR UPDATE list. %1
Sybase Error Code 21123
Sybase SQL Code –1010025L
The current row can not be updated since it has been deleted. %1
Sybase Error Code 22000
Sybase SQL Code –1009155L
Cannot perform requested command as there is an ALTER DBSPACE command in progress. %1

Above are list of Sybase Error Code Messages from Error Code 21110 to 22000 received while performing certain operation against Sybase Database or related products.

What are Sybase Error Codes?

Sybase error codes are a set of error codes for use by all Sybase products, including Adaptive Server Enterprise. For every Sybase error code returned by Sybase IQ, there is a pair of matching Sybase IQ error codes (SQLCODE and SQLSTATE). In many cases Sybase IQ error codes offer a finer level of granularity than their Sybase error code counterparts, thus some Sybase error codes in the following table are non-unique.

Many of the errors contain the characters %1, %2 and so on. These are replaced by the parameters to the error message.

Hope this was helpful.

SQLServerF1 Team
Information about Sybase Error Code Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *