Troubleshooting Sybase Error Code from Error 20786 to 20800


Sybase Error Code 20786
Sybase SQL Code –1000126L
This database must be upgraded. %1
Sybase Error Code 20787
Sybase SQL Code –1000127L
The LIMIT specified, ‘%2’, is too large. %1
Sybase Error Code 20788
Sybase SQL Code –1000128L
You must deletee from join index %2 before you can deletee from table %3. %1
Sybase Error Code 20789
Sybase SQL Code 1000129L
%1 row(s) deleted from index ‘%2’ in %3 seconds.

Sybase Error Code 20790
Sybase SQL Code 1000130L
%1 row(s) deleted from index ‘%2’ on field ‘%3’, %4 seconds.
Sybase Error Code 20791
Sybase SQL Code –1000131L
The DELIMITED BY and LIMIT options are valid for WD indexes only. %1
Sybase Error Code 20792
Sybase SQL Code –1000132L
In table ‘%2’, the START ROW ID value (%3) must be greater than %4. Data has already been inserted at this location. %1
Sybase Error Code 20793
Sybase SQL Code –1000133L
During the LOAD into table ‘%2’, the LOAD statement’s column count (%3) must be between 1 and %4. Check the LOAD statement’s ‘load-specification’. %1
Sybase Error Code 20794
Sybase SQL Code –1000134L
Column ‘%2’ is being inserted into twice by this INSERT command. %1

Sybase Error Code 20795
Sybase SQL Code –1000135L
Cannot open the existence list for table ‘%2’. %1
Sybase Error Code 20796
Sybase SQL Code –1000136L
A mismatch exists between the existence bitmaps in the insert object. %1
Sybase Error Code 20797
Sybase SQL Code –1000137L
While inserting, table ‘%2’ already had a Complete started. %1
Sybase Error Code 20798
Sybase SQL Code –1000138L
A data conversion error has occurred while loading record %2. This error should be reported to Sybase. %1
Sybase Error Code 20799
Sybase SQL Code –1000139L
You cannot insertt into table ‘%2’ past the original end of the table while there are %3 join virtual tables based on it. %1
Sybase Error Code 20800
Sybase SQL Code –1000140L
You cannot change column ‘%2’ because it is a ‘link’ column. %1

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