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 |
|---|---|---|---|---|---|
| 0AW15 | Error | 2698 | -1029L | "Support for materialized views is not available for this database" | The statement being executed requires support for materialized views, but the database being used does not have the materialized view capability. Click here for a list of possible parameters and odbc states. |
| 0AW16 | Error | 2740 | -1071L | "The %1 algorithm is not available in FIPS mode" | The specified algorithm is not available when the server is running in FIPS mode. Click here for a list of possible parameters and odbc states. |
| 0AW17 | Error | 2790 | -1118L | "Cannot change the MobiLink remote id when the status of the last upload is unknown" | The MobiLink server uses the remote id to track synchronization progress. If the status of the previous upload is unknown then you must resolve this condition before changing the remote id. Click here for a list of possible parameters and odbc states. |
| 0AW18 | Error | 2812 | -1139L | "The Remote Data Services feature is not supported on this platform" | You attempted to use a Remote Data Services feature, however, Remote Data Services are not supported on this platform. Click here for a list of possible parameters and odbc states. |
| 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. In order 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 can not 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 an OMNI/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 (e.g. filler) are permitted. 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. |