Messages 1010016 through 1010037

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

Error 1010016	"The TEMPORARY store is out of space. Space must be added to the TEMPORARY store first. %1"
Constant	EMSG_DATABASE_TSNOSPACE
SAP Sybase Error Number	21076
SQL State	QXA16
SQL Code	-1010016L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	The TEMPORARY store is out of space. Space must be added to the TEMPORARY store before space can be added to any other store.

Error 1010017	"You cannot create tables on a secondary server without a readwrite local IQ Store. %1"
Constant	EMSG_DATABASE_MPX_NOLOCAL
SAP Sybase Error Number	21111
SQL State	QXA17
SQL Code	-1010017L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	MPX secondary servers can only create IQ objects in a local store.

Error 1010019	"Cannot modify object %2 on dbspace %3. %1"
Constant	EMSG_DATABASE_MPX_NOROMAIN
SAP Sybase Error Number	21113
SQL State	QXA19
SQL Code	-1010019L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Parameter 2	object name
Parameter 3	dbspace name
Probable Cause	A generic error indicating error in modifying an object.

Error 1010020	"Backup not allowed on secondary servers. %1"
Constant	EMSG_DATABASE_MPX_NOLOCALFORBU
SAP Sybase Error Number	21114
SQL State	QXA20
SQL Code	-1010020L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	The backup command is not allowed to be executed on a secondary server. Execute the command on the coordinator.

Error 1010021	"Foreign key constraint on a local table cannot reference a shared table. %1"
Constant	EMSG_DATABASE_MPX_NOXKEYS
SAP Sybase Error Number	21115
SQL State	QXA21
SQL Code	-1010021L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	Cannot combine main and local tables in a foreign key relationship.

Error 1010022	"Cannot modify main store from a multiplex query server. %1"
Constant	EMSG_DATABASE_MPX_NOMAINRWACCESS
SAP Sybase Error Number	21117
SQL State	QXA22
SQL Code	-1010022L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	The general error when a query server tries to modify the shared main store. There are other more detailed messages for specific cases.

Error 1010023	"Cursor is not updatable: %2. %1"
Constant	EMSG_CURSOR_NOT_UPDATABLE
SAP Sybase Error Number	21121
SQL State	QXA23
SQL Code	-1010023L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of exception.
Parameter 2	Reason why the cursor is not updatable.
Probable Cause	Cursor is not updatable: there are join/group by/distinct/set, union, olap function, or no updatable columns.

Error 1010024	"Column '%2' is not updatable. %1"
Constant	EMSG_COLUMN_NOT_UPDATABLE
SAP Sybase Error Number	21122
SQL State	QXA24
SQL Code	-1010024L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of exception.
Parameter 2	Column name.
Probable Cause	Column is not updatable if it is long binary/varchar, rowid, (var)binary when ASE_Binary_Display is ON, referenced by other expressions in the select list, identity column, or not in FOR UPDATE of list.

Error 1010025	"Cannot restore to multiplex secondary server. %1"
Constant	EMSG_DATABASE_MPX_NOLOCALFORRESTORE
SAP Sybase Error Number	21125
SQL State	QXA25
SQL Code	-1010025L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	Multiplex secondary server cannot be restored. Only the coordinator can be restored.

Error 1010026	"Only a server in single_node mode can become a coordinator %1"
Constant	EMSG_DATABASE_MPX_CANTBECOMEWRITER
SAP Sybase Error Number	21126
SQL State	QXA26
SQL Code	-1010026L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	Must be in simplex mode to convert to coordinator mode.

Error 1010027	"Only a server in coordinator mode can become a single_node server %1"
Constant	EMSG_DATABASE_MPX_CANTBECOMESPX
SAP Sybase Error Number	21127
SQL State	QXA27
SQL Code	-1010027L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	Must be in coordinator mode to convert to simplex.

Error 1010028	"A secondary server may not drop or alter a domain owned by the coordinator. %1"
Constant	EMSG_DATABASE_MPX_QNODEDOESNOTOWNDOMAIN
SAP Sybase Error Number	21128
SQL State	QXA28
SQL Code	-1010028L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	Cannot drop a domain on a secondary server unless the secondary server owns the domain.

Error 1010030	"Wrong multiplex mode for this restore. %1"
Constant	EMSG_DATABASE_MPX_WRONGMODEFORRESTORE
SAP Sybase Error Number	21130
SQL State	QXA30
SQL Code	-1010030L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	The mpx mode does not match the restore type.

Error 1010031	"Cannot modify object %2 on dbspace %3. A query server may not modify objects in the main IQ store. %1"
Constant	EMSG_DATABASE_MPX_QUERY_NOWRITE
SAP Sybase Error Number	21131
SQL State	QXA31
SQL Code	-1010031L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Parameter 2	object name
Parameter 3	dbspace name
Probable Cause	A query server may not modify objects in the main store.

Error 1010032	"Bad Database Identity block. %1"
Constant	EMSG_DATABASE_MPX_BADDBID
SAP Sybase Error Number	21132
SQL State	QXA32
SQL Code	-1010032L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	The secondary server has too many or too few shared main dbspaces defined.

Error 1010033	"This secondary server was not shut down cleanly before synchronize. Must start with -iqfrec %1"
Constant	EMSG_DATABASE_MPX_READERNOTSHUTDOWNCLEANLY
SAP Sybase Error Number	21133
SQL State	QXA33
SQL Code	-1010033L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	Must start with iqfrec to rebuild freelist.

Error 1010034	"Modifications of the iq main store not allowed in readonly mode. %1"
Constant	EMSG_DATABASE_MPX_NOWRITEIFREADONLY
SAP Sybase Error Number	21134
SQL State	QXA34
SQL Code	-1010034L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	The mpx mode does not match the restore type.

Error 1010035	"The transaction log does not match the mpx mode of this server. %1"
Constant	EMSG_DATABASE_MPX_LOGDBMODEMISMATCH
SAP Sybase Error Number	21135
SQL State	QXA35
SQL Code	-1010035L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	The mpx mode does not match the transaction log.

Error 1010036	"MPX: invalid file_id. Single_node or coordinator using a local or bad fileID. %1"
Constant	EMSG_DATABASE_MPX_BADFILEID
SAP Sybase Error Number	21136
SQL State	QXA36
SQL Code	-1010036L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	The fileid is not valid for this mpx mode.

Error 1010037	"MPX: invalid local file_id. Secondary server using a bad local fileID. %1"
Constant	EMSG_DATABASE_MPX_BADLOCALFILEID
SAP Sybase Error Number	21137
SQL State	QXA37
SQL Code	-1010037L
ODBC 2 State	ERROR
ODBC 3 State	ERROR
Severity Code	14
Parameter 1	Location of the exception.
Probable Cause	The local fileid is not valid for this mpx mode.

Parent topic: 1009163 - 1013038

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