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 |
|---|---|---|---|---|---|
| -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. |
| -1010027L | Error | 21127 | QXA27 | "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. |
| -1010028L | Error | 21128 | QXA28 | "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. |
| -1010029L | Error | 21129 | QXA29 | "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. |
| -1010030L | Error | 21130 | QXA30 | "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. |
| -1010032L | Error | 21132 | QXA32 | "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. |
| -1010033L | Error | 21133 | QXA33 | "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. |
| -1010034L | Error | 21134 | QXA34 | "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. |
| -1010035L | Error | 21135 | QXA35 | "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. |
| -1010036L | Error | 21136 | QXA36 | "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. |
| -1010037L | Error | 21137 | QXA37 | "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. |
| -1010038L | Error | 21138 | QXA38 | "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. |
| -1010039L | Error | 21139 | QXA39 | "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. |
| -1010040L | Error | 21140 | QXA40 | "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. |
| -1010041L | Error | 21141 | QXA41 | "Inconsistent data during OpenDatabase. %1" | Open database check failure. Click here for a list of possible parameters and odbc states. |
| -1010042 | Error | 21142 | QDB73 | "\"drop leaks\" is not allowed without executing post-sync secondary server replay. %1" | Disallow DBCC to drop leaked blocks on a MPX secondary server without executing post-sync local TLV replay. Click here for a list of possible parameters and odbc states. |
| -1010043L | Error | 21144 | QXA42 | "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. |
| -1010044L | Error | 21146 | QXA43 | "Plan not available." | "User request for the plan and there is no plan in the cache to be returned. cases when this error will be returned :1. User makes a connection and executes select graphical_plan() or select html_plan(). 2. When the the SQL function graphical_plan and html_plan is used to get the plan for an IQ query for which IQ does not generate plan. " Click here for a list of possible parameters and odbc states. |
| -1010045L | Error | 21147 | QXA44 | "Plan not available. Plan type is not supported for Sybase IQ queries." | "IQ supports only graphical_plan and html_plan SQL functions. Other SA plan functions (plan, explanation etc.) are not supported for Sybase IQ." Click here for a list of possible parameters and odbc states. |