Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1008026L | Error | 21048 | QNA26 | "Multiplex secondary server out of synchronization with the coordinator. %1" | The secondary server's IQ catalog cannot be brought up to date with the coordinator's IQ catalog. This server must be synchronized. Click here for a list of possible parameters and odbc states. |
| -1008027L | Error | 21057 | QNA28 | "Multiplex secondary node shutting down due to a file added to the IQ_SYSTEM_MAIN dbspace.\nThis node must be synchronized and restarted. %1" | The user has added a dbspace file to IQ_SYSTEM_MAIN on the coordinator. This causes secondary nodes to shut down. All secondary nodes must be synchronized and restarted after this operation. Click here for a list of possible parameters and odbc states. |
| -1008029L | Error | 21059 | QNA29 | "Cannot create foreign key to an unenforced primary key or unenforced unique constraint." | Existing unenforced primary keys or unique constraints cannot be used to create an referential integrity relationship to a foreign table. Click here for a list of possible parameters and odbc states. |
| -1008030L | Error | 21064 | QNA30 | "Only IQ index types can be created on IQ tables within a Parallel IQ block." | Parallel IQ Begin/End blocks allow users to create multiple indexes simultaneously. At this time, only Create Index statements for HG, HNG, LF, LD, DATE, TIME, WD, and CMP index types on IQ tables are allowed within Parallel IQ Begin and End statements. Click here for a list of possible parameters and odbc states. |
| -1008031L | Error | 21065 | QNA31 | "Cannot do Create Index commands on global or local temporary tables or catalog server tables in a Parallel IQ block." | Cannot do Create Index commands on global or local temporary tables in a Parallel IQ block. Click here for a list of possible parameters and odbc states. |
| -1008032L | Error | 20026 | QNA41 | "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. |
| -1008033L | Error | 20027 | QNA42 | "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. |
| -1008034L | Error | 20028 | QNA43 | "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. |
| -1008035L | Error | 20029 | QNA44 | "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. |
| -1008036L | Error | 20642 | QNA45 | "Table %1 already has an Identity/Autoincrement Column. " | An Identity/Autoincrement Column cannot be added to this table because it already has one. Click here for a list of possible parameters and odbc states. |
| -1008037L | Error | 20643 | QNA46 | "Cannot drop %1 %2: set option 'identity_insert' must be off. " | option 'identity insert' must not be set to any table name to drop an Identity Column. To turn it off use 'set identity_insert '' ' Click here for a list of possible parameters and odbc states. |
| -1008038L | Error | 21123 | QNA47 | "create schema command not allowed on an active multiplex server. " | the create schema command is not allowed on an active multiplex server Click here for a list of possible parameters and odbc states. |
| -1008039L | Error | 22005 | QNA48 | "Permission denied: The current multiplex server is not a writer server" | The global command is not permitted on current multiplex node Click here for a list of possible parameters and odbc states. |
| -1009000L | Error | 20021 | QSA00 | "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. |
| -1009001L | Error | 20022 | QSA01 | "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. |
| 1009002L | Warning | 20023 | 00002 | " Index %2: Starting Insert Pass 2. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| 1009003L | Warning | 20024 | 00003 | " Index %1: Thread %2 Inserting %3 Recs, %4 Secs." | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1009004L | Error | 20025 | QSA04 | "Statistics context = %2 %3\n %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1009012L | Error | 20033 | QSA12 | "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. |
| -1009019L | Error | 20040 | QSA19 | "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. |