Troubleshooting Sybase Error Code from Error 20471 to 20486

SQLServerF1

Sybase Error Code 20471
Sybase SQL Code –1006233L
CONSTRAINT exception: OS error %2: pathname len is %3, your buffer size is %4. Pathname is %5 %1
Sybase Error Code 20472
Sybase SQL Code –1006234L
The IQ SET command has no option named ‘%2’ %1
Sybase Error Code 20473
Sybase SQL Code –1006235L
The IQ SET SERVERDEFAULT command requires the SA_ROLE %1
Sybase Error Code 20474
Sybase SQL Code –1000292L
Invalid use of set option ‘identity insert’. Table %2 does not have an Identity/Autoincrement Column. %1

Sybase Error Code 20475
Sybase SQL Code –1006237L
The IQ SET option, ‘%2’, can not be set server-wide %1
Sybase Error Code 20476
Sybase SQL Code –1006238L
The IQ SET option, ‘%2’, can only be set server-wide and not for a session %1
Sybase Error Code 20477
Sybase SQL Code –1006239L
The IQ SET option, ‘%2’, can only be changed by users with SA_ROLE or DBO_ROLE %1
Sybase Error Code 20478
Sybase SQL Code –1006240L
The value, %2, is not valid for the SQL Anywhere option, ‘%3’ %1
Sybase Error Code 20479
Sybase SQL Code –1006241L
The value, %2, is not valid for the integer option, ‘%3’ %1

Sybase Error Code 20480
Sybase SQL Code –1006242L
The value, %2, is not valid for the unsigned integer option, ‘%3’ %1
Sybase Error Code 20481
Sybase SQL Code –1006243L
The value, %2, is not valid for the Boolean option, ‘%3’ %1
Sybase Error Code 20482
Sybase SQL Code –1006244L
The value, %2, is not valid for the unsigned 64bit integer option, ‘%3’ %1
Sybase Error Code 20483
Sybase SQL Code –1006245L
The value, %2, is not valid for the string option, ‘%3’ %1
Sybase Error Code 20485
Sybase SQL Code –1006247L
shared segment: os error
Sybase Error Code 20486
Sybase SQL Code –1006248L
shared segment: virtual addr does not match

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