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 |
|---|---|---|---|---|---|
| 42W86 | Error | 2785 | -1114L | "Invalid setting for SOAP header '%1'" | You supplied an invalid value for a SOAP header. Click here for a list of possible parameters and odbc states. |
| 42W90 | Error | 2570 | -904L | "Illegal ORDER BY in aggregate function" | An ORDER BY can be used in an aggregate function only if there are no DISTINCT aggregates in the select list, or there is a single DISTINCT aggregate with the DISTINCT column equal to the first column of the ORDER BY. Also, multiple ordered aggregates cannot be used in the same select list unless they have the exact same ORDER BY clause. Click here for a list of possible parameters and odbc states. |
| 42W91 | Error | 2578 | -913L | "A transaction log file is required for auditing" | This database is running without a transaction log file. You must use the Transaction Log utility (dblog) to create a transaction log file before using auditing. Click here for a list of possible parameters and odbc states. |
| 42W92 | Error | 2580 | -915L | "Service type required for CREATE SERVICE" | The CREATE SERVICE statement requires a service type to be specified. Click here for a list of possible parameters and odbc states. |
| 42W93 | Error | 2579 | -914L | "Cycle in common table expression references" | Cycles involving multiple common table expressions are not allowed. Click here for a list of possible parameters and odbc states. |
| 42W94 | Error | 2581 | -916L | "'%1' is an unrecognized service type" | An unrecognized service type was specified. Click here for a list of possible parameters and odbc states. |
| 42W95 | Error | 2589 | -925L | "Invalid service name '%1'" | You have attempted to create a service with an invalid name. The name may contain characters that are not allowed, or it may conflict with the URL PATH setting specified for the service. Click here for a list of possible parameters and odbc states. |
| 42W96 | Error | 2583 | -918L | "A user name must be specified if AUTHORIZATION is Off" | A valid user name must be specified if AUTHORIZATION is Off. Click here for a list of possible parameters and odbc states. |
| 42W97 | Error | 2584 | -919L | "Service '%1' already exists" | You have attempted to create a service with a name that already exists in the database. Click here for a list of possible parameters and odbc states. |
| 42W98 | Error | 2585 | -920L | "Service '%1' not found" | You have attempted to reference a service with a name that does not exist in the database. Click here for a list of possible parameters and odbc states. |
| 42W99 | Error | 2586 | -921L | "Invalid recursive query" | A recursive query must consist of the UNION ALL of an initial query and an iteration query. The only set operation allowed in the iteration query is UNION ALL. A recursive reference to the name of the common table expression can only appear in the iteration query, and must not be in a SELECT that uses DISTINCT, ORDER BY, or an aggregate function. A recursive reference also cannot appear on the NULL-supplying side of an outer join, or in a subquery. Click here for a list of possible parameters and odbc states. |
| 42W9A | Error | 2587 | -922L | "No column list for recursive query" | A common table expression defining a recursive query must have a column list. Click here for a list of possible parameters and odbc states. |
| 42W9B | Error | 2590 | -926L | "Host variable reference in service definition must be named" | You have attempted to create a service with an unnamed host variable reference. Click here for a list of possible parameters and odbc states. |
| 42W9C | Error | 2591 | -927L | "Service statement definition is inconsistent with service type" | Either no statement was provided for a service whose type requires one, or a statement was provided when the service type does not allow one to be defined. Click here for a list of possible parameters and odbc states. |
| 42W9D | Error | 2592 | -928L | "Constant expressions must not appear in GROUP BY clause" | You used a constant in the GROUP BY clause. Constants must not appear in the GROUP BY clause for a query. References to columns in a view that are constant are permitted in a GROUP BY clause. Also, expressions that use a view column that is constant are permitted. Click here for a list of possible parameters and odbc states. |
| 42W9E | Error | 2595 | -931L | "Service definition requires a statement when authorization is off" | The service definition for the specified service type requires a statement to be specified when authorization is set to Off. Click here for a list of possible parameters and odbc states. |
| 42WA0 | Error | 2602 | -938L | "Recursion is not allowed without the RECURSIVE keyword" | The common table expressions for a recursive query must be defined using a WITH RECURSIVE clause. Click here for a list of possible parameters and odbc states. |
| 42WA1 | Error | 2608 | -944L | "Too many expressions in GROUP BY list for ROLLUP, CUBE, or GROUPING SETS operation" | You specified too many expressions in the GROUP BY list for the requested ROLLUP, CUBE, or GROUPING SETS operation. The current environment where SQL Anywhere is executing cannot support this number of expressions in the GROUP BY list for the requested operation. Click here for a list of possible parameters and odbc states. |
| 42WA2 | Error | 2609 | -945L | "Recursive column %1: conversion from '%2' to '%3' loses precision" | Every column in the recursive subquery must be convertible to the type of the corresponding column in the initial subquery without loss of precision. Try casting the column in the initial subquery to an appropriate type. Click here for a list of possible parameters and odbc states. |
| 42WA3 | Error | 2611 | -947L | "Window '%1' not found" | You have attempted to reference a window name that is not defined in the window list of the SELECT statement. Click here for a list of possible parameters and odbc states. |