Troubleshooting Sybase Error Code from Error 20801 to 20815


Sybase Error Code 20801
Sybase SQL Code –1000141L
Column ‘%2’ must be included in the LOAD since it is used in a join. %1
Sybase Error Code 20802
Sybase SQL Code 1000142L
Insertt into ‘%1’, \n%2 Inners added, %3 Left Outers converted to Inners, %4 Right Outers added.
Sybase Error Code 20803
Sybase SQL Code –1000143L
While inserting, table ‘%2’ must be Complete(d) before it can be (re)Prepare(d). %1
Sybase Error Code 20804
Sybase SQL Code –1000144L
Cannot insertt into table ‘%2’. Column %3 does not have a name. %1

Sybase Error Code 20805
Sybase SQL Code –1000145L
The insert for table ‘%2’ has no insertable columns in the column list. %1
Sybase Error Code 20806
Sybase SQL Code –1000146L
Cannot get the index buffer for the column ‘%2’. %1
Sybase Error Code 20807
Sybase SQL Code –1000147L
Table ‘%2’ must be Prepare(d) before inserting. %1
Sybase Error Code 20808
Sybase SQL Code –1000148L
The table being inserted to does not have a name. %1
Sybase Error Code 20809
Sybase SQL Code –1000149L
Unable to open table ‘%2’ with Read/Write access for insert. %1

Sybase Error Code 20810
Sybase SQL Code –1000150L
Cannot insertt into the table. Column ‘%2’ has no index. %1
Sybase Error Code 20811
Sybase SQL Code –1000151L
NOT NULL column ‘%2’ was not included in this insert. Data is needed at row %3. %1
Sybase Error Code 20812
Sybase SQL Code –1000152L
The NOT NULL column ‘%2’ was not included in this insert. %1
Sybase Error Code 20813
Sybase SQL Code –1000153L
Table ‘%2’, pass-x index count mismatch (%3/%4). %1
Sybase Error Code 20814
Sybase SQL Code –1000154L
While inserting into table ‘%2’, the record number recycled (%3). %1
Sybase Error Code 20815
Sybase SQL Code –1000155L
The attempted insert length (%3) for column %2 is longer than the maximum allowed (%4). %1

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