Troubleshooting Sybase Error Code from Error 20663 to 20677

SQLServerF1

Sybase Error Code 20663
Sybase SQL Code –1000003L
Cross-database joins are not supported. (%2 and %3) %1
Sybase Error Code 20664
Sybase SQL Code –1000004L
Index ‘%2’ already exists in the catalog. %1
Sybase Error Code 20665
Sybase SQL Code –1000005L
Join index ‘%2’ already exists and has the same join fields as proposed join index ‘%3’. %1
Sybase Error Code 20666
Sybase SQL Code –1000006L
Only %2 NULL specifications on a column are permitted. %1

Sybase Error Code 20667
Sybase SQL Code –1000007L
Index ‘%2’ was not closed properly. %1
Sybase Error Code 20668
Sybase SQL Code –1000008L
Unknown error. %1
Sybase Error Code 20669
Sybase SQL Code –1000009L
Cannot DISABLE index ‘%2’. It is open Read/Write and may have updates pending. %1
Sybase Error Code 20670
Sybase SQL Code –1000010L
Cannot DISABLE index ‘%2’. The index is in use. %1

Sybase Error Code 20671
Sybase SQL Code –1000011L
Transaction %2 attempted to access an object created by transaction %3. %1
Sybase Error Code 20672
Sybase SQL Code –1000012L
Index ‘%2’ cannot be closed because it has %3 users. %1
Sybase Error Code 20673
Sybase SQL Code –1008004L
Cannot DROP index ‘%1’.
Sybase Error Code 20674
Sybase SQL Code –1000014L
%2 MB is not sufficient for the load, update, or delete. %1
Sybase Error Code 20675
Sybase SQL Code –1008005L
Cannot ALTER join virtual table ‘%1’.
Sybase Error Code 20676
Sybase SQL Code –1008006L
You cannot specify a DEFAULT value for a column.
Sybase Error Code 20677
Sybase SQL Code –1008007L
The ALTERR TABLE option ‘%2’ is not supported by Sybase IQ. %1

Above are list of Sybase Error Code Messages from Error Code 20663 to 20677 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.

Thanks,
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 *