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 |
|---|---|---|---|---|---|
| 22020 | Error | QDD21 | -1013116L | "The operation has been cancelled - Mpx_Work_Unit_Timeout exceeded. %2 %1" | The elapsed time to complete a distributed work unit exceed the timeout value. Click here for a list of possible parameters and odbc states. |
| 22021 | Error | QDD22 | -1000333L | "DBCC IQ_SHARED_TEMP dbspace target not allowed with other targets. %1" | When specifying the IQ_SHARED_TEMP dbspace as a DBCC mode target, no other targets may be specified. Click here for a list of possible parameters and odbc states. |
| 22022 | Error | QDD23 | -1000334L | "Unsupported DBCC dbspace target \"%2\". %1" | DBCC Does not support checking modes on this dbspace target. Click here for a list of possible parameters and odbc states. |
| 22023 | Error | QXA58 | -1010059L | "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. |
| 22024 | Error | QDD24 | -1013117L | "Worker rejected query fragment - %2. %1" | Worker node could not execute the query fragment for the specified reason. Click here for a list of possible parameters and odbc states. |
| 22025 | Error | QSB86 | -1009191L | "The FORCE READWRITE clause is not allowed on this dbspace. It can be specified for the dbspace IQ_SHARED_TEMP only. %1" | The FORCE READWRITE clause can be used with IQ_SHARED_TEMP only. Click here for a list of possible parameters and odbc states. |
| 22026 | Error | QSB87 | -1009192L | "File may not be accessible from one or more multiplex servers. Use sp_iqmpxfilestatus for further diagnosis. %1" | The file must be accessible from all multiplex servers (except those that are excluded) before its mode can be changed to READWRITE. The global file status maintained at the coordinator indicates that file may not be accessible from one or more multiplex servers. Use sp_iqmpxfilestatus for further diagnosis. Click here for a list of possible parameters and odbc states. |
| 22027 | Error | QSB88 | -1009193L | "Insufficient space to accommodate Freelist blocks. Please use a file with at least %2 MB space and turn that file READWRITE. %1" | There is no READWRITE file in IQ_SHARED_TEMP dbspace at this point in time. While trying to turn the first file READWRITE, the file needs to have enough space to accommodate freelist blocks for all the existing files. Click here for a list of possible parameters and odbc states. |
| 22028 | Error | QSB89 | -1009194L | "Please drop the rest of the files in this dbspace before trying to drop this file. \nThis was the first file to be made READWRITE and can only be dropped if it is the last remaining file. %1" | This was the first file to be made READWRITE in IQ_SHARED_TEMP dbspace This file should be the last file in IQ_SHARED_TEMP to be dropped. Please drop rest of the files before trying to drop this file. Click here for a list of possible parameters and odbc states. |
| 22029 | Error | QXA62 | -1010062L | "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. |
| 22030 | Error | QSB90 | -1009195L | "Cannot open file %2, alter file ReadWrite operation failed. %1" | Secondary node cannot make a file in IQ_SHARED_TEMP dbspace READWRITE if it is not accessible. Click here for a list of possible parameters and odbc states. |