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 |
|---|---|---|---|---|---|
| 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. |
| QDD23 | Error | 22022 | -1000334L | "Unsupported DBCC dbspace target \"%2\". %1" | DBCC Does not support checking modes on this dbspace target. Click here for a list of possible parameters and odbc states. |
| QDD24 | Error | 22024 | -1013117L | "Worker rejected query fragment - %2. %1" | Worker node could not execute the query fragment for the specified reason. Click here for a list of possible parameters and odbc states. |
| QDD25 | Error | 21214 | -1000335L | "Cannot add writer when coordinator started with -iqmpx_nowr %1" | Please restart coordinator without -iqmpx_nowr switch to add writer node Click here for a list of possible parameters and odbc states. |
| QDD26 | Error | 21215 | -1000336L | "Cannot convert to writer when coordinator started with -iqmpx_nowr %1" | Please restart coordinator without -iqmpx_nowr switch to change role to writer Click here for a list of possible parameters and odbc states. |
| QDD27 | Error | 21216 | -1000337L | " Number of columns in Hash Partition key cannot be greater than %2. %1" | Hash partition key columns cannot be greater than the allowed value. Click here for a list of possible parameters and odbc states. |
| QFA00 | Error | 20509 | -1001000L | "DFE Sum or Average overflow - try CASTing the argument to a larger datatype. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QFA01 | Error | 20510 | -1001001L | "DFE Typechecking error %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QFA02 | Error | 20511 | -1001002L | "Feature is not yet implemented %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QFA03 | Error | 20512 | -1001003L | "Internal error: subclass responsibility %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QFA04 | Error | 20513 | -1001004L | "Data exception - substring error. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QFA05 | Error | 20514 | -1001005L | "Data exception - string length error. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QFA06 | Error | 20515 | -1001006L | "Data exception - data type conversion is not possible. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QFA07 | Error | 20516 | -1001007L | "Data exception - operation resulted in division by zero. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QFA08 | Error | 20517 | -1001008L | "Data exception - invalid character data for cast. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QFA09 | Error | 20518 | -1001009L | "Data exception - string data, right truncation. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |