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 |
|---|---|---|---|---|---|
| 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 | -1009419L | "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. |
| QCB87 | Error | 20847 | -1000187L | "Unable to implicitly convert column '%2' to datatype (%3) from datatype (%4). %1" | The attempted implicit conversion is not possible. The conversion must be done explicitly. If implicit conversion is being attempted to or from a NUMERIC and this error results, the datatype displayed in the error for the NUMERIC will be SMALLINT, INT, or INT64 depending on the precision of the NUMERIC. This is because NUMERICs are treated internally as multiple precision signed integers. Click here for a list of possible parameters and odbc states. |
| QCC00 | Error | 22001 | -1013103L | "%2 not implemented %1" | This feature has not been implemented Click here for a list of possible parameters and odbc states. |
| QDA00 | Error | 20660 | -1000000L | "ESCAPES option must be OFF. %1" | Sybase IQ only supports 'LOAD TABLE' commands where the ESCAPES options must be OFF. Click here for a list of possible parameters and odbc states. |
| QDA02 | Error | 20662 | -1000002L | "Cannot get the index id for %2 from the catalog. %1" | This is an internal error. Join processing is not able to find an index in the catalog. If this error occurs, it should be reported to Sybase. Click here for a list of possible parameters and odbc states. |
| QDA03 | Error | 20663 | -1000003L | "Cross-database joins are not supported. (%2 and %3) %1" | Cannot join tables from different databases. Click here for a list of possible parameters and odbc states. |