Messages on this page are sorted by Sybase error code. Locate the appropriate code in the table below, and click the link for a full description of the message.
| Number | Msg Type | SQL State | SQL Code | Message | Possible Cause |
|---|---|---|---|---|---|
| 20021 | Error | QSA00 | -1009000L | "Bit %2 is unexpectedly on in bitmap. If the error persists, you may have a damaged index; please run sp_iqcheckdb. %1" | This is either an internal calling error (some component called bitmap SET with a duplicate bit), a corrupt bitmap (and dbcc needs be run), or a bitmap operator that has gone awry and mis-computed a result. Click here for a list of possible parameters and odbc states. |
| 20022 | Error | QSA01 | -1009001L | "Bit %2 is unexpectedly off in bitmap. If the error persists, you may have a damaged index; please run sp_iqcheckdb. %1" | This is either an internal calling error (some component called bitmap CLEAR with a duplicate bit), a corrupt bitmap (and dbcc needs be run), or a bitmap operator that has gone awry and mis-computed a result. Click here for a list of possible parameters and odbc states. |
| 20023 | Warning | 00002 | 1009002L | " Index %2: Starting Insert Pass 2. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 20024 | Warning | 00003 | 1009003L | " Index %1: Thread %2 Inserting %3 Recs, %4 Secs." | No additional information available. Click here for a list of possible parameters and odbc states. |
| 20025 | Error | QSA04 | -1009004L | "Statistics context = %2 %3\n %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 20026 | Error | QNA41 | -1008032L | "Foreign keys disallowed on Identity/Autoincrement Columns when set option identity_enforce_uniqueness is on" | An Identity/Autoincrement Column cannot be a foreign key when the set option identity_enforce_uniqueness is on. Either turn the option off, or chose a different column for the foreign key. Click here for a list of possible parameters and odbc states. |
| 20027 | Error | QNA42 | -1008033L | "Identity/Autoincrement Column %1 has Invalid datatype: scale must be 0." | Identity/Autoincrement Columns defined as datatype numeric must have scale 0 Click here for a list of possible parameters and odbc states. |
| 20028 | Error | QNA43 | -1008034L | "Cannot add an Identity/Autoincrement Column to table %1, it participates in a join index." | Adding an Identity/Autoincrement Column to a table that participates in a join index is not allowed, to perform this operation, the join index must be dropped Click here for a list of possible parameters and odbc states. |
| 20029 | Error | QNA44 | -1008035L | "Invalid datatype for Identity/Autoincrement Column %1." | The datatype used is not supported by Identity/Autoincrement column. Valid datatypes are bigint, unsigned bigint, integer, unsigned integer, smallint, tinyint, numeric scale 0 and decimal scale 0 Click here for a list of possible parameters and odbc states. |
| 20030 | Error | QDC65 | -1000283L | "Identity/Autoincrement Column value range exceeded for column %2. %1" | Data overflow: An Identity/Autoincrement Column has reached its maximum value. To correct this create a new table in which the datatype of the new Identity/Autoincrement Column is larger and copy this table into the new table. Alternatively add a new Identity/Autoincrement Column to the table with a larger datatype and delete the old one. Click here for a list of possible parameters and odbc states. |
| 20032 | Error | QDC66 | -1000284L | "Identity/Autoincrement Column value for column %2 must be positive. %1" | All values in Identity/Autoincrement Columns must be positive. To correct this, only use positive values when manually inserting into Identity/Autoincrement Columns. Click here for a list of possible parameters and odbc states. |
| 20033 | Error | QSA12 | -1009012L | "Cannot create %2 index on a column having a datatype %3. %1" | A named index type index cannot be created on named datatype Click here for a list of possible parameters and odbc states. |
| 20034 | Error | QDC67 | -1000285L | "The value specified for the Identity/Autoincrement Column %2 exceeds the range of its datatype. %1" | The value specified does not fit in the Identity/Autoincrement Column. To correct this, choose a smaller value Click here for a list of possible parameters and odbc states. |
| 20035 | Error | QDC68 | -1000286L | "Invalid table argument %2 to sp_iq_reset_identity, Table has no Identity/Autoincrement Column. %1" | Table's without Identity/Autoincrement Columns cannot be used in calls to stored procedure sp_iq_reset_identity. Click here for a list of possible parameters and odbc states. |
| 20036 | Error | QDC69 | -1000287L | "Invalid table argument %2 to sp_iq_reset_identity, Table cannot be a JVT. %1" | Tables of type JVT are not allowed as arguments to the stored procedure sp_iq_reset_identity Click here for a list of possible parameters and odbc states. |
| 20037 | Error | QDC70 | -1000288L | "Invalid table argument %2 for set option 'identity_insert', Table cannot be a JVT. %1" | Tables of type JVT are not allowed as a value for the set option 'identity_insert' Click here for a list of possible parameters and odbc states. |
| 20038 | Error | QDC71 | -1000289L | "Invalid table argument %2 for set option 'identity_insert', Table must be an IQ table. %1" | Only IQ tables are allowed as an argument value to the set option 'identity_insert' Click here for a list of possible parameters and odbc states. |
| 20039 | Error | QDC72 | -1000290L | "Invalid table argument %2 for stored procedure sp_iq_reset_identity, Table must be an IQ Table. %1" | Only IQ tables are allowed as a table argument to the stored procedure sp_iq_reset_identity Click here for a list of possible parameters and odbc states. |
| 20040 | Error | QSA19 | -1009019L | "An internal server component, a bitmap, was given invalid input. %1" | Some non-bitmap component has called a bitmap with an illegal argument. This is an internal programming error and not the (direct) result of customer error. Click here for a list of possible parameters and odbc states. |
| 20041 | Error | QDC73 | -1000291L | "You do not have insert permission on table %2. %1" | You cannot set the option 'identity_insert' to a table for which you do not have insert permission Click here for a list of possible parameters and odbc states. |