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 |
|---|---|---|---|---|---|
| -1010048L | Error | 21177 | QXA47 | "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. |
| -1010049L | Error | 21178 | QXA48 | "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. |
| -1010050L | Error | 21179 | QXA49 | "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. |
| -1010051L | Error | 21180 | QXA50 | "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. |
| -1010052L | Error | 21183 | QXA51 | "Only one dbspace file may be added at a time for multiplex servers" | When using ALTER DBSPACE to add a file to a multiplex server, only one file may be added at a time. Specifying a list of files to add is not supported. Click here for a list of possible parameters and odbc states. |
| -1010053L | Error | 21184 | QXA52 | "DBSPACE command extended syntax not permitted" | When using ALTER DBSPACE command, extended syntax is not allowed on a user connection Click here for a list of possible parameters and odbc states. |
| -1010054L | Error | 21186 | QXA53 | "Server option '-iqmpx_ov' only valid when used with '-iqmpx_sn' or '-iqmpx_failover'. %1" | Server option '-iqmpx_ov' is permitted on an Multiplex coordinator node or in combination with either '-iqmpx_sn' or '-iqmpx_failover' on any other Multiplex node type. Click here for a list of possible parameters and odbc states. |
| -1010055L | Error | 21187 | QXA54 | "iqmpx_reclaimwriterfreelist server switch can not be used in Simplex or Secondary nodes" | iqmpx_reclaimwriterfreelist server switch can only be used on a Coordinator node. Click here for a list of possible parameters and odbc states. |
| -1010056L | Error | 21188 | QXA55 | "Recovery switch '-iqfrec' is allowed on a multiplex server only in single-node operating mode. %1" | Recovery switch '-iqfrec' is allowed on a multiplex server only in single-node operating mode. Click here for a list of possible parameters and odbc states. |
| -1010057L | Error | 21201 | QXA56 | "'%2' command is not allowed on temp store files, when server started with -iqnotemp switch. %1" | When the server is running with -iqnotemp switch, certain alter dbspace operations are not allowed. For e.g. alter dbspace add file. Click here for a list of possible parameters and odbc states. |
| -1010058L | Error | 21202 | QXA57 | "Unable to perform forced recovery when database is in read only mode. %1" | Recovery switch '-iqfrec' is allowed on read/write databases only Click here for a list of possible parameters and odbc states. |
| -1010059L | Error | 22023 | QXA58 | "Unable to open the multiplex database. The database can only be opened by starting the Coordinator server using single node mode switch '-iqmpx_sn 1'. %1" | An older version of multiplex database can only be opened bystarting the server in single node mode. If you upgraded the database when server was started using '-iqro 1', then database still needs to be opened by booting the coordinator server in single node mode but without '-iqro 1'. This is because internal IQ on-disk structures could not be upgraded earlier. To complete the upgrade, open the database by starting the coordinator server using single node mode switch '-iqmpx_sn 1', but without '-iqro 1'. After a clean shutdown, the database can then be started normally. Click here for a list of possible parameters and odbc states. |
| -1010060L | Error | 21212 | QXA60 | "Server option -iqmpx_nowr only allowed when there are no writers in multiplex %1" | Please restart coordinator without -iqmpx_nowr switch to add a writer Click here for a list of possible parameters and odbc states. |
| -1010061L | Error | 21213 | QXA61 | "Server switch -iqmpx_nowr only allowed on coordinator node %1" | Please restart the server without -iqmpx_nowr switch Click here for a list of possible parameters and odbc states. |
| -1010062L | Error | 22029 | QXA62 | "Unable to open the database. Start the coordinator server first, without server option -iqro, to complete the Database Upgrade. %1" | As IQ store was opened in RO mode when you upgraded the database, some of its internal meta-data information could not be upgraded to new format. Please start the coordinator server first, without server option -iqro, to complete the IQ side upgrade and continue. Click here for a list of possible parameters and odbc states. |
| -1011000L | Error | 20000 | QVA00 | "Vertical Projection Cursor state error %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1011001L | Error | 20001 | QVA01 | "Cannot find index for a given dfe %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1011002L | Error | 20002 | QVA02 | "The number of existing indexes exceeds the current maximum number of indexes. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1011003L | Error | 20003 | QVA03 | "Vertical Projection Cursor does not support AD-HOC joins. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| -1011004L | Error | 20004 | QNA27 | "Cannot drop primary key or unique constraint because a foreign key still references it." | A primary key or unique constraint involved in a referential integrity relationship cannot be dropped until its corresponding foreign key is first dropped. Click here for a list of possible parameters and odbc states. |