Troubleshooting Sybase Error Code from Error 20832 to 20846

SQLServerF1

Sybase Error Code 20832
Sybase SQL Code 1000172L
Insert Pass %1 (%2 of %3) started.
Sybase Error Code 20833
Sybase SQL Code –1000173L
Index ‘%1’ cannot be created. Multicolumn indexes must be created using distinct columns.
Sybase Error Code 20834
Sybase SQL Code 1000174L
\n\t%1 records were inserted into ‘%2’.\n
Sybase Error Code 20835
Sybase SQL Code 1000175L
%1 records were inserted into %2 join virtual tables (%3 sections)\n for ‘%4’.\n

Sybase Error Code 20836
Sybase SQL Code –1000176L
Cannot perform foreign key create/alter operation because one is already in progress. %1
Sybase Error Code 20837
Sybase SQL Code 1000177L
Only the catalog entry for the ‘%1’ index was created, no data was available to populate the index.
Sybase Error Code 20838
Sybase SQL Code –1000178L
The DATA parameter must have a non-NULL value. %1
Sybase Error Code 20839
Sybase SQL Code –1000179L
The column length (%2) must be [if variable sized, between 0 and] %3. %1
Sybase Error Code 20840
Sybase SQL Code –1000180L
The maximum column length (%2) must be between 0 and %3. %1

Sybase Error Code 20841
Sybase SQL Code –1000181L
The maximum column length (%2) is less than the actual length (%3). %1
Sybase Error Code 20842
Sybase SQL Code –1000182L
Table %2 cannot be opened because it is currently involved in a foreign key create/alter operation. %1
Sybase Error Code 20843
Sybase SQL Code –1000183L
Attempt to insert data into column ‘%2’ with a non-insertable datatype (%3) ignored. %1
Sybase Error Code 20844
Sybase SQL Code –1000184L
When inserting into join index ‘%2’, the START ROW ID (%3) must 0 or 1. %1
Sybase Error Code 20845
Sybase SQL Code –1000185L
Cannot dropp table %1 because foreign keys still reference it.
Sybase Error Code 20846
Sybase SQL Code –1000186L
Cannot create foreign key constraint on a candidate key that is also a foreign key.

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