Troubleshooting Sybase Error Code from Error 20143 to 20157

SQLServerF1

Sybase Error Code 20143
Sybase SQL Code 1009122L
%1 Sort: Merged %2 runs, %3 Secs, %4 runs remaining
Sybase Error Code 20144
Sybase SQL Code –1009123L
Database Segment %2 is not valid. Missing DBSignature. This Segment can not be used. %1
Sybase Error Code 20145
Sybase SQL Code –1009124L
Database Segment %2, blocksize %3 does not match catalog blocksize of %4. This Segment can not be used. %1
Sybase Error Code 20146
Sybase SQL Code –1009125L
Database Segment %2, maxcompression %3 does not match catalog maxcompression of %4. This Segment can not be used. %1

Sybase Error Code 20147
Sybase SQL Code –1009126L
Database Segment %2, createtime does not match catalog. This Segment can not be used. %1
Sybase Error Code 20148
Sybase SQL Code –1009127L
Database Segment %2, %3 size does not match catalog size of %4. This Segment can not be used. %1
Sybase Error Code 20149
Sybase SQL Code –1009128L
Tried to allocate indexspace blocks without a freelist. %1
Sybase Error Code 20150
Sybase SQL Code –1009129L
Database Segment %2, query server can not find a valid header. This segment can not be used. %1
Sybase Error Code 20151
Sybase SQL Code –1009130L
Database %2, does not have a segment for catalogfileid %3. %1

Sybase Error Code 20152
Sybase SQL Code 1009131L
You have run out of %1 dbspace in database %2. In another session, please issue a CREATE DBSPACE … %3 command and add a dbspace of at least %4 MB.
Sybase Error Code 20153
Sybase SQL Code 1009132L
The DBA has added %1 %2 dbspaces to database %3. Sybase IQ (TM) is no longer waiting for more dbspace.
Sybase Error Code 20154
Sybase SQL Code –1005000L
Bind parameters are not supported in data flow query processing
Sybase Error Code 20155
Sybase SQL Code –1005001L
Query has exceeded the supported maximum number of tables that can be joined. %1
Sybase Error Code 20156
Sybase SQL Code –1005002L
Subquery predicates are not supported in the ON clause of outer joins in this release. %1
Sybase Error Code 20157
Sybase SQL Code –1005003L
A maximum of one subquery predicate per conjunct is supported in this release. %1

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