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 |
|---|---|---|---|---|---|
| 42W66 | Error | 2503 | -855L | "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. |
| 42W67 | Error | 2506 | -858L | "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. |
| 42W68 | Error | 2510 | -861L | "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. |
| 42W69 | Error | 2511 | -862L | "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. |
| 42W70 | Error | 2512 | -863L | "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. |
| 42W71 | Error | 2514 | -864L | "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. |
| 42W72 | Error | 2907 | -1228L | "Syntax error, cannot specify IQ specific options (%1) when creating a table in an SA database" | An attempt was made to use IQ specific create table syntax when creating a table in an SA database Click here for a list of possible parameters and odbc states. |
| 42W73 | Error | 2527 | -875L | "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. |
| 42W74 | Error | 2535 | -878L | "Index '%1' can not be clustered" | You attempted to create a clustered index (including key indexes) but the new index cannot be created, for example, because the table already has a clustered index. Click here for a list of possible parameters and odbc states. |
| 42W75 | Error | 2895 | -1217L | "Synchronization profile '%1' not found" | You tried to access a synchronization profile that the database could not find. Click here for a list of possible parameters and odbc states. |
| 42W76 | Error | 2901 | -1223L | "Synchronization profile '%1' already exists" | You tried to create a synchronization profile that already exists. Click here for a list of possible parameters and odbc states. |
| 42W77 | Error | 2902 | -1224L | "Synchronization profile '%1' has invalid parameter '%2'" | You tried to create or alter a synchronization profile using a string containing an invalid parameter setting. Click here for a list of possible parameters and odbc states. |
| 42W78 | Error | 2903 | -1225L | "Synchronization profiles are not supported for this database" | The current database does not have catalog support for synchronization profiles. To use this feature, upgrade your database to the most recent version. Click here for a list of possible parameters and odbc states. |
| 42W79 | Error | 2551 | -889L | "Statement contains an illegal usage of the non-deterministic function '%1'" | Non-deterministic functions cannot appear in a CHECK constraint, or any other type of integrity constraint. They may appear anywhere within a query, view, or derived table. However, if an aliased select list expression contains a non-determinstic function, that alias cannot be referred to elsewhere in the query. Click here for a list of possible parameters and odbc states. |
| 42W7A | Error | 2913 | -1234L | "Dbspace file with name or path ( %1 ) already exist " | Error code to use for catalog update errors in IQ code. Click here for a list of possible parameters and odbc states. |
| 42W80 | Error | 2968 | -1281L | "Another connection has the row in '%1' locked" | You attempted modify or delete a row that is locked by another connection. The row will be unlocked once that connection commits or rolls back. Click here for a list of possible parameters and odbc states. |
| 42W82 | Error | 2560 | -896L | "Cannot delete PUBLIC option '%1' since user settings exist" | You tried to delete a PUBLIC option, but there are user settings for the same option. The user settings must be deleted before the PUBLIC option is deleted. Click here for a list of possible parameters and odbc states. |
| 42W83 | Error | 2603 | -939L | "Invalid setting for HTTP option '%1'" | You supplied an invalid value for an HTTP option. Some options allow only numeric values, while other options allow only the values On and Off. Click here for a list of possible parameters and odbc states. |
| 42W84 | Error | 2604 | -940L | "Invalid setting for HTTP header '%1'" | You supplied an invalid value for an HTTP header. Click here for a list of possible parameters and odbc states. |
| 42W85 | Error | 2722 | -1053L | "'%1' is an invalid value for '%2'" | You supplied an invalid value for an option. Some options only allow numeric values and some options only allow true or false. Also, many options do not permit the empty string as a value. Click here for a list of possible parameters and odbc states. |