Troubleshooting Sybase Error Code from Error 20816 to 20831


Sybase Error Code 20816
Sybase SQL Code –1000156L
Tried to insertt into too many (%2) LOW FAST indexes at one time in table ‘%3’. %1
Sybase Error Code 20817
Sybase SQL Code –1000157L
Columns for the index must be in ascending sort order. %1
Sybase Error Code 20818
Sybase SQL Code –1000158L
An Identity size mismatch has occurred. The current transaction will rollback. %1
Sybase Error Code 20819
Sybase SQL Code 1000159L
\nIn table ‘%1’, the %2 width insert of %3 columns will begin at record %4.

Sybase Error Code 20821
Sybase SQL Code 1000161L
You have %1 and %2 available, respectively.
Sybase Error Code 20822
Sybase SQL Code –1000162L
Unable to create the requested object. %1
Sybase Error Code 20823
Sybase SQL Code –1000163L
%1 not supported.
Sybase Error Code 20824
Sybase SQL Code –1000164L
Only %1 supported.
Sybase Error Code 20825
Sybase SQL Code –1000165L
Only a single foreign key constraint can be created on the same foreign key column(s) and same candidate key column(s).

Sybase Error Code 20826
Sybase SQL Code –1000166L
Cannot specify IGNORE CONSTRAINT ALL or DATA VALUE when option CONVERSION_ERROR is on. %1
Sybase Error Code 20827
Sybase SQL Code –1000167L
Cannot %3 table %2 because of RI concurrency conflict. %1
Sybase Error Code 20828
Sybase SQL Code –1000168L
Cannot create %1 HG index because one already exists on the given columns.
Sybase Error Code 20829
Sybase SQL Code –1000169L
Cannot create unique HG index because primary key or unique constraint already exists on the given columns.
Sybase Error Code 20830
Sybase SQL Code –1000170L
Cannot create a duplicate ‘%1’ index ‘%2’.
Sybase Error Code 20831
Sybase SQL Code 1000171L
Insert Pass IP2.2 started.

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