Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1010008L | Error | 20981 | QXA08 | "For an IQ PAGE SIZE of %2, the dbspace '%3' must have at least %4 MB. %1" | The named dbspace must have the stated minimum size in megabytes. Click here for a list of possible parameters and odbc states. |
| -1010009L | Error | 21005 | QXA09 | "Improper use of cursor - programmer error %1" | The programmer has misused the internal cursor class(es) Click here for a list of possible parameters and odbc states. |
| -1010010L | Error | 21006 | QXA10 | "An invalid attribute flag was passed to the cursor" | A state violation was detected in the cursor Click here for a list of possible parameters and odbc states. |
| -1010011L | Error | 21007 | QXA11 | "Not enough server threads available for this query." | No thread could be allocated to allow this query to be executed Click here for a list of possible parameters and odbc states. |
| -1010012L | Error | 21008 | QXA12 | "The cursor is in an invalid state %1" | A state violation was detected in the cursor Click here for a list of possible parameters and odbc states. |
| 1010013L | Warning | 21024 | 00A13 | "IQ cannot support the %1 connections requested by the server.\nRestart the server with -gm %2 on the command line." | Inform the DBA about the number of connection Click here for a list of possible parameters and odbc states. |
| -1010013L | Error | 21025 | QXA13 | "Raw partition %2 is already in use. %1" | User attempted to create dbspace on a raw partition which is currently in use by the database. Click here for a list of possible parameters and odbc states. |
| 1010014L | Warning | 21058 | QXA14 | "Default cache size is used for command %1." | warning is issued for the command that uses the default cache size Click here for a list of possible parameters and odbc states. |
| -1010015L | Error | 21075 | QXA15 | "The MAIN store is out of space. Space must be added to the MAIN store first. %1" | The MAIN store is out of space. Space must be added to the MAIN store before space can be added to any other store. Click here for a list of possible parameters and odbc states. |
| -1010016L | Error | 21076 | QXA16 | "The TEMPORARY store is out of space. Space must be added to the TEMPORARY store first. %1" | The TEMPORARY store is out of space. Space must be added to the TEMPORARY store before space can be added to any other store. Click here for a list of possible parameters and odbc states. |
| -1010017L | Error | 21111 | QXA17 | "You cannot create tables on a secondary server without a readwrite local IQ Store. %1" | MPX secondary servers can only create IQ objects in a local store. Click here for a list of possible parameters and odbc states. |
| -1010018L | Error | 21112 | QXA18 | "Shared and local tables cannot participate in a JOIN INDEX. %1" | Cannot create a join index between a main and a local table. Click here for a list of possible parameters and odbc states. |
| -1010019L | Error | 21113 | QXA19 | "Cannot modify object %2 on dbspace %3. %1" | A generic error indicating error in modifying an object. Click here for a list of possible parameters and odbc states. |
| -1010020L | Error | 21114 | QXA20 | "Backup not allowed on secondary servers. %1" | The backup command is not allowed to be executed on a secondary server. Execute the command on the coordinator. Click here for a list of possible parameters and odbc states. |
| -1010021L | Error | 21115 | QXA21 | "Foreign key constraint on a local table cannot reference a shared table. %1" | Cannot combine main and local tables in a foreign key relationship. Click here for a list of possible parameters and odbc states. |
| -1010022L | Error | 21117 | QXA22 | "Cannot modify main store from a multiplex query server. %1" | The general error when a query server tries to modify the shared main store. There are other more detailed messages for specific cases. Click here for a list of possible parameters and odbc states. |
| -1010023L | Error | 21121 | QXA23 | "Cursor is not updatable: %2. %1" | Cursor is not updatable: there are join/group by/distinct/set, union, olap function, or no updatable columns. Click here for a list of possible parameters and odbc states. |
| -1010024L | Error | 21122 | QXA24 | "Column '%2' is not updatable. %1" | Column is not updatable if it is long binary/varchar, rowid, (var)binary when ASE_Binary_Display is ON, referenced by other expressions in the select list, identity column, or not in FOR UPDATE of list. Click here for a list of possible parameters and odbc states. |
| -1010025L | Error | 21125 | QXA25 | "Cannot restore to multiplex secondary server. %1" | Multiplex secondary server cannot be restored. Only the coordinator can be restored. Click here for a list of possible parameters and odbc states. |
| -1010026L | Error | 21126 | QXA26 | "Only a server in single_node mode can become a coordinator %1" | Must be in simplex mode to convert to coordinator mode. Click here for a list of possible parameters and odbc states. |