Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
| Error 1009418 | "Operation not allowed - partition key column %2 not specified. %1" |
|---|---|
Constant | EMSG_PARTITIONING_COLUMN_OMITTED |
SAP Sybase Error Number | 21056 |
SQL State | QCB16 |
SQL Code | -1009418L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | column name |
Probable Cause | A partial width insert on a partitioned table is not permitted when at least one of the table's partition key columns is omitted. |
| Error 1009419 | "The width of one or more columns are too large to fit into database's page." |
|---|---|
Constant | EMSG_PAGESIZE_TOO_SMALL_FOR_QCP |
SAP Sybase Error Number | 21159 |
SQL State | QCB19 |
SQL Code | -1009419L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The LOAD Engine cannot fit a column into the page. |
| Error 1009420 | "Value of row's partition-key columns do not fit into any of the table's partitions." |
|---|---|
Constant | EMSG_VALUE_DOES_NOT_FIT |
SAP Sybase Error Number | 21160 |
SQL State | QCB20 |
SQL Code | -1009420L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The value for the partition key columns for a specific row do not fit within any of the table's partitions. |
| Error 1010000 | "The file '%2' already exists. %1" |
|---|---|
Constant | EMSG_DATABASE_FILEALREADYEXISTS |
SAP Sybase Error Number | 20014 |
SQL State | QXA00 |
SQL Code | -1010000L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | dbspace name |
Probable Cause | The named dbspace already exists (and it is a raw partition). To proceed, you must first remove it by hand. |
| Error 1010001 | "Cannot use raw partition for dbspace file '%2'. %1" |
|---|---|
Constant | EMSG_DATABASE_FILEISRAW |
SAP Sybase Error Number | 20015 |
SQL State | QXA01 |
SQL Code | -1010001L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | dbspace name |
Probable Cause | The named dbspace cannot exist on a raw partition. |
| Error 1010002 | "File format mismatch; database %2; Sybase IQ: %3. %1" |
|---|---|
Constant | EMSG_DATABASE_FILEFORMAT |
SAP Sybase Error Number | 20016 |
SQL State | QXA02 |
SQL Code | -1010002L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | file format of database as found in SYSIQINFO |
Parameter 3 | file format as known by IQ DLL |
Probable Cause | The file format of the database doesn't match the file format as expected by the IQ DLL. The IQ DLL and the database each have a format version. They must match. |
| Error 1010003 | "Catalog format mismatch: database %2; Sybase IQ: %3. %1" |
|---|---|
Constant | EMSG_DATABASE_CATALOGFORMAT |
SAP Sybase Error Number | 20017 |
SQL State | QXA03 |
SQL Code | -1010003L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | catalog format of database as found in SYSIQINFO |
Parameter 3 | catalog format as known by IQ DLL |
Probable Cause | The catalog format of the database doesn't match the catalog format as expected by the IQ DLL. The IQ DLL and the ASA catalog each have a format version. They must match. |
| Error 1010004 | "Stored procedure format mismatch: database %2; Sybase IQ: %3. %1" |
|---|---|
Constant | EMSG_DATABASE_SPFORMAT |
SAP Sybase Error Number | 20018 |
SQL State | QXA04 |
SQL Code | -1010004L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | stored procedure of database as found in SYSIQINFO |
Parameter 3 | stored procedure format as known by IQ DLL |
Probable Cause | The stored procedure format of the database doesn't match the stored procedure format as expected by the IQ DLL. The IQ DLL and the database each contain a stored procedure format version. They must match. |
| Error 1010005 | "File format date mismatch: database %2; Sybase IQ: %3. %1" |
|---|---|
Constant | EMSG_DATABASE_TIMESTAMP |
SAP Sybase Error Number | 20019 |
SQL State | QXA05 |
SQL Code | -1010005L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | file format date of database as found in SYSIQINFO |
Parameter 3 | file format as known by IQ DLL |
Probable Cause | The file format date of the database doesn't match the file format date as expected by the IQ DLL. |
| Error 1010006 | "Maximum blocks for dbspace '%2' is %3 blocks. %4 blocks were specified. (Database blocksize is %5.) %1" |
|---|---|
Constant | EMSG_DATABASE_BLOCKRANGE |
SAP Sybase Error Number | 20020 |
SQL State | QXA06 |
SQL Code | -1010006L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | dbspace name |
Parameter 3 | maximum number of blocks for a dbspace given the database's blocksize |
Parameter 4 | maximum blocks the user specified |
Parameter 5 | The blocksize of the database. |
Probable Cause | Given a database's BLOCK SIZE and the number of blocks specified by the user for the dbspace, the dbspace size (in bytes) would exceed the OS's limit of bytes per file. |
| Error 1010007 | "The number of blocks (%3) for dbspace '%2' must be less than or equal to the number of blocks in the raw partition (%4). %1" |
|---|---|
Constant | EMSG_DATABASE_INVALIDNBLOCKS |
SAP Sybase Error Number | 20980 |
SQL State | QXA07 |
SQL Code | -1010007L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | dbspace name |
Parameter 3 | user's number of blocks in dbspace |
Parameter 4 | number of blocks in raw partition |
Probable Cause | When creating a dbspace on a raw partition, if the user specifies the dbspace's size, then it must exactly match the size of the raw partition. |
| Error 1010008 | "For an IQ PAGE SIZE of %2, the dbspace '%3' must have at least %4 MB. %1" |
|---|---|
Constant | EMSG_DATABASE_DBNBLOCKS |
SAP Sybase Error Number | 20981 |
SQL State | QXA08 |
SQL Code | -1010008L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | page size |
Parameter 3 | dbspace name |
Parameter 4 | required minimum size in mega-bytes |
Probable Cause | The named dbspace must have the stated minimum size in megabytes. |
| Error 1010009 | "Improper use of cursor - programmer error %1" |
|---|---|
Constant | EMSG_CURSOR_PROG_ERROR |
SAP Sybase Error Number | 21005 |
SQL State | QXA09 |
SQL Code | -1010009L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | The programmer has misused the internal cursor class(es) |
| Error 1010010 | "An invalid attribute flag was passed to the cursor" |
|---|---|
Constant | EMSG_CURSOR_INVALID_ATTRIBUTE |
SAP Sybase Error Number | 21006 |
SQL State | QXA10 |
SQL Code | -1010010L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | A state violation was detected in the cursor |
| Error 1010011 | "Not enough server threads available for this query." |
|---|---|
Constant | EMSG_CURSOR_NO_THREADS |
SAP Sybase Error Number | 21007 |
SQL State | QXA11 |
SQL Code | -1010011L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | No thread could be allocated to allow this query to be executed |
| Error 1010012 | "The cursor is in an invalid state %1" |
|---|---|
Constant | EMSG_CURSOR_INVALID_STATE |
SAP Sybase Error Number | 21008 |
SQL State | QXA12 |
SQL Code | -1010012L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | A state violation was detected in the cursor |
| Warning 1010013 | "IQ cannot support the %1 connections requested by the server.\nRestart the server with -gm %2 on the command line." |
|---|---|
Constant | EMSG_CONN_INFO |
SAP Sybase Error Number | 21024 |
SQL State | 00A13 |
SQL Code | 1010013L |
ODBC 2 State | OK |
ODBC 3 State | OK |
Severity Code | |
Parameter 1 | the number of connections |
Parameter 2 | the number of supported connections |
Probable Cause | Inform the DBA about the number of connection |
| Error 1010013 | "Raw partition %2 is already in use. %1" |
|---|---|
Constant | EMSG_RAW_PARTITION_INUSE |
SAP Sybase Error Number | 21025 |
SQL State | QXA13 |
SQL Code | -1010013L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | name of the raw partition |
Probable Cause | User attempted to create dbspace on a raw partition which is currently in use by the database. |
| Warning 1010014 | "Default cache size is used for command %1." |
|---|---|
Constant | EMSG_DEFAULTCACHESIZEUSED |
SAP Sybase Error Number | 21058 |
SQL State | QXA14 |
SQL Code | 1010014L |
ODBC 2 State | OK |
ODBC 3 State | OK |
Severity Code | |
Parameter 1 | command type |
Probable Cause | warning is issued for the command that uses the default cache size |
| Error 1010015 | "The MAIN store is out of space. Space must be added to the MAIN store first. %1" |
|---|---|
Constant | EMSG_DATABASE_MSNOSPACE |
SAP Sybase Error Number | 21075 |
SQL State | QXA15 |
SQL Code | -1010015L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Probable Cause | The MAIN store is out of space. Space must be added to the MAIN store before space can be added to any other store. |