Troubleshooting Sybase Error Code from Error 21095 to 21109


Sybase Error Code 21095
Sybase SQL Code –1000277
\allocation database\is the only command allowed in drop leaks mode. %1
Sybase Error Code 21096
Sybase SQL Code –1000278
\resetclks\must be run in single-node mode with \allocation database\. %1
Sybase Error Code 21097
Sybase SQL Code –1001051L
Query returns %2 data > 2GB. Use %3 %1
Sybase Error Code 21098
Sybase SQL Code –1001052L
Parameter %2 must be long binary/varchar type. %3 %1

Sybase Error Code 21099
Sybase SQL Code –1001053L
Wrong number of parameters to function %2 %1
Sybase Error Code 21100
Sybase SQL Code –1001054L
You cannot specify long binary/varchar column in the ORDER/GROUP by clause or in an aggregate function. %1
Sybase Error Code 21101
Sybase SQL Code 1001055L
An error occurred loading %1 column, %2, for %3, rowid %4.
Sybase Error Code 21102
Sybase SQL Code 1001056L
An error occurred extracting %1 column, %2, for %3.

Sybase Error Code 21103
Sybase SQL Code –1001057L
You must use BFILE() to extract %2 column. %1
Sybase Error Code 21104
Sybase SQL Code –1001058L
The secondary file name, %2, is too long. %1
Sybase Error Code 21105
Sybase SQL Code –1006266L
Found bad sector on raw device: %1
Sybase Error Code 21106
Sybase SQL Code –1001059L
IQ does not support ASE extended group by syntax (%2) with join tables %1
Sybase Error Code 21107
Sybase SQL Code –1001060L
IQ does not support ASE extended group by columns (%2) from view/derived table with distinct/group by/aggregations %1
Sybase Error Code 21108
Sybase SQL Code –1000279L
Column ‘%2’ must be included in the insert. It is part of a multicolumn index. %1
Sybase Error Code 21109
Sybase SQL Code –1000280L
Query node version information has not changed

Above are list of Sybase Error Code Messages from Error Code 21095 to 21109 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 *