Messages 21122 through 21141

Messages on this page are sorted by Sybase error code. Locate the appropriate code in the table below, and click the link for a full description of the message.

Number Msg Type SQL State SQL Code Message Possible Cause
21122 Error QXA24 -1010024L "Column '%2' is not updatable. %1" 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.

Click here for a list of possible parameters and odbc states.

21123 Error QNA47 -1008038L "create schema command not allowed on an active multiplex server. " the create schema command is not allowed on an active multiplex server

Click here for a list of possible parameters and odbc states.

21124 Error QDC78 -1000296L " Invalid load specification for LOAD ... FORMAT BCP. %1" The user specified a load specification that is not supported with FORMAT BCP option.

Click here for a list of possible parameters and odbc states.

21125 Error QXA25 -1010025L "Cannot restore to multiplex secondary server. %1" Multiplex secondary server cannot be restored. Only the coordinator can be restored.

Click here for a list of possible parameters and odbc states.

21126 Error QXA26 -1010026L "Only a server in single_node mode can become a coordinator %1" Must be in simplex mode to convert to coordinator mode.

Click here for a list of possible parameters and odbc states.

21127 Error QXA27 -1010027L "Only a server in coordinator mode can become a single_node server %1" Must be in coordinator mode to convert to simplex.

Click here for a list of possible parameters and odbc states.

21128 Error QXA28 -1010028L "A secondary server may not drop or alter a domain owned by the coordinator. %1" Cannot drop a domain on a secondary server unless the secondary server owns the domain.

Click here for a list of possible parameters and odbc states.

21129 Error QXA29 -1010029L "Create or drop JOIN INDEX not allowed in multiplex mode. %1" Create or drop join index is only allowed in simplex mode.

Click here for a list of possible parameters and odbc states.

21130 Error QXA30 -1010030L "Wrong multiplex mode for this restore. %1" The mpx mode does not match the restore type.

Click here for a list of possible parameters and odbc states.

21131 Error QXA31 -1010031L "Cannot modify object %2 on dbspace %3. A query server may not modify objects in the main IQ store. %1" A query server may not modify objects in the main store.

Click here for a list of possible parameters and odbc states.

21132 Error QXA32 -1010032L "Bad Database Identity block. %1" The secondary server has too many or too few shared main dbspaces defined.

Click here for a list of possible parameters and odbc states.

21133 Error QXA33 -1010033L "This secondary server was not shut down cleanly before synchronize. Must start with -iqfrec %1" Must start with iqfrec to rebuild freelist.

Click here for a list of possible parameters and odbc states.

21134 Error QXA34 -1010034L "Modifications of the iq main store not allowed in readonly mode. %1" The mpx mode does not match the restore type.

Click here for a list of possible parameters and odbc states.

21135 Error QXA35 -1010035L "The transaction log does not match the mpx mode of this server. %1" The mpx mode does not match the transaction log.

Click here for a list of possible parameters and odbc states.

21136 Error QXA36 -1010036L "MPX: invalid file_id. Single_node or coordinator using a local or bad fileID. %1" The fileid is not valid for this mpx mode.

Click here for a list of possible parameters and odbc states.

21137 Error QXA37 -1010037L "MPX: invalid local file_id. Secondary server using a bad local fileID. %1" The local fileid is not valid for this mpx mode.

Click here for a list of possible parameters and odbc states.

21138 Error QXA38 -1010038L "MPX: Local stores are not supported. %1" The local fileid is not valid for this mpx mode.

Click here for a list of possible parameters and odbc states.

21139 Error QXA39 -1010039L "MPX: Inconsistent Transaction Manager Data. %1" The local fileid is not valid for this mpx mode.

Click here for a list of possible parameters and odbc states.

21140 Error QXA40 -1010040L "Cannot restore to multiplex secondary server without a local store. %1" A secondary server must have local store dbspaces defined in order to do a restore.

Click here for a list of possible parameters and odbc states.

21141 Error QXA41 -1010041L "Inconsistent data during OpenDatabase. %1" Open database check failure.

Click here for a list of possible parameters and odbc states.


Created November 10, 2011. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com