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 |
|---|---|---|---|---|---|
| 0AW19 | Error | 2824 | -1148L | "Feature not supported by the client version or the client interface" | You have attempted to use a feature which the server supports but the client does not. To use the feature, you must upgrade the client library or use a different client interface. Some features are not supported by the jConnect or Open Client client interfaces. Click here for a list of possible parameters and odbc states. |
| 0AW20 | Error | 2853 | -1176L | "Plan not available. NOEXEC Plan cannot be generated for this type of statement" | You tried to get the NOEXEC plan for a statement type for which IQ cannot generate a NOEXEC plan. Click here for a list of possible parameters and odbc states. |
| 0AW21 | Error | 2854 | -1177L | "No plan. HTML_PLAN function is not supported for this type of statement or database." | You tried to get the HTML plan for a query which is either a SQL Anywhere query or a remote data access/CIS decomposed query. HTML_PLAN is supported for a pure IQ query. Click here for a list of possible parameters and odbc states. |
| 0AW22 | Error | 2860 | -1183L | "Support for permissions on dbspaces is not available for this database" | The statement being executed requires support for permissions on dbspaces, but the database being used does not have this capability. The database must be recreated or upgraded using a version of the server that supports permissions on dbspaces. Click here for a list of possible parameters and odbc states. |
| 0AW23 | Error | 2958 | -1271L | "Synchronization download failed to complete" | You attempted to synchronize an UltraLite database. During the synchronization session, an incomplete download stream was received from the consolidated database. The reason for the upload failure can be found in the synchronization log file. Click here for a list of possible parameters and odbc states. |
| 0AW24 | Error | 2959 | -1272L | "Synchronization is already in progress" | You attempted to synchronize an UltraLite database but this database is being synchronized on another thread. Click here for a list of possible parameters and odbc states. |
| 0AW25 | Error | 2930 | -1316L | "Unsupported load column specification used for a catalog store table." | For catalog store tables, only some of the load column specifications (for example, filler) are permitted. Click here for a list of possible parameters and odbc states. |
| 0AW26 | Error | 3061 | -1382L | "Download failed due to an invalid or unsupported row value" | The synchronization download failed because a downloaded row contained a column value that was either invalid or not supported. Click here for a list of possible parameters and odbc states. |
| 0AWD5 | Error | 2993 | -1305L | "MobiLink communication error -- code: %1, parameter: %2, system code: %3" | An error was encountered while communicating with a MobiLink server. Click here for a list of possible parameters and odbc states. |
| 0EW00 | Error | 2960 | -1273L | "Table '%1' has no columns" | You attempted to create a table without columns. Click here for a list of possible parameters and odbc states. |
| 0EW01 | Error | 2961 | -1274L | "Index '%1' has no columns" | You attempted to create an index without columns. Click here for a list of possible parameters and odbc states. |
| 21000 | Error | 2116 | -185L | "SELECT returns more than one row" | You tried to use a SELECT statement without a cursor, but the statement cursor returns more than one row. Only a single row SELECT statement can be used in this context. Click here for a list of possible parameters and odbc states. |
| 21W01 | Error | 2117 | -186L | "Subquery cannot return more than one row" | You used a subquery that returns more than one row, in a context where only a single row can be used. If the subquery is in the WHERE clause, you might be able to use the IN keyword. Click here for a list of possible parameters and odbc states. |
| 22001 | Error | 2244 | -638L | "Right truncation of string data" | Non-space characters were truncated upon the assignment of string data. Click here for a list of possible parameters and odbc states. |
| 22002 | Error | 2113 | -181L | "No indicator variable provided for NULL result" | You tried to retrieve a value from the database that was NULL, but you did not provide an indicator variable for that value. Click here for a list of possible parameters and odbc states. |
| 22003 | Error | 2105 | -158L | "Value %1 out of range for destination" | You supplied to or fetched from the database a value that is out of range for the destination column or host variable. For example, the value 10 may have been supplied for a DECIMAL(3,2) field. Click here for a list of possible parameters and odbc states. |
| 22005 | Error | 2247 | -641L | "Error in assignment" | In a GET DESCRIPTOR statement, the data type of the host variable must correspond to the data type of the descriptor item. Click here for a list of possible parameters and odbc states. |
| 2200B | Error | 2810 | -1137L | "Escape character conflict '%1'" | The specified escape character cannot be used. Click here for a list of possible parameters and odbc states. |
| 2200C | Error | 2809 | -1136L | "Invalid use of escape character '%1'" | The specified escape character cannot be used. Click here for a list of possible parameters and odbc states. |
| 22012 | Error | 2231 | -628L | "Division by zero" | A division by zero operation was detected. Click here for a list of possible parameters and odbc states. |