Troubleshooting Sybase Error Code from Error 21029 to 21043


Sybase Error Code 21029
Sybase SQL Code 1013106L
JI MATCH SELECTED – MP=%1, JID=%2, Name=%3
Sybase Error Code 21030
Sybase SQL Code 1013107L
JI MATCH EXACT – This join exactly matches the requested tree
Sybase Error Code 21031
Sybase SQL Code 1013108L
JI MATCH – Building Match List for Table ID=%1, Name=%2
Sybase Error Code 21032
Sybase SQL Code 1013109L
JI MATCH – Join Index ID=%1, Name=%2, TopTableID=%3

Sybase Error Code 21033
Sybase SQL Code 1013110L
IQ had insufficient memory to create the buffer cache with the size specified with the Main_Cache_Memory_MB or Temp_Cache_Memory_MB options. Instead, the cache will be created using the default size.
Sybase Error Code 21034
Sybase SQL Code –1009135L
Cannot perform requested command as there is a CREATE DBSPACE command in progress. %1
Sybase Error Code 21035
Sybase SQL Code –1009136L
Cannot perform requested command as there is a DROP DBSPACE command in progress. %1
Sybase Error Code 21036
Sybase SQL Code –1009137L
Cannot perform DDL command now on table %2 as a DDL command is already in progress on that table. %1

Sybase Error Code 21037
Sybase SQL Code –1009138L
Join index ‘%2’ is in use. %1
Sybase Error Code 21038
Sybase SQL Code –1009139L
Cannot perform requested command as there is a CHECKPOINT command in progress. %1
Sybase Error Code 21039
Sybase SQL Code –1009140L
Cannot restore dbspace ‘%2’ to raw partition ‘%3’ because its size is smaller than the size of the original raw partition (%4 vs. %5 blocks). %1
Sybase Error Code 21040
Sybase SQL Code –1008018L
Command prohibited on an active multiplex server.
Sybase Error Code 21041
Sybase SQL Code –1008019L
Multiplex is currently inactive.
Sybase Error Code 21042
Sybase SQL Code –1008020L
Multiplex command or request is unimplemented.
Sybase Error Code 21043
Sybase SQL Code –1008021L
The SYSIQFILE table is not configured for this server to run in a multiplex.

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