Troubleshooting Sybase Error Code from Error 20109 to 20124


Sybase Error Code 20109
Sybase SQL Code –1009088L
Attempted to add a duplicate key. %1
Sybase Error Code 20110
Sybase SQL Code –1009089L
The size of the value is more than the maximum allowed for the field. Value: %2 %1
Sybase Error Code 20111
Sybase SQL Code –1009090L
Page size selected is too small for this datatype. %1
Sybase Error Code 20112
Sybase SQL Code –1009091L
Attempt to create a B-Tree with RecordSize+KeySize too large. %1

Sybase Error Code 20113
Sybase SQL Code –1009092L
Must provide a key comparison routine on object creation. %1
Sybase Error Code 20114
Sybase SQL Code –1009093L
The maximum key size must be between 1 and 5300. Key size: %2 %1
Sybase Error Code 20115
Sybase SQL Code –1009094L
Cannot use raw partition for MESSAGE LOG or ROW LOG. %1
Sybase Error Code 20116
Sybase SQL Code –1009095L
MESSAGE LOG and ROW LOG cannot be the same on-disk file. %1
Sybase Error Code 20117
Sybase SQL Code –1009096L
%3 integrity constraint limit (%2) exceeded. %1

Sybase Error Code 20118
Sybase SQL Code –1009097L
Cumulative total (%2) for all integrity constraint violations exceeded. %1
Sybase Error Code 20119
Sybase SQL Code –1009098L
Invalid MESSAGE LOG or ROW LOG filename. %1
Sybase Error Code 20121
Sybase SQL Code –1009100L
Database segment ‘%2’ is not valid. It is of type ‘%3’. Type BTYPE_DBEXT was expected. This segment cannot be used. %1
Sybase Error Code 20122
Sybase SQL Code –1009101L
Database segment ‘%2’ is not valid. PhysicalNBlocks Found: %3 PhysicalNBlocks Expected: 1. This segment cannot be used. %1
Sybase Error Code 20123
Sybase SQL Code –1009102L
Incorrect HG Index Version (%2): Index must be dropped by previous version of Sybase IQ and recreated. %1
Sybase Error Code 20124
Sybase SQL Code –1009103L
Number of unique values exceeded for index. %2 %3 %1

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