Messages on this page are sorted by SQLSTATE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL State | Msg Type | Number | SQL Code | Message | Possible Cause |
|---|---|---|---|---|---|
| QDC89 | Error | 21167 | -1000309L | " Not all partitions in each column are in same dbspace, cannot unpartition %2. %1" | Cannot alter partitioned table to an unpartitioned table as not all partitions in each column are in the same dbspace. Click here for a list of possible parameters and odbc states. |
| QDC90 | Error | 21168 | -1000310L | " Cannot truncate table partition on a non-partitioned table %2. %1" | Cannot truncate table partition on a non-partitioned table. Click here for a list of possible parameters and odbc states. |
| QDC91 | Error | 21169 | -1000311L | " '%2' is not an IQ DBSPACE. %1" | Specified dbspace does not exist or is a catalog dbspace. Click here for a list of possible parameters and odbc states. |
| QDC92 | Error | 21170 | -1000312L | " ALTER INDEX MOVE can not move FP indexes. Command failed for %2. Use ALTER TABLE MOVE COLUMN instead. %1" | ALTER INDEX MOVE command does not move FP indexes. Use ALTER TABLE MOVE COLUMN instead. Click here for a list of possible parameters and odbc states. |
| QDC93 | Error | 21171 | -1000313L | " ALTER INDEX MOVE not allowed on components of a join index. Command failed for %2. %1" | ALTER INDEX MOVE command does not move link indexes. Click here for a list of possible parameters and odbc states. |
| QDC94 | Error | 21173 | -1000314L | " All rows must be in the first partition. %1" | Cannot alter unpartitioned table to a partitioned table as not all rows in the first partition. Click here for a list of possible parameters and odbc states. |
| QDC95 | Error | 21174 | -1000315L | " Cannot drop the last partition of a partitioned table. %1" | Cannot drop the last partition of a partitioned table. Click here for a list of possible parameters and odbc states. |
| QDC96 | Error | 21175 | -1000316L | "The NoExec option is set. The current operation will be rolled back. %1" | Certain operations will not be allowed whenever the NoExec option is set. They are: Alter table Split Partition & Alter Table Partition Click here for a list of possible parameters and odbc states. |
| QDC97 | Error | 21181 | -1000317L | "The current operation is not allowed on RO partition. %1" | Alter table drop/split/merge on a RO partition is not allowed. Click here for a list of possible parameters and odbc states. |
| QDC98 | Error | 21182 | -1000318L | "Unexpected type encountered for column '%2'. %1" | Parse tree contains an expected column type. Click here for a list of possible parameters and odbc states. |
| QDC99 | Error | 21185 | -1000319L | "Server (%2) is no longer a Multiplex coordinator. %1" | Specified server is no longer a Multiplex coordinator. Click here for a list of possible parameters and odbc states. |
| QDD00 | Error | 21189 | -1000320L | "Table with table id %2 no longer exists. %1" | There is no table with the given table id. It would have been dropped. Click here for a list of possible parameters and odbc states. |
| QDD02 | Error | 21198 | -1000329L | "The move target %2 is already in the specified dbspace. %1" | The move target for alter table or alter index is already in the specified dbspace. Click here for a list of possible parameters and odbc states. |
| QDD03 | Error | 21193 | -1000324L | "Maximum secondary node license limit reached. Cannot add new secondary node. %1" | New secondary node cannot be added since the license limit for adding a new secondary node has been reached. Click here for a list of possible parameters and odbc states. |
| QDD04 | Error | 21194 | -1000325L | "%2 node cannot be made a failover node. %1" | An excluded or coordinator node cannot be made a failover node. Click here for a list of possible parameters and odbc states. |
| QDD05 | Error | 21195 | -1000326L | "%2 of Coordinator node cannot be changed. %1" | ROLE or STATUS of Coordinator node cannot be changed. Click here for a list of possible parameters and odbc states. |
| QDD06 | Error | 21196 | -1000327L | "Failover node cannot be Excluded. %1" | A designated failover node cannot be Excluded. Click here for a list of possible parameters and odbc states. |
| QDD07 | Error | 21197 | -1000328L | "%2 node cannot be dropped. %1" | A Coordinator or a Failover node cannot be dropped from the multiplex configuration. Click here for a list of possible parameters and odbc states. |
| QDD08 | Error | 21224 | -1004013L | "Cannot drop multiplex server %2 as it holds freelist. %1" | If a writer holds a freelist, it cannot be dropped. If the writer can be started, start it. This is because a startup or a clean shutdown will clear the freelist. If the writer cannot be restarted, restart the coordinator with -iqmpx_reclaimwriterfreelist <server name> server switch to force the coordinator to reset the writer freelist. Click here for a list of possible parameters and odbc states. |
| QDD09 | Error | 22008 | -1013107L | "MPX: server %2 is not part of the Multiplex configuration. %1" | This is a multiplex and this server is not part of it. Click here for a list of possible parameters and odbc states. |