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 |
|---|---|---|---|---|---|
| 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 ULEnableAesDBEncryption or ULEnableAesFipsDBEncryption 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. Reconnect and try again." | A global temporary table cannot be modified if it is in use. The user must reconnect and re-execute the statement. 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 an 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 an 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. |
| 57W02 | Error | 2753 | -1084L | "Use of feature '%1' is not allowed" | You have attempted to use a feature that was disabled by the server administrator when the database server was started. Click here for a list of possible parameters and odbc states. |
| 57W03 | Error | 2793 | -1121L | "Not enough free space on device to grow dbspace '%1' by requested amount" | You attempted to grow a dbspace using the ALTER DBSPACE statement, but there is not enough free space on the device to grow by the amount specified. Click here for a list of possible parameters and odbc states. |
| 57W04 | Error | 2815 | -1142L | "Use of statement '%1', which requires feature '%2', is not allowed" | You have attempted to use a statement which requires a feature that was disabled by the server administrator when the database server was started. Click here for a list of possible parameters and odbc states. |