Messages on this page are sorted by SQLSTATE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL State | Msg Type | Number | SQL Code | Message | Possible Cause |
|---|---|---|---|---|---|
| QXA03 | Error | 20017 | -1010003L | "Catalog format mismatch: database %2; Sybase IQ: %3. %1" | The catalog format of the database doesn't match the catalog format as expected by the IQ DLL. The IQ DLL and the ASA catalog each have a format version. They must match. Click here for a list of possible parameters and odbc states. |
| QXA04 | Error | 20018 | -1010004L | "Stored procedure format mismatch: database %2; Sybase IQ: %3. %1" | The stored procedure format of the database doesn't match the stored procedure format as expected by the IQ DLL. The IQ DLL and the database each contain a stored procedure format version. They must match. Click here for a list of possible parameters and odbc states. |
| QXA05 | Error | 20019 | -1010005L | "File format date mismatch: database %2; Sybase IQ: %3. %1" | The file format date of the database doesn't match the file format date as expected by the IQ DLL. Click here for a list of possible parameters and odbc states. |
| QXA06 | Error | 20020 | -1010006L | "Maximum blocks for dbspace '%2' is %3 blocks. %4 blocks were specified. (Database blocksize is %5.) %1" | Given a database's BLOCK SIZE and the number of blocks specified by the user for the dbspace, the dbspace size (in bytes) would exceed the OS's limit of bytes per file. Click here for a list of possible parameters and odbc states. |
| QXA07 | Error | 20980 | -1010007L | "The number of blocks (%3) for dbspace '%2' must be less than or equal to the number of blocks in the raw partition (%4). %1" | When creating a dbspace on a raw partition, if the user specifies the dbspace's size, then it must exactly match the size of the raw partition. Click here for a list of possible parameters and odbc states. |
| QXA08 | Error | 20981 | -1010008L | "For an IQ PAGE SIZE of %2, the dbspace '%3' must have at least %4 MB. %1" | The named dbspace must have the stated minimum size in megabytes. Click here for a list of possible parameters and odbc states. |
| QXA09 | Error | 21005 | -1010009L | "Improper use of cursor - programmer error %1" | The programmer has misused the internal cursor class(es) Click here for a list of possible parameters and odbc states. |
| QXA10 | Error | 21006 | -1010010L | "An invalid attribute flag was passed to the cursor" | A state violation was detected in the cursor Click here for a list of possible parameters and odbc states. |
| QXA11 | Error | 21007 | -1010011L | "Not enough server threads available for this query." | No thread could be allocated to allow this query to be executed Click here for a list of possible parameters and odbc states. |
| QXA12 | Error | 21008 | -1010012L | "The cursor is in an invalid state %1" | A state violation was detected in the cursor Click here for a list of possible parameters and odbc states. |
| QXA13 | Error | 21025 | -1010013L | "Raw partition %2 is already in use. %1" | User attempted to create dbspace on a raw partition which is currently in use by the database. Click here for a list of possible parameters and odbc states. |
| QXA14 | Warning | 21058 | 1010014L | "Default cache size is used for command %1." | warning is issued for the command that uses the default cache size Click here for a list of possible parameters and odbc states. |
| QXA15 | Error | 21075 | -1010015L | "The MAIN store is out of space. Space must be added to the MAIN store first. %1" | The MAIN store is out of space. Space must be added to the MAIN store before space can be added to any other store. Click here for a list of possible parameters and odbc states. |
| QXA16 | Error | 21076 | -1010016L | "The TEMPORARY store is out of space. Space must be added to the TEMPORARY store first. %1" | The TEMPORARY store is out of space. Space must be added to the TEMPORARY store before space can be added to any other store. Click here for a list of possible parameters and odbc states. |
| QXA17 | Error | 21111 | -1010017L | "You cannot create tables on a secondary server without a readwrite local IQ Store. %1" | MPX secondary servers can only create IQ objects in a local store. Click here for a list of possible parameters and odbc states. |
| QXA18 | Error | 21112 | -1010018L | "Shared and local tables cannot participate in a JOIN INDEX. %1" | Cannot create a join index between a main and a local table. Click here for a list of possible parameters and odbc states. |
| QXA19 | Error | 21113 | -1010019L | "Cannot modify object %2 on dbspace %3. %1" | A generic error indicating error in modifying an object. Click here for a list of possible parameters and odbc states. |
| QXA20 | Error | 21114 | -1010020L | "Backup not allowed on secondary servers. %1" | The backup command is not allowed to be executed on a secondary server. Execute the command on the coordinator. Click here for a list of possible parameters and odbc states. |
| QXA21 | Error | 21115 | -1010021L | "Foreign key constraint on a local table cannot reference a shared table. %1" | Cannot combine main and local tables in a foreign key relationship. Click here for a list of possible parameters and odbc states. |
| QXA22 | Error | 21117 | -1010022L | "Cannot modify main store from a multiplex query server. %1" | The general error when a query server tries to modify the shared main store. There are other more detailed messages for specific cases. Click here for a list of possible parameters and odbc states. |