Messages 21162 through 21181

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
21162 Error QBC70 -1006270L "SYSAM Failure while doing: %1" SYSAM internal failure.

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

21163 Error QBC71 -1006271L "IQ_CORE License has expired" SYSAM IQ_CORE license has expired leading to server shutdown

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

21164 Error QDC86 -1000306L " Different DB space, cannot merge partition %2 into %3. %1" Cannot merge Partition partition name 1 into Partition partition name2 in different dbspaces

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

21165 Error QDC87 -1000307L " No data move is allowed, cannot split partition %2. %1" Cannot split Partition partition name 1 into Partition partition name2 and Partition name3 as the split requires to move data.

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

21166 Error QDC88 -1000308L " Boundary value for the partition %2 cannot be changed. %1" Cannot change boundary value for split Partition partition name 1 into (partition-decl-1, partition-decl-2). Boundary value for partition-decl-2 must be the same as partition name 1.

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

21167 Error QDC89 -1000309L " Not all partitions in each column are in same dbspace, cannot unpartition %2. %1" Cannot alter partitioned table to an unpartitioned table as not all partitions in each column are in the same dbspace.

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

21168 Error QDC90 -1000310L " Cannot truncate table partition on a non-partitioned table %2. %1" Cannot truncate table partition on a non-partitioned table.

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

21169 Error QDC91 -1000311L " '%2' is not an IQ DBSPACE. %1" Specified dbspace does not exist or is a catalog dbspace.

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

21170 Error QDC92 -1000312L " ALTER INDEX MOVE can not move FP indexes. Command failed for %2. Use ALTER TABLE MOVE COLUMN instead. %1" ALTER INDEX MOVE command does not move FP indexes. Use ALTER TABLE MOVE COLUMN instead.

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

21171 Error QDC93 -1000313L " ALTER INDEX MOVE not allowed on components of a join index. Command failed for %2. %1" ALTER INDEX MOVE command does not move link indexes.

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

21172 Error QBC72 -1006272L "IQ Main store cannot be larger than licensed limit" SYSAM IQ Main store is larger than the limit specified in product license leading to server shutdown

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

21173 Error QDC94 -1000314L " All rows must be in the first partition. %1" Cannot alter unpartitioned table to a partitioned table as not all rows in the first partition.

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

21174 Error QDC95 -1000315L " Cannot drop the last partition of a partitioned table. %1" Cannot drop the last partition of a partitioned table.

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

21175 Error QDC96 -1000316L "The NoExec option is set. The current operation will be rolled back. %1" Certain operations will not be allowed whenever the NoExec option is set. They are: Alter table Split Partition & Alter Table Partition

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

21176 Error QXA46 -1010047L "%1 is not designated as failover server" Failover process is started on a server which is not designated as failover server

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

21177 Error QXA47 -1010048L "iqmpx_failover and iqmpx_sn switches cannot be enabled simultaneously" While starting an IQ server, both iqmpx_failover and iqmpx_sn command line server switches are ON.

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

21178 Error QXA48 -1010049L "Transaction log recovery not allowed during failover. Please restart the server without the failover switch, do a clean shutdown, restart failover" The failover process should be started only after clean shutdown of the server. If recovery process is initiated during failover then the server was not shut down cleanly and failover should be restarted after the server is restarted and shut down without the failover switch.

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

21179 Error QXA49 -1010050L "Recovery required to complete the last failover process. Please restart the server with failover switch" A previous failover attempt did not finish cleanly. The failover changes must be recovered and to do that restart the server with failover switch.

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

21180 Error QXA50 -1010051L "Failover node catalog is not in sync with TLV log. Please restart server without failover switch, run BEGIN TRANSACTION, do a clean shutdown, then restart failover " The failover process can be started only if the failover node's catalog is up to date with the TLV log. To fix this, restart the server without the failover switch, run BEGIN TRANSACTION, do a clean shutdown, then restart the server with the failover switch.

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

21181 Error QDC97 -1000317L "The current operation is not allowed on RO partition. %1" Alter table drop/split/merge on a RO partition is not allowed.

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


Created April 27, 2010. Send feedback on this help topic to Sybase Technical Publications: pubs@sybase.com