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 |
|---|---|---|---|---|---|
| QXA23 | Error | 21121 | -1010023L | "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. |
| QXA24 | Error | 21122 | -1010024L | "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. |
| QXA25 | Error | 21125 | -1010025L | "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. |
| QXA26 | Error | 21126 | -1010026L | "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. |
| QXA27 | Error | 21127 | -1010027L | "Only a server in coordinator mode can become a single_node server %1" | Must be in coordinator mode to convert to simplex. Click here for a list of possible parameters and odbc states. |
| QXA28 | Error | 21128 | -1010028L | "A secondary server may not drop or alter a domain owned by the coordinator. %1" | Cannot drop a domain on a secondary server unless the secondary server owns the domain. Click here for a list of possible parameters and odbc states. |
| QXA29 | Error | 21129 | -1010029L | "Create or drop JOIN INDEX not allowed in multiplex mode. %1" | Create or drop join index is only allowed in simplex mode. Click here for a list of possible parameters and odbc states. |
| QXA30 | Error | 21130 | -1010030L | "Wrong multiplex mode for this restore. %1" | The mpx mode does not match the restore type. Click here for a list of possible parameters and odbc states. |
| QXA31 | Error | 21131 | -1010031L | "Cannot modify object %2 on dbspace %3. A query server may not modify objects in the main IQ store. %1" | A query server may not modify objects in the main store. Click here for a list of possible parameters and odbc states. |
| QXA32 | Error | 21132 | -1010032L | "Bad Database Identity block. %1" | The secondary server has too many or too few shared main dbspaces defined. Click here for a list of possible parameters and odbc states. |
| QXA33 | Error | 21133 | -1010033L | "This secondary server was not shut down cleanly before synchronize. Must start with -iqfrec %1" | Must start with iqfrec to rebuild freelist. Click here for a list of possible parameters and odbc states. |
| QXA34 | Error | 21134 | -1010034L | "Modifications of the iq main store not allowed in readonly mode. %1" | The mpx mode does not match the restore type. Click here for a list of possible parameters and odbc states. |
| QXA35 | Error | 21135 | -1010035L | "The transaction log does not match the mpx mode of this server. %1" | The mpx mode does not match the transaction log. Click here for a list of possible parameters and odbc states. |
| QXA36 | Error | 21136 | -1010036L | "MPX: invalid file_id. Single_node or coordinator using a local or bad fileID. %1" | The fileid is not valid for this mpx mode. Click here for a list of possible parameters and odbc states. |
| QXA37 | Error | 21137 | -1010037L | "MPX: invalid local file_id. Secondary server using a bad local fileID. %1" | The local fileid is not valid for this mpx mode. Click here for a list of possible parameters and odbc states. |
| QXA38 | Error | 21138 | -1010038L | "MPX: Local stores are not supported. %1" | The local fileid is not valid for this mpx mode. Click here for a list of possible parameters and odbc states. |
| QXA39 | Error | 21139 | -1010039L | "MPX: Inconsistent Transaction Manager Data. %1" | The local fileid is not valid for this mpx mode. Click here for a list of possible parameters and odbc states. |
| QXA40 | Error | 21140 | -1010040L | "Cannot restore to multiplex secondary server without a local store. %1" | A secondary server must have local store dbspaces defined in order to do a restore. Click here for a list of possible parameters and odbc states. |
| QXA41 | Error | 21141 | -1010041L | "Inconsistent data during OpenDatabase. %1" | Open database check failure. Click here for a list of possible parameters and odbc states. |
| QXA42 | Error | 21144 | -1010043L | "dbspace %2 is currently not open. %1" | The specifed dbspace exists but is not currently open. Click here for a list of possible parameters and odbc states. |