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 |
|---|---|---|---|---|---|
| QCB01 | Error | 21021 | -1013101L | "You do not have permission to drop this join index. %1" | You do not have permission to drop this join index. Click here for a list of possible parameters and odbc states. |
| QCB02 | Error | 21022 | -1013102L | "User name '%2' does not exist. %1" | The specified user does not exist. Click here for a list of possible parameters and odbc states. |
| QCB03 | Warning | 21026 | 1013103L | "JI MATCH E=%1;S=%2;TID=%3;NRows=%4;JID=%5;NTab=%6;Miss=%7;Data=%8" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays the scoring given to each table/join index matched. Click here for a list of possible parameters and odbc states. |
| QCB04 | Warning | 21027 | 1013104L | "JI NOMATCH - Entry=%1, Table=%2, Join=%3" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join has not been selected. Click here for a list of possible parameters and odbc states. |
| QCB05 | Warning | 21028 | 1013105L | "JI MATCH COMPARING - E=%1, MP=%2, JID=%3, Name=%4" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join is being compared to the others. Click here for a list of possible parameters and odbc states. |
| QCB06 | Warning | 21029 | 1013106L | "JI MATCH SELECTED - MP=%1, JID=%2, Name=%3" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join has been selected. Click here for a list of possible parameters and odbc states. |
| QCB07 | Warning | 21030 | 1013107L | "JI MATCH EXACT - This join exactly matches the requested tree" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join completely replaces the requested tree. Click here for a list of possible parameters and odbc states. |
| QCB08 | Warning | 21031 | 1013108L | "JI MATCH - Building Match List for Table ID=%1, Name=%2" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this table will be queried for joins that it participates. Click here for a list of possible parameters and odbc states. |
| QCB09 | Warning | 21032 | 1013109L | "JI MATCH - Join Index ID=%1, Name=%2, TopTableID=%3" | During a SELECT the Join Indexs are searched for a good match to increase the speed of the query. This message relays that this join will attempt to be matched during the match-up process. Click here for a list of possible parameters and odbc states. |
| QCB10 | Error | 21050 | -1009412L | "The INSERT ... LOCATION statement must use a SELECT statement. %1" | The INSERT ... LOCATION statement must use a SELECT statement. No other SQL statement is supported here. Click here for a list of possible parameters and odbc states. |
| QCB11 | Error | 21051 | -1009413L | "Secondary server cannot maintain catalog sync. %1" | An error has occurred while applying catalog updates from the coordinator. The secondary server must be restarted or synchronized. Click here for a list of possible parameters and odbc states. |
| QCB12 | Error | 21052 | -1009414L | "Secondary server cannot recover catalog during post-synchronization. %1" | An error has occurred while reconstituting catalog entries for the IQ Local store. Manual repair is required. Click here for a list of possible parameters and odbc states. |
| QCB13 | Error | 21053 | -1009415L | "CREATE TABLE cannot use IN clause for IQ Local store. %1" | You may not specify the IN clause to create tables in IQ Local store. Without an IN clause, the secondary server create tables in Local store by default. Click here for a list of possible parameters and odbc states. |
| QCB14 | Error | 21054 | -1009416L | "Option '%2' not allowed on a partitioned table. %1" | Certain 'load table' options are not supported on a partitioned table. Click here for a list of possible parameters and odbc states. |
| QCB15 | Error | 21055 | -1009417L | "Updating partition key column on a partitioned table is not allowed. %1" | A partition key column cannot be updated. Click here for a list of possible parameters and odbc states. |
| QCB16 | Error | 21056 | -1009418L | "Operation not allowed - partition key column %2 not specified. %1" | A partial width insert on a partitioned table is not permitted when at least one of the table's partition key columns is omitted. Click here for a list of possible parameters and odbc states. |
| QCB17 | Warning | 21149 | 1000297L | "%1. Message logging stopped." | Message log management operation failed due to error in file renaming / deletion / creation. Or log could not be written in the IQMSG file because some DISK IO error occurred. Click here for a list of possible parameters and odbc states. |
| QCB18 | Warning | 21150 | 1000298L | " Message logging resumed." | Engine has detected that reason behind message log management / message logging failure has been resolved. Message logging is resumed now. Click here for a list of possible parameters and odbc states. |
| QCB19 | Error | 21159 | -1009419 | "The width of one or more columns are too large to fit into database's page." | The LOAD Engine cannot fit a column into the page. Click here for a list of possible parameters and odbc states. |
| QCB20 | Error | 21160 | -1009420L | "Value of row's partition-key columns do not fit into any of the table's partitions." | The value for the partition key columns for a specific row do not fit within any of the table's partitions. Click here for a list of possible parameters and odbc states. |