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 |
|---|---|---|---|---|---|
| QXA18 | Error | 21112 | -1010018L | "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. |
| QXA19 | Error | 21113 | -1010019L | "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. |
| QXA20 | Error | 21114 | -1010020L | "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. |
| QXA21 | Error | 21115 | -1010021L | "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. |
| QXA22 | Error | 21117 | -1010022L | "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. |
| 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. |
| 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. |