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. |
| 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. |
| WB002 | Error | 2182 | -241L | "Database backup not started" | A database backup could not be started. Either a backup is already running, or you do not have the required authority (BACKUP, DBA, or REMOTE DBA). Click here for a list of possible parameters and odbc states. |
| WB003 | Error | 2183 | -242L | "Incomplete transactions prevent transaction log renaming" | The last page in the transaction log was read by a call to db_backup. One or more currently active connections have partially completed transactions, preventing the transaction log file from being renamed. Reissue the db_backup call. Click here for a list of possible parameters and odbc states. |
| WB004 | Error | 2184 | -243L | "Unable to delete database file" | You attempted to delete a database file, but it could not be deleted. The file name should not be the same as any database file that is currently in use. Click here for a list of possible parameters and odbc states. |
| WB005 | Error | 2185 | -244L | "Transaction log was truncated" | An operation was being performed on the transaction log such as SQL Remote or Replication Agent processing and the transaction log was truncated by an independent backup during that operation. Click here for a list of possible parameters and odbc states. |