Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
| Error 1005008 | "Sybase IQ does not support nested aggregations. %1" |
|---|---|
Constant | EMSG_UNSUPPORTEDNESTEDAGG |
SAP Sybase Error Number | 20162 |
SQL State | QTA08 |
SQL Code | -1005008L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | No additional information available. |
| Error 1005009 | "Cannot perform an aggregate function on a column from a table not declared in the same query. %2, %1" |
|---|---|
Constant | EMSG_OUTERSINAGG |
SAP Sybase Error Number | 20163 |
SQL State | QTA09 |
SQL Code | -1005009L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | SQL Commandline line |
Probable Cause | No additional information available. |
| Error 1005010 | "The field '%2' is not unique and needs to be qualified, %1" |
|---|---|
Constant | EMSG_FIELDNOTUNIQUE |
SAP Sybase Error Number | 20164 |
SQL State | QTA10 |
SQL Code | -1005010L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | explanation for arg %2 delete if no %2 |
Probable Cause | No additional information available. |
| Error 1005011 | "There are two tables named '%2'. Please specify an alias for one of them. %1" |
|---|---|
Constant | EMSG_TABLENOTUNIQUE |
SAP Sybase Error Number | 20165 |
SQL State | QTA11 |
SQL Code | -1005011L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | table name which is not unique |
Probable Cause | No additional information available. |
| Error 1005012 | "The field '%2' specified in the query cannot be found, %1" |
|---|---|
Constant | EMSG_FIELDNOTDEFINED |
SAP Sybase Error Number | 20166 |
SQL State | QTA12 |
SQL Code | -1005012L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | explanation for arg %2 delete if no %2 |
Probable Cause | No additional information available. |
| Error 1005013 | "The FROM clause must have at least one table identifier %1" |
|---|---|
Constant | EMSG_SEMANTIC_NO_TABLES_IN_FROM_CLAUSE |
SAP Sybase Error Number | 20167 |
SQL State | QTA13 |
SQL Code | -1005013L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | No additional information available. |
| Error 1005014 | "Non-space text found after ending quote character for an enclosed field. %1" |
|---|---|
Constant | EMSG_NONSPACE_AFTER_QUOTE |
SAP Sybase Error Number | 20168 |
SQL State | QTA14 |
SQL Code | -1005014L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | Non-space text found after ending quote character for an enclosed field. |
| Error 1005015 | "The optimizer was unable to find a query plan that avoided cartesian product joins larger than the Max_Cartesian_Result setting %1" |
|---|---|
Constant | EMSG_CARTESION_RESULT_TOO_BIG |
SAP Sybase Error Number | 20169 |
SQL State | QTA15 |
SQL Code | -1005015L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | No additional information available. |
| Error 1005016 | "Aggregate functions are not allowed in a GROUP BY clause %1" |
|---|---|
Constant | EMSG_ILLEGAL_SET_FUNCTION_USAGE |
SAP Sybase Error Number | 20170 |
SQL State | QTA16 |
SQL Code | -1005016L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Probable Cause | No additional information available. |
| Error 1005017 | "You cannot DELETE from a join virtual table. (%2) %1" |
|---|---|
Constant | EMSG_CANNOT_DELETE_FROM_JVT |
SAP Sybase Error Number | 20171 |
SQL State | QTA17 |
SQL Code | -1005017L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | Tablename |
Probable Cause | If this message occurs, it means that the user has tried to DELETE from a join virtual table. This is not permitted. |
| Error 1005018 | "Illegal ORDER BY item %2, %1" |
|---|---|
Constant | EMSG_BAD_ORDERBY_ITEM |
SAP Sybase Error Number | 20989 |
SQL State | QTA18 |
SQL Code | -1005018L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | argument |
Probable Cause | No additional information available. |
| Error 1005019 | "The update FROM list must match the table-clause exactly" |
|---|---|
Constant | EMSG_BAD_UPDATE_FROM_LIST |
SAP Sybase Error Number | 21060 |
SQL State | QTA19 |
SQL Code | -1005019L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | No additional information available. |
| Error 1005020 | "Only single-table updates are supported by Sybase IQ" |
|---|---|
Constant | EMSG_SINGLE_TABLE_UPDATE_ONLY |
SAP Sybase Error Number | 21062 |
SQL State | QTA20 |
SQL Code | -1005020L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | No additional information available. |
| Error 1005021 | "Sybase IQ does not allow subqueries in update set-items" |
|---|---|
Constant | EMSG_SUBQ_NOT_ALLOWED_IN_SETITEM |
SAP Sybase Error Number | 21063 |
SQL State | QTA21 |
SQL Code | -1005021L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | No additional information available. |
| Error 1005022 | "Aggregate not valid in update set-item expression." |
|---|---|
Constant | EMSG_AGG_NOT_ALLOWED_IN_SETITEM |
SAP Sybase Error Number | 21066 |
SQL State | QTA22 |
SQL Code | -1005022L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | No additional information available. |
| Error 1005023 | "Unmatched number of select list items in union" |
|---|---|
Constant | EMSG_UNMATCHED_SELECT_LISTS_IN_UNION |
SAP Sybase Error Number | 21073 |
SQL State | QTA23 |
SQL Code | -1005023L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | Cube message here |
| Error 1005024 | "Estimate number: %2 exceed the MAX_CUBE_RESULT of GROUP BY CUBE or ROLLUP %1" |
|---|---|
Constant | EMSG_EXCEED_MAX_CUBE_RESULT |
SAP Sybase Error Number | 21074 |
SQL State | QTA24 |
SQL Code | -1005024L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location |
Parameter 2 | the estimated total result of hash base cube |
Probable Cause | location of the exception the estimated total result of hash base cube or rollup |
| Error 1005025 | "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" |
|---|---|
Constant | EMSG_JOINS_TOO_COMPLEX |
SAP Sybase Error Number | 21089 |
SQL State | QTA25 |
SQL Code | -1005025L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | the user name specified |
Probable Cause | The query will take too long to optimize, so it is being rejected |
| Error 1005026 | "Update not supported on null supplying side of outer join." |
|---|---|
Constant | EMSG_UPDATE_NOT_ALLOWED_NULL_OUTER |
SAP Sybase Error Number | 21090 |
SQL State | QTA26 |
SQL Code | -1005026L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Probable Cause | No additional information available. |
| Error 1005027 | "An error occurs during unistring conversion - %2. %1" |
|---|---|
Constant | EMSG_UNILIB_ERR |
SAP Sybase Error Number | 21091 |
SQL State | QTA27 |
SQL Code | -1005027L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | the details of unilib error |
Probable Cause | No additional information available. |