Troubleshooting Sybase Error Code from Error 20027 to 20043

SQLServerF1

Sybase Error Code 20027
Sybase SQL Code –1008033L
Identity/Autoincrement Column %1 has Invalid datatype: scale must be 0.
Sybase Error Code 20028
Sybase SQL Code –1008034L
Cannot add an Identity/Autoincrement Column to table %1, it participates in a join index.
Sybase Error Code 20029
Sybase SQL Code –1008035L
Invalid datatype for Identity/Autoincrement Column %1.
Sybase Error Code 20030
Sybase SQL Code –1000283L
Identity/Autoincrement Column value range exceeded for column %2. %1

Sybase Error Code 20032
Sybase SQL Code –1000284L
Identity/Autoincrement Column value for column %2 must be positive. %1
Sybase Error Code 20033
Sybase SQL Code –1009012L
Cannot create %2 index on a column having a datatype %3. %1
Sybase Error Code 20034
Sybase SQL Code –1000285L
The value specified for the Identity/Autoincrement Column %2 exceeds the range of its datatype. %1
Sybase Error Code 20035
Sybase SQL Code –1000286L
Invalid table argument %2 to sp_iq_reset_identity, Table has no Identity/Autoincrement Column. %1
Sybase Error Code 20036
Sybase SQL Code –1000287L
Invalid table argument %2 to sp_iq_reset_identity, Table cannot be a JVT. %1

Sybase Error Code 20037
Sybase SQL Code –1000288L
Invalid table argument %2 for set option ‘identity_insert’, Table cannot be a JVT. %1
Sybase Error Code 20038
Sybase SQL Code –1000289L
Invalid table argument %2 for set option ‘identity_insert’, Table must be an IQ table. %1
Sybase Error Code 20039
Sybase SQL Code –1000290L
Invalid table argument %2 for stored procedure sp_iq_reset_identity, Table must be an IQ Table. %1
Sybase Error Code 20040
Sybase SQL Code –1009019L
An internal server component, a bitmap, was given invalid input. %1
Sybase Error Code 20041
Sybase SQL Code –1000291L
You do not have insert permission on table %2. %1
Sybase Error Code 20043
Sybase SQL Code –1009022L
Cannot create a WD index on a column narrower than 3 bytes. %1

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