Messages on this page are sorted by Sybase error code. Locate the appropriate code for a full description of the message.
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. |
Error 1005028 | "Syntax error - %2. %1" |
---|---|
Constant | EMSG_SYNTAX_ERROR |
SAP Sybase Error Number | 21092 |
SQL State | QTA28 |
SQL Code | -1005028L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | the details of syntax error |
Probable Cause | No additional information available. |
Error 1005029 | "You cannot SELECT from a join virtual table. (%2) %1" |
---|---|
Constant | EMSG_CANNOT_SELECT_FROM_JVT |
SAP Sybase Error Number | 21143 |
SQL State | QTA29 |
SQL Code | -1005029L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | location of the exception |
Parameter 2 | the details of the syntax error |
Probable Cause | No additional information available. |
Error 1005030 | "Query has an ambiguous table reference between prepare and open cursor (%2). %1" |
---|---|
Constant | EMSG_INCONSISTENT_TABLES |
SAP Sybase Error Number | 21145 |
SQL State | QTA30 |
SQL Code | -1005030L |
ODBC 2 State | ERROR |
ODBC 3 State | ERROR |
Severity Code | |
Parameter 1 | Location of the exception. |
Parameter 2 | table name |
Probable Cause | SA allows a base and temp table to both have the same table name. In some places, such as when a temp table is created in a stored procedure between the describe and open, IQ can find the base table in the describe and the temp table in the open, giving inconsistent results. |