Messages 1010020 through 1010040

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

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.

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	14
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	14
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	14
Parameter 1	Location of the exception.
Probable Cause	A secondary server must have local store dbspaces defined in order to do a restore.

Parent topic: 1009146 - 1013018

Created December 19, 2013. Send feedback on this help topic to Technical Publications: pubs@sap.com