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 |
|---|---|---|---|---|---|
| 55W08 | Error | 2404 | -757L | "Modifications not permitted for read-only database" | You attempted an update operation on a database that was declared as read-only. Click here for a list of possible parameters and odbc states. |
| 55W09 | Error | 2447 | -800 | "Cannot commit or rollback while enlisted in a transaction" | You tried to explicitly commit or rollback on a connection that is enlisted in a transaction. You must use the Commit/Abort protocol of the transaction instead. Click here for a list of possible parameters and odbc states. |
| 55W10 | Error | 2448 | -801L | "Cannot enlist in a transaction while already enlisted in a transaction" | You tried to enlist a second transaction on a connection that is already enlisted in a transaction. Click here for a list of possible parameters and odbc states. |
| 55W11 | Error | 2449 | -802L | "Cannot enlist in a transaction with uncommitted data pending" | You tried to enlist a transaction on a connection that has pending uncommitted data. Click here for a list of possible parameters and odbc states. |
| 55W12 | Error | 2843 | -1167L | "Cannot drop a user that owns text configurations" | You attempted to drop a user that is the creator of a text configuration. The text configuration must be dropped first. Click here for a list of possible parameters and odbc states. |
| 55W13 | Error | 2525 | -688L | "Strongly-encrypted database files are not supported in the runtime server" | You attempted to start a strongly-encrypted database with the runtime server. Use the full server. Click here for a list of possible parameters and odbc states. |
| 55W14 | Error | 2574 | -908L | "Invalid operation on a closed object" | An illegal attempt was made to access a closed UltraLite object. Click here for a list of possible parameters and odbc states. |
| 55W15 | Error | 2582 | -924L | "Service '%1' in use" | You have attempted to drop a service that is currently in use. Click here for a list of possible parameters and odbc states. |
| 55W16 | Error | 2706 | -1037L | "Cannot drop or modify object '%1' because at least one other object ( %2 '%3') depends upon it" | You attempted to drop or modify an object, such as a table or a column, that is used by another object, such as a materialized view, that cannot be automatically invalidated. The dependent object must be disabled or dropped before a drop or modification can be permitted. Click here for a list of possible parameters and odbc states. |
| 55W17 | Error | 2707 | -1038L | "Cannot use view '%1' because it has been disabled" | You attempted to reference a view that has been disabled. The view must be enabled before it can be used again. Click here for a list of possible parameters and odbc states. |
| 55W18 | Error | 2709 | -1040L | "Cannot use view '%1' because it is invalid" | You attempted to reference an invalid view. The view must be enabled before it can be used again. Click here for a list of possible parameters and odbc states. |
| 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. |