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 |
|---|---|---|---|---|---|
| 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. |
| QDD10 | Error | 22009 | -1013108L | "MPX: startup failure message: server '%2' was started on an incorrect host '%3': this server was created with this connection string '%4'. %1" | This server cannot be started on this host Click here for a list of possible parameters and odbc states. |
| QDD11 | Error | 22010 | -1013109L | "MPX: coordinator has been started with an incorrect catalog. %1" | The coordinator has been started with an incorrect catalog Click here for a list of possible parameters and odbc states. |
| QDD116 | Error | 22015 | -1013112L | "MPX: Striping parameters for IQ_SYSTEM_TEMP are global and may only be altered on the coordinator node. %1" | Change striping for IQ_SYSTEM_TEMP on coordinator only. Click here for a list of possible parameters and odbc states. |
| QDD12 | Error | 22011 | -1013110L | "MPX: server %2 has been started with an incorrect catalog path (expected path: %3). %1" | The coordinator has been started with the incorrect catalog Click here for a list of possible parameters and odbc states. |
| QDD13 | Error | 22012 | -1013104L | "This operation is not allowed on the dbspace IQ_SYSTEM_TEMP. %1" | Illegal op for iq_system_temp Click here for a list of possible parameters and odbc states. |
| QDD14 | Error | 22013 | -1013105L | "Use ALTER DBSPACE ALTER FILE for this operation. %1" | Must use alter dbspace alter file Click here for a list of possible parameters and odbc states. |
| QDD15 | Error | 22014 | -1013111L | "MPX: This operation is not supported on a MPX secondary node. %1" | Not supported on a mpx secondary node Click here for a list of possible parameters and odbc states. |
| QDD17 | Error | 21199 | -1000330L | "Default value %2 cannot be used as a LOAD default value. %1" | Specified default value cannot be used as a LOAD default value. Click here for a list of possible parameters and odbc states. |
| QDD18 | Error | 22018 | -1013115L | "IQ Internal multiplex error. Please report this to Sybase IQ support. %1" | A fatal programming error encountered, server will be aborted. Click here for a list of possible parameters and odbc states. |
| QDD19 | Error | 21204 | -1000331L | "The requested FP style (%1) for %2 cannot be rebuilt. It will be rebuilt as %3." | The requested FP style cannot be rebuilt. Increase main cache or set FP_Lookup_Size_PPM to a higher percentage for 3-byte FP. Click here for a list of possible parameters and odbc states. |
| QDD1A | Error | 22019 | -1009188L | "Create shared temporary dbspace not allowed. %1" | Additional dbspaces may not be created in shared temp store. Shared Temp space may only be added to IQ_SHARED_TEMP. Click here for a list of possible parameters and odbc states. |
| QDD20 | Error | 21206 | -1000332L | "Odd length of binary data value detected on column %2 - %1" | When loading hexadicimal data into BLOB, the total number of nibbles has to be an even number. If an odd number is detected, the load engine will rollback. This restriction does not apply to binary and varbinary data type. Click here for a list of possible parameters and odbc states. |
| QDD21 | Error | 22020 | -1013116L | "The operation has been cancelled - Mpx_Work_Unit_Timeout exceeded. %2 %1" | The elapsed time to complete a distributed work unit exceed the timeout value. Click here for a list of possible parameters and odbc states. |
| QDD22 | Error | 22021 | -1000333L | "DBCC IQ_SHARED_TEMP dbspace target not allowed with other targets. %1" | When specifying the IQ_SHARED_TEMP dbspace as a DBCC mode target, no other targets may be specified. Click here for a list of possible parameters and odbc states. |