Troubleshooting Sybase Error Code from Error 21044 to 21064


Sybase Error Code 21044
Sybase SQL Code –1008022L
Database commit identity block corrupt
Sybase Error Code 21045
Sybase SQL Code –1008023L
Cannot start multiplex query server while the write server is in single server mode
Sybase Error Code 21046
Sybase SQL Code –1008024L
Multiplex write server must start as server@host: %2, on file: %3; to start with different settings, you must use the override switch. %1
Sybase Error Code 21047
Sybase SQL Code –1008025L
Multiplex query server cannot continue while write server is in single server mode.

Sybase Error Code 21048
Sybase SQL Code –1008026L
Multiplex query server out of synchronization with write server
Sybase Error Code 21049
Sybase SQL Code –1009148L
Cannot use -iqfrec or -iqdroplks to start a multiplex query server with no local store. %1
Sybase Error Code 21050
Sybase SQL Code –1009412L
The INSERT … LOCATION statement must use a SELECT statement. %1
Sybase Error Code 21057
Sybase SQL Code –1008027L
Query server dbspace count differs from write server.
Sybase Error Code 21058
Sybase SQL Code 1010014L
Default cache size is used for command %1.

Sybase Error Code 21059
Sybase SQL Code –1008029L
Cannot create foreign key to an unenforced primary key or unenforced unique constraint.
Sybase Error Code 21060
Sybase SQL Code –1005019L
The update FROM list must match the table-clause exactly
Sybase Error Code 21061
Sybase SQL Code –1009141L
Table ‘%2’ cannot be found in the IQ store. %1
Sybase Error Code 21062
Sybase SQL Code –1005020L
Only single-table updates are supported by Sybase IQ
Sybase Error Code 21063
Sybase SQL Code –1005021L
Sybase IQ does not allow subqueries in update set-items
Sybase Error Code 21064
Sybase SQL Code –1008030L
Only IQ index types can be created on IQ tables within a Parallel IQ block.

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