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 |
|---|---|---|---|---|---|
| 55W19 | Error | 2715 | -1046L | "Illegal column definition: %1" | You are attempting to define a column in a way that is not allowed. Click here for a list of possible parameters and odbc states. |
| 55W20 | Error | 2716 | -1047L | "This database does not support encrypted tables" | You tried to create an encrypted table in a database that does not support them. Click here for a list of possible parameters and odbc states. |
| 55W21 | Error | 2861 | -1184L | "Cannot drop last unique index of an immediate materialized view" | You attempted to drop the last unique index on non-nullable columns of an immediate materialized view. Immediate materialized view needs at least one unique index on non-nullable columns in order to be valid. Click here for a list of possible parameters and odbc states. |
| 55W23 | Error | 2723 | -1054L | "Snapshot isolation disabled or pending" | Snapshot isolation is disabled or its activation is still pending. You must enable snapshot isolation before using it. Click here for a list of possible parameters and odbc states. |
| 55W24 | Error | 2750 | -1081L | "Could not refresh tracing: at least one enabled tracing level must be specified" | Table sa_diagnostic_tracing_level contains no rows (tracing levels) or no tracing levels are enabled. Click here for a list of possible parameters and odbc states. |
| 55W25 | Error | 2769 | -1099L | "Transact-SQL outer joins are currently disabled" | The ability to specify a Transact-SQL outer join in a query is currently disabled by the setting of the tsql_outer_joins connection option. Transact-SQL outer joins are deprecated in this release of SQL Anywhere. Click here for a list of possible parameters and odbc states. |
| 55W26 | Error | 2792 | -1120L | "The dbspace '%1' cannot be dropped because it contains tables or indexes" | You attempted to drop the named dbspace, but it contains tables or indexes. You must drop the tables and/or indexes before dropping the dbspace. Click here for a list of possible parameters and odbc states. |
| 55W27 | Error | 2816 | -1143L | "Encryption has not been enabled." | You attempted to use encryption without first enabling it. Call ULEnableStrongEncryption to enable encryption. Click here for a list of possible parameters and odbc states. |
| 55W28 | Error | 2830 | -1154L | "Traced query (%1, %2) does not exist" | You attempted to generate a graphical plan for a query saved by diagnostic tracing, identified by a logging_session_id and query id. However, no such query exists in this database. If it was traced, it was sent to a different database. Click here for a list of possible parameters and odbc states. |
| 55W29 | Error | 2869 | -1192L | "Cannot update multiple tables immediate materialized view %1 depends on" | You attempted to simultaneously update two or more tables initialized immediate materialized view depends on. No more than one base table an immediate materialized view depends on can be updated in a statement. Click here for a list of possible parameters and odbc states. |
| 55W30 | Error | 2870 | -1193L | "TRUNCATE TABLE not allowed: initialized immediate materialized view %1 depends on %2" | TRUNCATE TABLE is not permitted on any table that has dependent initialized immediate materialized views. Click here for a list of possible parameters and odbc states. |
| 55W31 | Error | 2879 | -1202L | "Operation not allowed on a table with dependent immediate materialized views" | Requested operation cannot be applied to a table with dependent immediate materialized views. Click here for a list of possible parameters and odbc states. |
| 55W32 | Error | 2880 | -1203L | "WRITETEXT not allowed: immediate materialized view %1 depends on %2" | WRITETEXT is not allowed on base tables that have dependent initialized immediate materialized views. No operation that does not fire triggers is allowed on base tables with dependent initialized immediate materialized views. Click here for a list of possible parameters and odbc states. |
| 55W33 | Error | 2881 | -1204L | "INSERT ... ON EXISTING UPDATE not allowed: immediate materialized view %1 depends on %2" | Insert statement with ON EXISTING clause is not permitted on a base table if the base table has dependent initialized immediate materialized view. Click here for a list of possible parameters and odbc states. |
| 55W34 | Error | 2963 | -1276L | "Configuration cannot not be modified while in use" | You attempted to modify a configuration object that is in use by an open connection. Click here for a list of possible parameters and odbc states. |
| 55W35 | Error | 2975 | -1287L | "Operation not allowed on global temporary table %1 as it is in use.Please reconnect and try again." | A global temporary table cannot be modified if it is in use. User must reconnect and reexecute the command. Click here for a list of possible parameters and odbc states. |
| 56001 | Error | 2304 | -677L | "Table '%1' has a foreign key with a referential action" | The table could not be renamed as it has a foreign key with a referential action. To rename the table, first drop the foreign key constraints. Click here for a list of possible parameters and odbc states. |
| 57014 | Error | 2188 | -299L | "Statement interrupted by user" | You canceled a statement during its execution. The database was able to stop the operation without doing a rollback. If the statement is INSERT, UPDATE, or DELETE, any changes made by the statement will be canceled. If the statement is a data definition statement (for example CREATE TABLE), the statement will be canceled, but the COMMIT that was done as a side effect will not be canceled. Click here for a list of possible parameters and odbc states. |
| 57015 | Error | 2588 | -923L | "Too many recursive iterations" | A recursive query ran for more iterations than allowed by the current max_recursive_iterations option setting. Click here for a list of possible parameters and odbc states. |
| 57W01 | Error | 2712 | -1043L | "Request interrupted due to timeout" | The current request was canceled during its execution since it ran for longer than the request_timeout database option value. The database was able to stop the operation without doing a rollback. If the statement is INSERT, UPDATE, or DELETE, any changes made by the statement will be canceled. If the statement is a data definition statement (for example CREATE TABLE), the statement will be canceled, but the COMMIT that was done as a side effect will not be canceled. Click here for a list of possible parameters and odbc states. |