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 |
|---|---|---|---|---|---|
| -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. |
| -1010046L | Error | 21148 | QXA45 | "Plan not available. The database option QUERY_PLAN_TEXT_ACCESS is off." | "The plan can be accessed on the client by the user only when DBA sets option QUERY_PLAN_TEXT_ACCESS to ON for the user." Click here for a list of possible parameters and odbc states. |
| -1010047L | Error | 21176 | QXA46 | "%1 is not designated as failover server" | Failover process is started on a server which is not designated as failover server Click here for a list of possible parameters and odbc states. |
| -1010048L | Error | 21177 | QXA47 | "iqmpx_failover and iqmpx_sn switches cannot be enabled simultaneously" | While starting an IQ server, both iqmpx_failover and iqmpx_sn command line server switches are ON. Click here for a list of possible parameters and odbc states. |
| -1010049L | Error | 21178 | QXA48 | "Transaction log recovery not allowed during failover. Please restart the server without the failover switch, do a clean shutdown, restart failover" | The failover process should be started only after clean shutdown of the server. If recovery process is initiated during failover then the server was not shut down cleanly and failover should be restarted after the server is restarted and shut down without the failover switch. Click here for a list of possible parameters and odbc states. |
| -1010050L | Error | 21179 | QXA49 | "Recovery required to complete the last failover process. Please restart the server with failover switch" | A previous failover attempt did not finish cleanly. The failover changes must be recovered and to do that restart the server with failover switch. Click here for a list of possible parameters and odbc states. |
| -1010051L | Error | 21180 | QXA50 | "Failover node catalog is not in sync with TLV log. Please restart server without failover switch, run BEGIN TRANSACTION, do a clean shutdown, then restart failover " | The failover process can be started only if the failover node's catalog is up to date with the TLV log. To fix this, restart the server without the failover switch, run BEGIN TRANSACTION, do a clean shutdown, then restart the server with the failover switch. Click here for a list of possible parameters and odbc states. |