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 |
|---|---|---|---|---|---|
| 40W09 | Error | 2973 | -1285L | "%1 -- Transaction rolled back" | This transaction has been rolled back because the server encountered an error during a critical operation. Click here for a list of possible parameters and odbc states. |
| 42501 | Error | 2066 | -121L | "Permission denied: %1" | You do not have the required permission to perform the specified action. The message specifies the actual permission required and the object being acted upon. Click here for a list of possible parameters and odbc states. |
| 42R01 | Error | 2496 | -849L | "Referential integrity actions other than RESTRICT not allowed for temporary tables" | You attempted to specify an unsupported referential integrity action for a temporary table. Click here for a list of possible parameters and odbc states. |
| 42R02 | Error | 2497 | -850L | "Tables related by key constraint must both be permanent, or both be temporary and not created with ON COMMIT DELETE ROWS. For global temporary tables they must both be shared if one is shared." | Tables involved in a key constraint relationship must both be permanent user tables or both be temporary tables not created with ON COMMIT DELETE ROWS. Change the definition of one or both tables using ALTER TABLE. Click here for a list of possible parameters and odbc states. |
| 42R03 | Error | 2515 | -865L | "Key constraint between temporary tables requires a primary key (not unique constraint)" | The key constraint between temporary tables requires a primary key (not a UNIQUE constraint) if the database uses combined indexes. Change the definition of the primary table using ALTER TABLE or rebuild the database. Click here for a list of possible parameters and odbc states. |
| 42R04 | Error | 2904 | -1226L | "Foreign key columns do not match the primary key or a uniqueness constraint in \"%1\No message | An attempt was made to create a foreign key, but the columns specified do not match the primary key or a uniqueness constraint for the referenced table. Click here for a list of possible parameters and odbc states. |
| 42U00 | Error | 2413 | -766L | "View references '%1', which is a temporary object. Views can only refer to permanent objects" | Views must refer only to permanent objects, not to temporary objects such as local temporary tables. Click here for a list of possible parameters and odbc states. |
| 42U01 | Error | 2471 | -824L | "Illegal reference to correlation name '%1'" | Your query contains a reference in a table expression to a correlation name that is not contained in that table expression. Click here for a list of possible parameters and odbc states. |
| 42U02 | Error | 2492 | -845L | "Owner '%1' used in a qualified column reference does not match correlation name '%2'" | Your query contains a qualified column reference to a table name, but either a correlation name has been used for that table, or the owner of the table does not match the owner name specified in the column reference. Remove the owner qualification, and qualify column references only by correlation name. Click here for a list of possible parameters and odbc states. |
| 42U03 | Error | 2493 | -846L | "SET clause for column '%1' used incorrectly" | Your UPDATE statement contains an invalid SET clause, for example, there are multiple SET clauses for the same column. Click here for a list of possible parameters and odbc states. |
| 42U04 | Error | 2593 | -929L | "Constraint '%1' not found" | You misspelled the name of a constraint, or the constraint you are looking for is on a different table. Click here for a list of possible parameters and odbc states. |
| 42U05 | Error | 2594 | -930 | No message | You have asked for an unnamed column constraint to be altered, but there is at least one named constraint. Click here for a list of possible parameters and odbc states. |
| 42U06 | Error | 2601 | -937L | "Invalid reference to or operation on constraint '%1'" | You specified an invalid operation on a constraint. For example, you tried to alter a primary key constraint. Click here for a list of possible parameters and odbc states. |
| 42U07 | Error | 2634 | -970L | "Invalid hint specified for table '%1'" | A hint was specified for the current statement is not valid in this context. In a single statement, all references to a table must specify the same hint or none at all. Click here for a list of possible parameters and odbc states. |
| 42U08 | Error | 2899 | -1221L | "Duplicate options not allowed in the CREATE DATABASE statement" | You have specified one of the options more than once when executing the CREATE DATABASE statement. Click here for a list of possible parameters and odbc states. |
| 42W01 | Error | 2065 | -120L | "User '%1' already has GRANT permission" | You attempted to give GRANT OPTION permission to a user that already has it. Click here for a list of possible parameters and odbc states. |
| 42W02 | Error | 2067 | -122L | "Operation would cause a group cycle" | You attempted to add a member to group that would result in a member belonging to itself. The membership may be direct or indirect. Click here for a list of possible parameters and odbc states. |
| 42W03 | Error | 2068 | -123L | "User '%1' is not a user group" | You attempted to add a member to group, but the user ID specified as a group has not been granted GROUP permission. Click here for a list of possible parameters and odbc states. |
| 42W04 | Error | 2071 | -131L | "Syntax error near '%1' %2" | The database server cannot understand the statement you are trying to execute. If you used a keyword (such as DATE) for a column name, try enclosing the keyword in quotation marks ("DATE"). Click here for a list of possible parameters and odbc states. |
| 42W05 | Error | 2091 | -148L | "Unknown function '%1'" | You misspelled the name of a database function (such as MAXIMUM instead of MAX) in a query definition or in a query column name. Click here for a list of possible parameters and odbc states. |