Troubleshooting Sybase Error Code from Error 21014 to 21028


Sybase Error Code 21014
Sybase SQL Code –1000244L
The BLOCK FACTOR of unloaded data: %2 does not match the BLOCK FACTOR of the LOAD: %3. %1
Sybase Error Code 21015
Sybase SQL Code –1000245L
Tape / File already loaded. Block number %2 repeats. %1
Sybase Error Code 21016
Sybase SQL Code –1000246L
The number of rows loaded: %3, does not match the number of rows unloaded: %2. %1
Sybase Error Code 21017
Sybase SQL Code –1000247L
The number of blocks loaded: %3, does not match the number of blocks unloaded: %2. %1

Sybase Error Code 21018
Sybase SQL Code –1013097L
Join Index %2 not unique. %1
Sybase Error Code 21019
Sybase SQL Code –1013099L
Join Indexes do not support the multipart foreign key found in table %2. %1
Sybase Error Code 21020
Sybase SQL Code –1013100L
The ON keyword cannot be used in a NATURAL join. %1
Sybase Error Code 21021
Sybase SQL Code –1013101L
You do not have permission to drop this join index. %1
Sybase Error Code 21022
Sybase SQL Code –1013102L
User name ‘%2’ does not exist. %1

Sybase Error Code 21023
Sybase SQL Code –1009134L
Insufficient buffers for sort. %1
Sybase Error Code 21024
Sybase SQL Code 1010013L
IQ cannot support the %1 connections requested by the server.\nRestart the server with -gm %2 on the command line.
Sybase Error Code 21025
Sybase SQL Code –1010013L
Raw partition %2 is already in use. %1
Sybase Error Code 21026
Sybase SQL Code 1013103L
JI MATCH E=%1;S=%2;TID=%3;NRows=%4;JID=%5;NTab=%6;Miss=%7;Data=%8
Sybase Error Code 21027
Sybase SQL Code 1013104L
JI NOMATCH – Entry=%1, Table=%2, Join=%3
Sybase Error Code 21028
Sybase SQL Code 1013105L
JI MATCH COMPARING – E=%1, MP=%2, JID=%3, Name=%4

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