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 |
|---|---|---|---|---|---|
| QTA08 | Error | 20162 | -1005008L | "Sybase IQ does not support nested aggregations. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA09 | Error | 20163 | -1005009L | "Cannot perform an aggregate function on a column from a table not declared in the same query. %2, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA10 | Error | 20164 | -1005010L | "The field '%2' is not unique and needs to be qualified, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA11 | Error | 20165 | -1005011L | "There are two tables named '%2'. Please specify an alias for one of them. %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA12 | Error | 20166 | -1005012L | "The field '%2' specified in the query cannot be found, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA13 | Error | 20167 | -1005013L | "The FROM clause must have at least one table identifier %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA14 | Error | 20168 | -1005014L | "Non-space text found after ending quote character for an enclosed field. %1" | Non-space text found after ending quote character for an enclosed field. Click here for a list of possible parameters and odbc states. |
| QTA15 | Error | 20169 | -1005015L | "The optimizer was unable to find a query plan that avoided cartesian product joins larger than the Max_Cartesian_Result setting %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA16 | Error | 20170 | -1005016L | "Aggregate functions are not allowed in a GROUP BY clause %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA17 | Error | 20171 | -1005017L | "You cannot DELETE from a join virtual table. (%2) %1" | If this message occurs, it means that the user has tried to DELETE from a join virtual table. This is not permitted. Click here for a list of possible parameters and odbc states. |
| QTA18 | Error | 20989 | -1005018L | "Illegal ORDER BY item %2, %1" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA19 | Error | 21060 | -1005019L | "The update FROM list must match the table-clause exactly" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA20 | Error | 21062 | -1005020L | "Only single-table updates are supported by Sybase IQ" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA21 | Error | 21063 | -1005021L | "Sybase IQ does not allow subqueries in update set-items" | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA22 | Error | 21066 | -1005022L | "Aggregate not valid in update set-item expression." | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA23 | Error | 21073 | -1005023L | "Unmatched number of select list items in union" | Cube message here Click here for a list of possible parameters and odbc states. |
| QTA24 | Error | 21074 | -1005024L | "Estimate number: %2 exceed the DEFAULT_MAX_CUBE_RESULT of GROUP BY CUBE or ROLLUP %1" | location of the exception the estimated total result of hash base cube or rollup Click here for a list of possible parameters and odbc states. |
| QTA25 | Error | 21089 | -1005025L | "Query rejected as too complex. After join simplifications there were still %2 tables to be joined, which exceeds the current setting of Max_Join_Enumeration. %1" | The query will take too long to optimize, so it is being rejected Click here for a list of possible parameters and odbc states. |
| QTA26 | Error | 21090 | -1005026L | "Update not supported on null supplying side of outer join." | No additional information available. Click here for a list of possible parameters and odbc states. |
| QTA27 | Error | 21091 | -1005027L | "An error occurs during unistring conversion - %2. %1" | location of the exception the details of unilib error Click here for a list of possible parameters and odbc states. |