Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1009137L | Error | 21036 | QDC55 | "Cannot perform DDL command now on table %2 as a DDL command is already in progress on that table. %1" | There is already a DDL command in progress at the moment on the table specified and you must wait until it is finished before starting another DDL command on that table. Click here for a list of possible parameters and odbc states. |
| -1009138L | Error | 21037 | QCA48 | "Join index '%2' is in use. %1" | Cannot drop a join index that is in use. Click here for a list of possible parameters and odbc states. |
| -1009139L | Error | 21038 | QSB38 | "Cannot perform requested command as there is a CHECKPOINT command in progress. %1" | A CREATE DBSPACE or a DROP DBSPACE command was issued when there was already a CHECKPOINT command in progress. Click here for a list of possible parameters and odbc states. |
| -1009140L | Error | 21039 | QCA49 | "Cannot restore dbspace '%2' to raw partition '%3' because its size is smaller than the size of the original raw partition (%4 vs. %5 blocks). %1" | This error means that the user is attempting to restore an IQ dbspace on a raw partition that is not the same size as the original raw partition on which the IQ dbspace existed at the time of the backup. The user must resize the raw partition and then retry the restore operation. Click here for a list of possible parameters and odbc states. |
| -1009141L | Error | 21061 | QCA51 | "Table '%2' cannot be found in the IQ store. %1" | The stored procedure sp_iqtablesize cannot find the table. This stored procedure is for IQ tables only. It cannot be run against system tables or ASA tables. Click here for a list of possible parameters and odbc states. |
| 1009142L | Warning | 21067 | QSB39 | " %1 SortMerge0: %2 records, PhaseI=%3 Secs, %4 runs total, %5 pgs=%6 M, runlen=%7, %8 est. phases" | This information is provided after the Phase I radix sorting is complete and the Phase II merge-sorting is about to begin. Each run consists of a sequence of pages that have been radix sorted in Phase I. These runs are merged together in Phase II to finish the sort. Click here for a list of possible parameters and odbc states. |
| 1009143L | Warning | 21068 | QSB40 | " %1 SortMergePass: Merged %2 runs, %3 Secs, %4 runs remaining, %5 reads = %6 M, runlen=%7, phase %8, %9 M on disk" | This information is provided after each merge pass. One merge pass merges a certain number of runs, using one pinned buffer page per run plus one pinned buffer for the output run. Note that there can be several passes in a merge phase. One merge phase reads all the sort data and produces a new set of runs that provide input to the next phase. Click here for a list of possible parameters and odbc states. |
| 1009144L | Warning | 21069 | QSB41 | " %1 SortMergeDone: Ave mem %2 M, %3 Secs, %4 passes, %5 reads, %6 M data= %7 pgs, %8 phases, %9 M on disk" | This information is provided at the end of Phase II to summarize the resource usage of the whole merge sort. The last pass of the sort is separately reported on by an EMSG_SORT_INFOMERGED1 message. Click here for a list of possible parameters and odbc states. |
| -1009145L | Error | 21070 | QFA2E | "Data exception - data type conversion is not possible. %2, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1009146L | Error | 21071 | QSB42 | "Cannot perform requested command as there is a DBCC command in progress. %1" | A CHECKPOINT command was issued when there was already a DBCC command in progress. Click here for a list of possible parameters and odbc states. |
| 1009147L | Warning | 20188 | QSB43 | "Space has become available in the %1 store of database %2. Sybase IQ (TM) is no longer waiting for more dbspace." | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1009148L | Error | 21049 | QSB44 | "Cannot use -iqfrec to start a multiplex secondary server. %1" | A sp_iqcheckdb procedure call was issued on an IQ multiplex secondary server, or it was started in drop-leaks or forced recovery mode. These operations are only allowed on the coordinator Click here for a list of possible parameters and odbc states. |
| -1009149L | Error | 20189 | QSB45 | "%2 Internal Inconsistency: %1 (%3,%4,%5)" | A corrupt index container was found. DBCC cannot repair the container. The database object using the container must be re-created. Click here for a list of possible parameters and odbc states. |
| -1009150L | Error | 20190 | QSB46 | "Cannot delete/truncate CK %2 because of RI violation - FK has non-nulls. %1" | No additional information available. Cannot truncate or delete all from candidate table if there exists any associated foreign key which has any all non-null data. Click here for a list of possible parameters and odbc states. |
| -1009151L | Error | 20191 | QSB47 | "Cannot %2 CK %3 row %4 because of RI violation. %1" | No additional information available. Cannot delete/update CK if there exists same value in associated FK. any associated foreign key which has any all non-null data. Click here for a list of possible parameters and odbc states. |
| -1009152L | Error | 20192 | QSB48 | "Cannot %2 FK %3 row %4 because of RI violation. %1" | No additional information available. Cannot insert/update FK if there does not exist same value in associated CK any associated foreign key which has any all non-null data. Click here for a list of possible parameters and odbc states. |
| -1009153L | Error | 20193 | QSB49 | "Cannot remove row %3 from CK %2 during LOAD cleanup because of RI violation. %1" | No additional information available. If removing self-referential CK during LOAD cleanup phase and there exists a FK of removed value, we roll back the whole operation. Click here for a list of possible parameters and odbc states. |
| -1009154L | Error | 21118 | QSB50 | "Cannot alter dbspace when a backup is in progress" | An alter dbspace operation was attempted while a backup was running. The alter dbspace operation cannot proceed since it may modify internal database structures that are being backed up. Click here for a list of possible parameters and odbc states. |
| -1009155L | Error | 22000 | QSB55 | "Cannot perform requested command as there is an ALTER DBSPACE command in progress. %1" | A CREATE DBSPACE or a DROP DBSPACE command was issued when there was already an ALTER DBSPACE command in progress. Click here for a list of possible parameters and odbc states. |
| -1009156L | Error | 20194 | QSB51 | "Drop disallowed for dbspace %2. One or more of the file(s) are in use by the database. %1" | A segment must contain no user data and no database structures to drop Click here for a list of possible parameters and odbc states. |