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 |
|---|---|---|---|---|---|
| QXA43 | Error | 21146 | -1010044L | "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. |
| QXA44 | Error | 21147 | -1010045L | "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. |
| QXA45 | Error | 21148 | -1010046L | "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. |
| QXA46 | Error | 21176 | -1010047L | "%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. |
| QXA47 | Error | 21177 | -1010048L | "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. |
| QXA48 | Error | 21178 | -1010049L | "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. |
| QXA49 | Error | 21179 | -1010050L | "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. |
| QXA50 | Error | 21180 | -1010051L | "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. |
| QXA51 | Error | 21183 | -1010052L | "Only one dbspace file may be added at a time for multiplex servers" | When using ALTER DBSPACE to add a file to a multiplex server, only one file may be added at a time. Specifying a list of files to add is not supported. Click here for a list of possible parameters and odbc states. |
| QXA52 | Error | 21184 | -1010053L | "DBSPACE command extended syntax not permitted" | When using ALTER DBSPACE command, extended syntax is not allowed on a user connection Click here for a list of possible parameters and odbc states. |
| QXA53 | Error | 21186 | -1010054L | "Server option '-iqmpx_ov' only valid when used with '-iqmpx_sn' or '-iqmpx_failover'. %1" | Server option '-iqmpx_ov' is permitted on an Multiplex coordinator node or in combination with either '-iqmpx_sn' or '-iqmpx_failover' on any other Multiplex node type. Click here for a list of possible parameters and odbc states. |
| QXA54 | Error | 21187 | -1010055L | "iqmpx_reclaimwriterfreelist server switch can not be used in Simplex or Secondary nodes" | iqmpx_reclaimwriterfreelist server switch can only be used on a Coordinator node. Click here for a list of possible parameters and odbc states. |
| QXA55 | Error | 21188 | -1010056L | "Recovery switch '-iqfrec' is allowed on a multiplex server only in single-node operating mode. %1" | Recovery switch '-iqfrec' is allowed on a multiplex server only in single-node operating mode. Click here for a list of possible parameters and odbc states. |
| QXA56 | Error | 21201 | -1010057L | "'%2' command is not allowed on temp store files, when server started with -iqnotemp switch. %1" | When the server is running with -iqnotemp switch, certain alter dbspace operations are not allowed. For e.g. alter dbspace add file. Click here for a list of possible parameters and odbc states. |
| QXA57 | Error | 21202 | -1010058L | "Unable to perform forced recovery when database is in read only mode. %1" | Recovery switch '-iqfrec' is allowed on read/write databases only Click here for a list of possible parameters and odbc states. |
| QXA58 | Error | 22023 | -1010059L | "Unable to open the multiplex database. The database can only be opened by starting the Coordinator server using single node mode switch '-iqmpx_sn 1'. %1" | An older version of multiplex database can only be opened bystarting the server in single node mode. If you upgraded the database when server was started using '-iqro 1', then database still needs to be opened by booting the coordinator server in single node mode but without '-iqro 1'. This is because internal IQ on-disk structures could not be upgraded earlier. To complete the upgrade, open the database by starting the coordinator server using single node mode switch '-iqmpx_sn 1', but without '-iqro 1'. After a clean shutdown, the database can then be started normally. Click here for a list of possible parameters and odbc states. |
| QXA60 | Error | 21212 | -1010060L | "Server option -iqmpx_nowr only allowed when there are no writers in multiplex %1" | Please restart coordinator without -iqmpx_nowr switch to add a writer Click here for a list of possible parameters and odbc states. |
| QXA61 | Error | 21213 | -1010061L | "Server switch -iqmpx_nowr only allowed on coordinator node %1" | Please restart the server without -iqmpx_nowr switch Click here for a list of possible parameters and odbc states. |
| QXA62 | Error | 22029 | -1010062L | "Unable to open the database. Start the coordinator server first, without server option -iqro, to complete the Database Upgrade. %1" | As IQ store was opened in RO mode when you upgraded the database, some of its internal meta-data information could not be upgraded to new format. Please start the coordinator server first, without server option -iqro, to complete the IQ side upgrade and continue. Click here for a list of possible parameters and odbc states. |
| WB001 | Error | 2181 | -240L | "Unknown backup operation" | You specified an invalid backup statement operation in a call to db_backup. Click here for a list of possible parameters and odbc states. |