Messages 1008001 through 1008024

Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.

Error 1008001	"The user cannot create indexes on a join virtual table."
Constant	EMSG_IQ_NOCREATEINDEXJVT
SAP Sybase Error Number	20621
SQL State	QNA01
SQL Code	-1008001L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Probable Cause	Users cannot create indexes on a join virtual table. They are automatically created.

Error 1008004	"Cannot DROP index '%1'."
Constant	EMSG_IQ_NODROPIQINDEX
SAP Sybase Error Number	20673
SQL State	QNA04
SQL Code	-1008004L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Name of the index the user is attempting to drop.
Probable Cause	Users cannot drop internally created indexes except by dropping the table or alter-dropping the table. Fast Projection indexes are internally created indexes.

Error 1008005	"Cannot ALTER join virtual table '%1'."
Constant	EMSG_IQ_NOALTERJVT
SAP Sybase Error Number	20675
SQL State	QNA05
SQL Code	-1008005L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	The join virtual table the user is attempting to alter.
Probable Cause	The user cannot alter a join virtual table.

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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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	14
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.

Parent topic: 1006256 - 1009162

Created May 23, 2013. Send feedback on this help topic to Technical Publications: pubs@sybase.com