Troubleshooting Sybase Error Code from Error 20771 to 20785

SQLServerF1

Sybase Error Code 20771
Sybase SQL Code –1000111L
The wrong FP Index has been opened for a field. %1
Sybase Error Code 20772
Sybase SQL Code –1000112L
The EBM on the field’s columnDescriptor does not match the column EBM on the FPIndex. %1
Sybase Error Code 20773
Sybase SQL Code –1000113L
Field %2 does not have an FP index. %1
Sybase Error Code 20774
Sybase SQL Code –1000114L
CMP index can only be created on two distinct columns having identical datatypes. %1

Sybase Error Code 20775
Sybase SQL Code –1000115L
You cannot delete from join index %2 in the ‘top’ table %3. %1
Sybase Error Code 20776
Sybase SQL Code –1000116L
A temporary table cannot participate in a JOIN INDEX. ‘%2’ is a temporary table. %1
Sybase Error Code 20777
Sybase SQL Code 1000117L
The data to be inserted into table ‘%2’, column ‘%1’ cannot be converted to the datatype of the column. NULL will be inserted if the column allows NULLs.
Sybase Error Code 20778
Sybase SQL Code –1000118L
Join index %2 was not found in the catalog. %1
Sybase Error Code 20779
Sybase SQL Code 1000119L
The data to be inserted into table ‘%2′, column `%1’ from row %3 of the select results cannot be converted to the datatype of the destination column. NULL

will be inserted if the column allows NULLs.
Sybase Error Code 20780
Sybase SQL Code –1000120L
Join %2 was not found in the catalog. %1
Sybase Error Code 20781
Sybase SQL Code –1000121L
binary data not supported on data longer than 32767 %2, %1
Sybase Error Code 20782
Sybase SQL Code 1000122L
The data to update table ‘%2′, column `%1’ cannot be converted to the datatype of the destination column for update number %3 to the table. NULL will be inserted if the column allows NULLs.
Sybase Error Code 20783
Sybase SQL Code –1000123L
Index ‘%2’ cannot be created. Multicolumn indexes must be created using distinct columns. %1
Sybase Error Code 20784
Sybase SQL Code –1000124L
Function or Operator not supported on data longer than %2 bytes. %1
Sybase Error Code 20785
Sybase SQL Code –1000125L
Table %2 is not part of join index %3. %1

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