Troubleshooting Sybase Error Code from Error 20044 to 20058

SQLServerF1

Sybase Error Code 20044
Sybase SQL Code –1009023L
Cannot create a WD index on a column wider than 32767 bytes. %1
Sybase Error Code 20045
Sybase SQL Code –1009024L
Cannot create a WD index with a max permitted word size less than 1 byte. %1
Sybase Error Code 20046
Sybase SQL Code –1009025L
Cannot create a WD index with a max permitted word size greater than 255 bytes. %1
Sybase Error Code 20047
Sybase SQL Code –1009026L
Cannot create a WD index with a separator string this long. %1

Sybase Error Code 20048
Sybase SQL Code –1009027L
Cannot create a WD index with a separator string containing a character fragment. %1
Sybase Error Code 20049
Sybase SQL Code –1009028L
Cannot create a WD index with more than 256 separators. %1
Sybase Error Code 20050
Sybase SQL Code –1009029L
Words exceeding the maximum permitted word length not supported. %1
Sybase Error Code 20051
Sybase SQL Code –1009030L
Cannot create a WD index with the database IQ pagesize less than 4KB. %1
Sybase Error Code 20052
Sybase SQL Code –1009031L
%2: All buffer cache pages are in use, ask your DBA to increase the size of the buffer cache; buffer={%3} page={%4}. %1

Sybase Error Code 20053
Sybase SQL Code –1009032L
%2: Bio ptr must be non-null; buffer={%3} page={%4}. %1
Sybase Error Code 20054
Sybase SQL Code –1009033L
%2: Blocksize must be a multiple of sizeof(hos_mrdtype & hos_uint) and > 0; buffer={%3} page={%4}. %1
Sybase Error Code 20055
Sybase SQL Code –1009034L
%2: The number of blocks must be > 0; buffer={%3} page={%4}. %1
Sybase Error Code 20056
Sybase SQL Code –1009035L
%2: The logical or physical block number must be > 0; buffer={%3} page={%4}. %1
Sybase Error Code 20057
Sybase SQL Code –1009036L
%2: Invalid compression type; buffer={%3} page={%4}. %1
Sybase Error Code 20058
Sybase SQL Code –1009037L
%2: Buffer was not locked when it should have been; buffer={%3} page={%4}. %1

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