Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
Error 1008006 | "You cannot specify a DEFAULT value for a column." |
---|---|
Constant | EMSG_IQ_INVALIDDEFAULT |
SAP Sybase Error Number | 20676 |
SQL State | QNA06 |
SQL Code | -1008006L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The user cannot specify a DEFAULT value for a column during CREATE TABLE or ALTER TABLE ADD COLUMN. |
Error 1008007 | "The ALTER TABLE option '%2' is not supported by Sybase IQ. %1" |
---|---|
Constant | EMSG_IQ_NOSUPPORT |
SAP Sybase Error Number | 20677 |
SQL State | QNA07 |
SQL Code | -1008007L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Parameter 2 | The ALTER TABLE option the user is attempting to use. |
Probable Cause | The user entered an option that is not supported by Sybase IQ but is supported by ASA (like REPLICATION ON). |
Error 1008008 | "You cannot TRUNCATE a join virtual table." |
---|---|
Constant | EMSG_IQ_NOTRUNCATEJVT |
SAP Sybase Error Number | 20679 |
SQL State | QNA08 |
SQL Code | -1008008L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The user is not allowed to TRUNCATE a join virtual table. |
Error 1008009 | "This statement is not supported by Sybase IQ." |
---|---|
Constant | EMSG_IQ_STMTNOTSUPPORTED |
SAP Sybase Error Number | 20680 |
SQL State | QNA09 |
SQL Code | -1008009L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The statement entered is supported by Adaptive Server Anywhere, but not by Sybase IQ. |
Error 1008010 | "A request was made to delete the primary key constraint, but the primary key cannot be found." |
---|---|
Constant | EMSG_IQ_NOPRIMARYKEY |
SAP Sybase Error Number | 20681 |
SQL State | QNA10 |
SQL Code | -1008010L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The user wanted to delete the primary key constraint on the table but the primary key could not be found. |
Error 1008012 | "This unique index/constraint must be ENFORCED." |
---|---|
Constant | EMSG_IQ_NEEDENFORCED |
SAP Sybase Error Number | 20990 |
SQL State | QNA12 |
SQL Code | -1008012L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | This unique index/constraint must be ENFORCED (The UNENFORCED keyword not allowed for this index/constraint). |
Error 1008013 | "This multi-column unique index/constraint must be UNENFORCED." |
---|---|
Constant | EMSG_IQ_NEEDUNENFORCED |
SAP Sybase Error Number | 20991 |
SQL State | QNA13 |
SQL Code | -1008013L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | This multi-column unique index/constraint must be UNENFORCED (The UNENFORCED keyword is required for this index/constraint). |
Error 1008014 | "This foreign key must be UNENFORCED." |
---|---|
Constant | EMSG_IQ_FKEYNOSUPP |
SAP Sybase Error Number | 20992 |
SQL State | QNA14 |
SQL Code | -1008014L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | This foreign key must be UNENFORCED (The UNENFORCED keyword is required for this foreign key). |
Error 1008015 | "This check constraint must be ENFORCED." |
---|---|
Constant | EMSG_IQ_CHCKENFORCED |
SAP Sybase Error Number | 20993 |
SQL State | QNA15 |
SQL Code | -1008015L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The keyword UNENFORCED is not supported. |
Error 1008016 | "Cannot ALTER DELETE a column that has a unique or primary key constraint." |
---|---|
Constant | EMSG_IQ_CONSTRAINTONCOL |
SAP Sybase Error Number | 20994 |
SQL State | QNA16 |
SQL Code | -1008016L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | Cannot ALTER DELETE a column that has a unique or primary key constraint. This is a duplicate of an SA error code. |
Error 1008017 | "Cannot ALTER DELETE a column that has multi-column index." |
---|---|
Constant | EMSG_IQ_MULTICOLONINDEX |
SAP Sybase Error Number | 20995 |
SQL State | QNA17 |
SQL Code | -1008017L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | Cannot ALTER DELETE a column that has multi-column index. This is a duplicate of an SA error code. |
Error 1008019 | "Multiplex is currently inactive." |
---|---|
Constant | EMSG_IQMPX_INACTIVE |
SAP Sybase Error Number | 21041 |
SQL State | QNA19 |
SQL Code | -1008019L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The user has either requested a multiplex function or has asked for multiplex status. |
Error 1008020 | "Multiplex command or request is unimplemented." |
---|---|
Constant | EMSG_IQMPX_NOTIMPL |
SAP Sybase Error Number | 21042 |
SQL State | QNA20 |
SQL Code | -1008020L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | The user has requested an unimplemented multiplex feature. This would typically be a status request which doesn't exist. |
Error 1008021 | "The SYSIQFILE table is not configured for this server to run in a multiplex." |
---|---|
Constant | EMSG_IQMPX_BADCONFIG |
SAP Sybase Error Number | 21043 |
SQL State | QNA21 |
SQL Code | -1008021L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | SYSIQFILE identifies all files which make up the given stores that the IQ server requires (main, temp, and message). For multiplex, each entry in SYSIQFILE must be associated with a particular multiplex server before that server can access the particular file. This message indicates that some these rows are missing for the active server. |
Error 1008022 | "Bad commit identity block. The server may be out of synchronization. %1" |
---|---|
Constant | EMSG_IQMPX_BADCMID |
SAP Sybase Error Number | 21044 |
SQL State | QNA22 |
SQL Code | -1008022L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | Multiplex servers cannot start this database. Start the coordinator in single server mode. |
Error 1008023 | "Cannot start multiplex secondary server while the coordinator is in single server mode" |
---|---|
Constant | EMSG_IQMPX_SPXDB |
SAP Sybase Error Number | 21045 |
SQL State | QNA23 |
SQL Code | -1008023L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | Restart the secondary server after the coordinator has restarted in normal mode. |
Error 1008024 | "Multiplex coordinator must start as server@host: %2, on file: %3; to start with different settings, you must use the override switch. %1" |
---|---|
Constant | EMSG_IQMPX_TWOWRITERS |
SAP Sybase Error Number | 21046 |
SQL State | QNA24 |
SQL Code | -1008024L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | server@host names for coordinator |
Parameter 3 | catalog db filename for coordinator |
Probable Cause | Only the configured coordinator can start the database. Start with the override switch (-iqmpx_ov 1) to bypass this check. |
Error 1008025 | "Multiplex secondary server cannot continue while the coordinator is in single server mode. %1" |
---|---|
Constant | EMSG_IQMPX_SPXONLY |
SAP Sybase Error Number | 21047 |
SQL State | QNA25 |
SQL Code | -1008025L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | Resynchronize and restart the secondary server after the coordinator has restarted in normal mode. |
Error 1008026 | "Multiplex secondary server out of synchronization with the coordinator. %1" |
---|---|
Constant | EMSG_IQMPX_CATSYNC |
SAP Sybase Error Number | 21048 |
SQL State | QNA26 |
SQL Code | -1008026L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | The secondary server's IQ catalog cannot be brought up to date with the coordinator's IQ catalog. This server must be synchronized. |
Error 1008027 | "Multiplex secondary node shutting down due to a file added to the IQ_SYSTEM_MAIN dbspace.\nThis node must be synchronized and restarted. %1" |
---|---|
Constant | EMSG_IQMPX_SEGCOUNT |
SAP Sybase Error Number | 21057 |
SQL State | QNA28 |
SQL Code | -1008027L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | The user has added a dbspace file to IQ_SYSTEM_MAIN on the coordinator. This causes secondary nodes to shut down. All secondary nodes must be synchronized and restarted after this operation. |