Troubleshooting Sybase Error Code from Error 20678 to 20692


Sybase Error Code 20678
Sybase SQL Code –1000018L
The object cannot be opened for DROP or ALTER. It is already open. %1
Sybase Error Code 20679
Sybase SQL Code –1008008L
You cannot TRUNCATE a join virtual table.
Sybase Error Code 20680
Sybase SQL Code –1008009L
This statement is not supported by Sybase IQ.
Sybase Error Code 20681
Sybase SQL Code –1008010L
A request was made to delete the primary key constraint, but the primary key cannot be found.

Sybase Error Code 20682
Sybase SQL Code –1000022L
Index ‘%2’ has an invalid index type: %3. %1
Sybase Error Code 20683
Sybase SQL Code –1000023L
The proposed join does not form a clearly connected list. (table ‘%2’) %1
Sybase Error Code 20684
Sybase SQL Code –1000024L
For table pair %2, table ‘%3’ has a datatype mismatch for column %4. %1
Sybase Error Code 20685
Sybase SQL Code –1008011L
Cannot create the join index because the datatype of the underlying join virtual table column is not equal to the datatype of the corresponding base table column ‘%1’.

Sybase Error Code 20686
Sybase SQL Code –1000026L
The join virtual table for table ‘%2’ has duplicate columns in positions %3 and %4. %1
Sybase Error Code 20687
Sybase SQL Code –1000027L
The join virtual table ‘%2’ does not have any data. %1
Sybase Error Code 20688
Sybase SQL Code –1000028L
For table pair %2, table ‘%3’ has a length value mismatch for column %4. %1
Sybase Error Code 20689
Sybase SQL Code –1000029L
Cannot open the requested object for write in the current transaction (%2). Another user has write access in transaction %3. %1
Sybase Error Code 20690
Sybase SQL Code 1000030L
\nMaster archive header information\n
Sybase Error Code 20691
Sybase SQL Code 1000031L
Join Index ‘%1’ created from the following join relations:
Sybase Error Code 20692
Sybase SQL Code 1000032L
The ultimate/top table is %1\n

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