Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
| Error 1010038 | "MPX: Local stores are not supported. %1" |
|---|---|
Constant | EMSG_DATABASE_MPX_NOLOCALFILEID |
SAP Sybase Error Number | 21138 |
SQL State | QXA38 |
SQL Code | -1010038L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Probable Cause | The local fileid is not valid for this mpx mode. |
| Error 1010039 | "MPX: Inconsistent Transaction Manager Data. %1" |
|---|---|
Constant | EMSG_DATABASE_MPX_TXNMGRCHECK |
SAP Sybase Error Number | 21139 |
SQL State | QXA39 |
SQL Code | -1010039L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Probable Cause | The local fileid is not valid for this mpx mode. |
| Error 1010040 | "Cannot restore to multiplex secondary server without a local store. %1" |
|---|---|
Constant | EMSG_DATABASE_UNDEFINEDUTILITYCMD |
SAP Sybase Error Number | 21140 |
SQL State | QXA40 |
SQL Code | -1010040L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Probable Cause | A secondary server must have local store dbspaces defined in order to do a restore. |
| Error 1010041 | "Inconsistent data during OpenDatabase. %1" |
|---|---|
Constant | EMSG_DATABASE_OPENDBCHECK |
SAP Sybase Error Number | 21141 |
SQL State | QXA41 |
SQL Code | -1010041L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Probable Cause | Open database check failure. |
| Error 1010042 | "\"drop leaks\" is not allowed without executing post-sync secondary server replay. %1" |
|---|---|
Constant | EMSG_DBCC_DROPLEAKS_NEED_LOCAL_REPLAY |
SAP Sybase Error Number | 21142 |
SQL State | QDB73 |
SQL Code | -1010042L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Probable Cause | Disallow DBCC to drop leaked blocks on a MPX secondary server without executing post-sync local TLV replay. |
| Error 1010043 | "dbspace %2 is currently not open. %1" |
|---|---|
Constant | EMSG_DATABASE_DBSPACE_NOT_OPENED |
SAP Sybase Error Number | 21144 |
SQL State | QXA42 |
SQL Code | -1010043L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Name of dbpace |
Parameter 2 | Location of the exception. |
Probable Cause | The specifed dbspace exists but is not currently open. |
| Error 1010044 | "Plan not available." |
|---|---|
Constant | EMSG_QPTCACHE_NOPLAN |
SAP Sybase Error Number | 21146 |
SQL State | QXA43 |
SQL Code | -1010044L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | "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. " |
| Error 1010045 | "Plan not available. Plan type is not supported for Sybase IQ queries." |
|---|---|
Constant | EMSG_QPTCACHE_INVALID_PLANTYPE |
SAP Sybase Error Number | 21147 |
SQL State | QXA44 |
SQL Code | -1010045L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | "IQ supports only graphical_plan and html_plan SQL functions. Other SA plan functions (plan, explanation etc.) are not supported for Sybase IQ." |
| Error 1010046 | "Plan not available. The database option QUERY_PLAN_TEXT_ACCESS is off." |
|---|---|
Constant | EMSG_QPTCACHE_ACCESS_NOT_ALLOWED |
SAP Sybase Error Number | 21148 |
SQL State | QXA45 |
SQL Code | -1010046L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | "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." |
| Error 1010047 | "%1 is not designated as failover server" |
|---|---|
Constant | EMSG_IQMPX_NOT_FAILOVER |
SAP Sybase Error Number | 21176 |
SQL State | QXA46 |
SQL Code | -1010047L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | server name |
Probable Cause | Failover process is started on a server which is not designated as failover server |
| Error 1010048 | "iqmpx_failover and iqmpx_sn switches cannot be enabled simultaneously" |
|---|---|
Constant | EMSG_IQMPX_CANNOT_MIX_FAILOVER_SN |
SAP Sybase Error Number | 21177 |
SQL State | QXA47 |
SQL Code | -1010048L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | While starting an IQ server, both iqmpx_failover and iqmpx_sn command line server switches are ON. |
| Error 1010049 | "Transaction log recovery not allowed during failover. Please restart the server without the failover switch, do a clean shutdown, restart failover" |
|---|---|
Constant | EMSG_IQMPX_NO_RECOVERY_IN_FAILOVER |
SAP Sybase Error Number | 21178 |
SQL State | QXA48 |
SQL Code | -1010049L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | 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. |
| Error 1010050 | "Recovery required to complete the last failover process. Please restart the server with failover switch" |
|---|---|
Constant | EMSG_IQMPX_START_IN_FAILOVER |
SAP Sybase Error Number | 21179 |
SQL State | QXA49 |
SQL Code | -1010050L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | A previous failover attempt did not finish cleanly. The failover changes must be recovered and to do that restart the server with failover switch. |
| Error 1010051 | "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 " |
|---|---|
Constant | EMSG_IQMPX_FAILOVER_CAT_OUT_OF_SYNC |
SAP Sybase Error Number | 21180 |
SQL State | QXA50 |
SQL Code | -1010051L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | 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. |
| Error 1010052 | "Only one dbspace file may be added at a time for multiplex servers" |
|---|---|
Constant | EMSG_IQMPX_ALTERADD_MULTIPLE_FILES |
SAP Sybase Error Number | 21183 |
SQL State | QXA51 |
SQL Code | -1010052L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | 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. |
| Error 1010053 | "DBSPACE command extended syntax not permitted" |
|---|---|
Constant | EMSG_DBSPACE_EXTENDED_SYNTAX |
SAP Sybase Error Number | 21184 |
SQL State | QXA52 |
SQL Code | -1010053L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | When using ALTER DBSPACE command, extended syntax is not allowed on a user connection |
| Error 1010054 | "Server option '-iqmpx_ov' only valid when used with '-iqmpx_sn' or '-iqmpx_failover'. %1" |
|---|---|
Constant | EMSG_MPX_OV_INVALID_USE |
SAP Sybase Error Number | 21186 |
SQL State | QXA53 |
SQL Code | -1010054L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | 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. |
| Error 1010055 | "iqmpx_reclaimwriterfreelist server switch can not be used in Simplex or Secondary nodes" |
|---|---|
Constant | EMSG_MPX_SWITCH_INVALID_FOR_SPX_OR_SECONDARY |
SAP Sybase Error Number | 21187 |
SQL State | QXA54 |
SQL Code | -1010055L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | iqmpx_reclaimwriterfreelist server switch can only be used on a Coordinator node. |
| Error 1010056 | "Recovery switch '-iqfrec' is allowed on a multiplex server only in single-node operating mode. %1" |
|---|---|
Constant | EMSG_MPX_FREC_INVALID_USE |
SAP Sybase Error Number | 21188 |
SQL State | QXA55 |
SQL Code | -1010056L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | Recovery switch '-iqfrec' is allowed on a multiplex server only in single-node operating mode. |
| Error 1010057 | "'%2' command is not allowed on temp store files, when server started with -iqnotemp switch. %1" |
|---|---|
Constant | EMSG_ILLEGAL_ALTER_DBSPACE_NOTEMP |
SAP Sybase Error Number | 21201 |
SQL State | QXA56 |
SQL Code | -1010057L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | alter dbspace command type string |
Probable Cause | When the server is running with -iqnotemp switch, certain alter dbspace operations are not allowed. For e.g. alter dbspace add file. |