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 |
|---|---|---|---|---|---|
| 42WB2 | Error | 2696 | -1027L | "Service type does not allow '%1' attribute" | The service definition for the specified service type does not allow the given attribute to be specified Click here for a list of possible parameters and odbc states. |
| 42WB3 | Error | 2700 | -1031L | "Syntax error near '%1' -- Materialized view definition must not use the following construct: '%2'" | You attempted to create a materialized view whose definition violates one of the restrictions. Click here for a list of possible parameters and odbc states. |
| 42WB4 | Error | 2701 | -1032L | "Syntax error near '%1' -- The materialized view cannot be changed to immediate because its definition contains an illegal construct: '%2'" | You attempted to change the refresh type to immediate for a materialized view whose definition violates one of the restrictions. Click here for a list of possible parameters and odbc states. |
| 42WB5 | Error | 2710 | -1041L | "Materialized View '%1' not found" | You misspelled the name of a materialized view, or you did not qualify a materialized view name with a user name. For example, you might have referred to "Employees" instead of "DBA"."Employees". Click here for a list of possible parameters and odbc states. |
| 42WB6 | Error | 2720 | -1051L | "Cannot create a materialized view because option '%1' has an inappropriate setting" | You attempted to create a materialized view, but one of the database options is currently set to a value not permitted while creating a materialized view. Click here for a list of possible parameters and odbc states. |
| 42WB7 | Error | 2721 | -1052L | "Cannot update materialized view because option '%1' has an inappropriate setting" | You attempted to update/refresh a materialized view but one of the database options is currently set to a value that is not permitted while updating a materialized view, or, the option's setting does not match the value when the view was created. Click here for a list of possible parameters and odbc states. |
| 42WB8 | Error | 2730 | -1061L | "Table created or altered after start of snapshot" | A snapshot transaction attempted to use a table that was created or altered after the transaction began. Click here for a list of possible parameters and odbc states. |
| 42WB9 | Error | 2731 | -1062L | "Statement not allowed during snapshot" | A connection with an outstanding snapshot attempted to use CREATE INDEX, DROP INDEX, ALTER INDEX or ALTER TABLE. Make sure all cursors for the connection are closed. Click here for a list of possible parameters and odbc states. |
| 42WBA | Error | 2733 | -1064L | "Update conflict on snapshot transaction" | A snapshot transaction attempted to update or delete a row that was changed by another transaction after the snapshot began. Click here for a list of possible parameters and odbc states. |
| 42WBB | Error | 2734 | -1065L | "Attempt to use snapshot isolation in a non-snapshot transaction" | A transaction tried to use snapshot isolation but did not begin with snapshot isolation. Click here for a list of possible parameters and odbc states. |
| 42WBC | Error | 2746 | -1077L | "Cannot use materialized view '%1' because it has not yet been initialized" | You attempted to use a materialized view but it has not yet been initialized. In order for a materialized view to become available for first use after being created or enabled, it must be initialized at least once using the REFRESH MATERIALIZED VIEW statement. Click here for a list of possible parameters and odbc states. |
| 42WBD | Error | 2747 | -1078L | "Cycle in computed column dependencies" | The table has a cycle in the dependencies between its computed columns. Cycles are not allowed. Click here for a list of possible parameters and odbc states. |
| 42WBE | Error | 2749 | -1080L | "Cannot revoke these permissions while user '%1' is actively replicating transactions" | You attempted to revoke permissions from a user while there are transactions currently being replicated for that user. This is not allowed. Click here for a list of possible parameters and odbc states. |
| 42WBF | Error | 2784 | -1113L | "Correlation name '%1' is not valid for use with the ROWID function" | The correlation name used was not valid for the ROWID function. Only the correlation names of base tables, temporary tables, global temporary tables or proxy tables may be used with the ROWID function. The argument of a ROWID function should not refer to a view, derived table, common table expression, or a procedure. Click here for a list of possible parameters and odbc states. |
| 42WC0 | Error | 2754 | -1085L | "Duplicate key column (%1)" | You supplied a duplicate column name in the list of columns for the key of a primary key, foreign key, or unique constraint, or an index. Click here for a list of possible parameters and odbc states. |
| 42WC1 | Error | 2786 | -1115L | "Table '%1' contains an invalid reference to the ROWID function" | The ROWID function cannot be used in a computed column expression or in a CHECK constraint. Click here for a list of possible parameters and odbc states. |
| 42WC2 | Error | 2791 | -1119L | "The '%1' property is no longer supported" | The specified property is not supported in the current release. Click here for a list of possible parameters and odbc states. |
| 42WC3 | Error | 2847 | -1170L | "The materialized view %1 cannot be changed to immediate because it has already been initialized" | You attempted to change the refresh type to immediate for a materialized view which is already in an initialized state. Truncate the view before changing the refresh type. Click here for a list of possible parameters and odbc states. |
| 42WC4 | Error | 2852 | -1175L | "Unable to acquire table locks in specified time" | The LOCK TABLE command could not acquire all the locks in specified time period Click here for a list of possible parameters and odbc states. |
| 42WC5 | Error | 2858 | -1181L | "The materialized view cannot be changed to immediate because its definition must not contain more than one query block" | You attempted to change the refresh type to immediate for a materialized view whose definition contains more than one query block. Click here for a list of possible parameters and odbc states. |