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 |
|---|---|---|---|---|---|
| 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. |
| 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. |
| 57W05 | Error | 2910 | -1231L | "Statement timed out: '%1!s!'" | The statement failed because it did not complete within the allotted or specified time. Click here for a list of possible parameters and odbc states. |
| 5RW01 | Error | 2155 | -280L | "Publication '%1' not found" | You misspelled the name of a publication, or you did not qualify a publication name with a user name. Click here for a list of possible parameters and odbc states. |
| 5RW02 | Error | 2156 | -281L | "Table '%1' has publications" | You attempted to drop a table that has publications defined. Click here for a list of possible parameters and odbc states. |
| 5RW03 | Error | 2157 | -282L | "Subscription to '%1' for '%2' already exists" | You attempted to create a subscription that already exists. Click here for a list of possible parameters and odbc states. |
| 5RW04 | Error | 2158 | -283L | "Subscription to '%1' for '%2' not found" | You attempted to drop, start, or synchronize a subscription that does not exist. Click here for a list of possible parameters and odbc states. |
| 5RW05 | Error | 2159 | -284L | "User '%1' is already the publisher for this database" | You attempted to GRANT PUBLISH to a user ID, when a publisher already exists. Click here for a list of possible parameters and odbc states. |