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 |
|---|---|---|---|---|---|
| 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. |
| 42WC6 | Error | 2876 | -1199L | "The materialized view cannot be changed to immediate because COUNT(*) is required to be part of the SELECT list." | You attempted to change the refresh type to immediate for a materialized view whose definition does not include COUNT(*) in the SELECT list. Click here for a list of possible parameters and odbc states. |
| 42WC7 | Error | 2896 | -1218L | "The materialized view cannot be changed to immediate because it does not have a unique index on non-aggregate non-nullable columns" | You attempted to change the refresh type to immediate for a materialized view which does not have a unique index on non-aggregate non-nullable columns. Create a unique index on the materialized view before changing the refresh type. Click here for a list of possible parameters and odbc states. |
| 42WC8 | Error | 2897 | -1219L | "Maintenance of dependent immediate materialized view(s) failed" | Maintenance of immediate materialized view(s) dependent on the base table failed. Click here for a list of possible parameters and odbc states. |
| 42WC9 | Error | 2911 | -1232L | "Attempt to start a second snapshot in a transaction" | A transaction tried to start a snapshot (e.g., see BEGIN SNAPSHOT statement) while another snapshot was already active. Click here for a list of possible parameters and odbc states. |
| 42WCA | Error | 2912 | -1233L | "The materialized view %1 cannot be changed to immediate because it does not have a unique index on non-nullable columns." | You attempted to change the refresh type to immediate for a materialized view which does not have a unique index on non-nullable columns. Create a unique index on the materialized view before changing the refresh type. Click here for a list of possible parameters and odbc states. |
| 42WCB | Error | 2955 | -1268L | "The materialized view cannot be changed to immediate because its definition contains an illegal construct." | You attempted to change the refresh type to immediate for a materialized view whose definition contains an illegal construct. Click here for a list of possible parameters and odbc states. |