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 |
|---|---|---|---|---|---|
| -854L | Error | 2502 | 42W65 | "Function or column reference to '%1' in the ORDER BY clause is invalid" | You specified a function or column reference in the ORDER BY clause that is semantically invalid. For example, for DISTINCT queries the ORDER BY clause may only refer to items in the query's SELECT list. Click here for a list of possible parameters and odbc states. |
| -855L | Error | 2503 | 42W66 | "Trigger name '%1' is ambiguous" | A statement has referred to a trigger name that is not unique. Qualify the trigger name with the table and/or owner name. Click here for a list of possible parameters and odbc states. |
| -856L | Error | 2504 | 07W08 | "Invalid sqllen field in SQLDA" | An invalid length was specified in a SQLDA sqllen field. All variable length types must have a non-negative length. The DT_BINARY and DT_VARCHAR types must have length greater than one. Click here for a list of possible parameters and odbc states. |
| -857L | Error | 2505 | 0AW12 | "Synchronization failed due to an error on the server: %1" | Synchronization failed at the server. More details can be found in the synchronization log file. Click here for a list of possible parameters and odbc states. |
| -858L | Error | 2506 | 42W67 | "CREATE/DROP STATISTICS statement cannot refer to virtual tables" | You attempted to use CREATE/DROP STATISTICS to create/drop one or more histograms on a virtual database object, such as a view or remote table. The CREATE STATISTICS and DROP STATISTICS statements can only refer to base tables, local temporary tables, or global temporary tables in the SQL Anywhere database that you are connected to. Click here for a list of possible parameters and odbc states. |
| -860L | Error | 2509 | WW028 | "At least one of the specified dbspaces was not calibrated" | You attempted to calibrate a dbspace that was not open or was too small. Click here for a list of possible parameters and odbc states. |
| -861L | Error | 2510 | 42W68 | "Aggregated expression '%1' contains multiple columns of which one or more are outer references" | A subselect within the nested query contains an aggregate function whose parameters include an outer reference. In such cases, the outer reference must be the only column referenced in the expression. Click here for a list of possible parameters and odbc states. |
| -862L | Error | 2511 | 42W69 | "The aggregate expression '%1' must appear in either the SELECT list or a HAVING clause subquery" | An aggregated expression containing an outer reference must either appear in a SELECT list expression (a subselect), or in a HAVING clause subquery in the query whose FROM clause contains the table with the column being aggregated. Click here for a list of possible parameters and odbc states. |
| -863L | Error | 2512 | 42W70 | "Grouped query contains more than one distinct aggregate function" | Two or more DISTINCT aggregate functions were specified in the same grouped query. This is only permitted if the Hash Group By operator is available. Any query block can only contain at most one DISTINCT aggregate function if the Hash Group By operator is not available. Click here for a list of possible parameters and odbc states. |
| -864L | Error | 2514 | 42W71 | "Statement contains an illegal usage of the NUMBER(*) function" | The NUMBER and IDENTITY functions can only appear in the SELECT list of the outer-most SELECT block. It cannot be used in any subquery or in a predicate. Click here for a list of possible parameters and odbc states. |
| -865L | Error | 2515 | 42R03 | "Key constraint between temporary tables requires a primary key (not unique constraint)" | The key constraint between temporary tables requires a primary key (not a UNIQUE constraint) if the database uses combined indexes. Change the definition of the primary table using ALTER TABLE or rebuild the database. Click here for a list of possible parameters and odbc states. |
| -866L | Error | 2516 | WP012 | "%1 returned a result set with a different schema than expected" | When calling a procedure in the FROM clause of a SELECT statement, the expected schema of the result is taken from the WITH clause. If no WITH clause is given, the expected schema is taken from the system catalog. The result set returned from the call must match the expected schema or it must be possible to convert every column so that it matches. Click here for a list of possible parameters and odbc states. |
| -867L | Error | 2517 | 0AW13 | "Cannot change synchronization user_name when status of the last upload is unknown" | The MobiLink server uses the user_name to track synchronizations. If the status of the previous upload is unknown then you must resolve this condition before changing the user. Click here for a list of possible parameters and odbc states. |
| -868L | Error | 2518 | WC001 | "'%1' is an unknown character set encoding label" | The specified character set label is not recognized, so conversion from/to that character set is not possible. Click here for a list of possible parameters and odbc states. |
| -869L | Error | 2519 | 08W64 | "Database server cannot convert data from/to character set '%1'" | The database server cannot convert character data from/to the character set requested by the application because the character set is not supported. The connection fails. Click here for a list of possible parameters and odbc states. |
| -870L | Error | 2520 | WC002 | "Cannot convert between requested character set '%1' and database character set '%2'" | The server is unable to convert between the connection character set that was specified and the database character set. This could happen when the dbicu and dbicudt DLLs are not installed. Click here for a list of possible parameters and odbc states. |
| -872L | Error | 2522 | WP014 | "%1 does not return a result set" | A procedure called in the FROM clause of a SELECT statement must return a result set. Click here for a list of possible parameters and odbc states. |
| -873L | Error | 2523 | WP013 | "%1 returned multiple result sets" | A procedure called in the FROM clause of a SELECT statement cannot return multiple result sets. Click here for a list of possible parameters and odbc states. |
| -874L | Error | 2526 | WX001 | "Column must be named: %1" | Unnamed columns cannot be used as XML element or attribute names. Name unnamed columns in the SELECT list using AS. Click here for a list of possible parameters and odbc states. |
| -875L | Error | 2527 | 42W73 | "There is no way to join to '%1'" | The server cannot discover a valid join condition involving this table. If the join is an outer join, you may be missing an ON clause. If the join is a KEY JOIN, the server cannot discover a foreign key-primary key relationship with this table that can be used to generate the join condition. If the join is a NATURAL JOIN, the table has no common column names with the table expression it is being joined to. Click here for a list of possible parameters and odbc states. |