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 |
|---|---|---|---|---|---|
| 53023 | Error | 2094 | -151L | "Subquery allowed only one select list item" | You entered a subquery that has more than one column in the select list. Change the select list to have only one column. Click here for a list of possible parameters and odbc states. |
| 53026 | Error | 2096 | -153L | "Select lists in UNION, INTERSECT, or EXCEPT do not match in length" | You specified a UNION, INTERSECT, or EXCEPT but the SELECT statements involved in the operation do not have the same number of columns in the select list. Click here for a list of possible parameters and odbc states. |
| 53030 | Error | 2050 | -113L | "Column '%1' in foreign key has a different definition than primary key" | The data type of the column in the foreign key is not the same as the data type of the column in the primary key. Change the definition of one of the columns using ALTER TABLE. Click here for a list of possible parameters and odbc states. |
| 53W01 | Error | 2057 | -125L | "ALTER clause conflict" | A primary key clause, foreign key clause, or a uniqueness clause must be the only clause of an ALTER TABLE statement. Click here for a list of possible parameters and odbc states. |
| 53W02 | Error | 2121 | -190L | "Cannot update an expression" | You tried to update a column in a query that is a database expression rather than a column in a table. Click here for a list of possible parameters and odbc states. |
| 53W04 | Error | 2086 | -146L | "There is no way to join '%1' to '%2'" | You may have attempted a KEY JOIN between two tables and there is no foreign key on one of the tables that references the primary key of the other table. You may have attempted a NATURAL JOIN between two tables that have no common column names. Click here for a list of possible parameters and odbc states. |
| 53W05 | Error | 2059 | -127L | "Cannot alter a column in an index" | You may have attempted to delete or modify the definition of a column that is part of a primary or foreign key. You may have attempted to delete a column that has an index on it. In this case, DROP the index or key, perform the ALTER statement, and then add the index or key again. Click here for a list of possible parameters and odbc states. |
| 53W06 | Error | 2148 | -269L | "Cannot delete or rename a column referenced in a trigger definition" | You attempted to delete or rename a column referenced in a trigger definition. Drop the trigger before performing the ALTER statement. Click here for a list of possible parameters and odbc states. |
| 53W07 | Error | 2165 | -296L | "Error number %1 for RAISERROR must not be less than 17000" | You supplied an invalid error number in a RAISERROR statement. The number must be greater than or equal to 17000. Click here for a list of possible parameters and odbc states. |
| 53W08 | Error | 2166 | -294L | "Format string argument number %1 is invalid" | You supplied an invalid argument number in the format string for a PRINT or RAISERROR statement. The number must be between 1 and 20 and must not exceed the number of arguments provided. Click here for a list of possible parameters and odbc states. |
| 53W09 | Error | 2218 | -609L | "Invalid data type for column in WRITETEXT or READTEXT" | You referenced a column in a WRITETEXT or READTEXT statement that is not defined for storing text or image data. Click here for a list of possible parameters and odbc states. |
| 54003 | Error | 2061 | -250L | "Identifier '%1' too long" | An identifier was specified is longer than 128 bytes. Click here for a list of possible parameters and odbc states. |
| 54W01 | Error | 2553 | -890L | "Statement size or complexity exceeds server limits" | The statement contains one or more constructs whose size make it impossible to process. Increasing the maximum cache size, page size, or stack size may resolve this error. Consider rewriting the query so that the internal limit is not exceeded. For example, if the query contains a large IN-list, consider inserting the IN-list's values into a temporary table. Then rewrite the query to join this temporary table to the other table(s) in the original statement. Click here for a list of possible parameters and odbc states. |
| 54W02 | Error | 2600 | -936L | "Too many constraints in database" | An attempt to create a new constraint failed because the corresponding system table is full. Reloading the database will reclaim any unused space. Click here for a list of possible parameters and odbc states. |
| 54W03 | Error | 2638 | -972L | "Database page size too small: %1" | You attempted to load statistics that were too large for the current database page size. Rebuilding this database with a larger page size could prevent this error. Click here for a list of possible parameters and odbc states. |
| 54W04 | Error | 2659 | -992L | "The specified listener could not be registered" | The specified listener could not be registered because the maximum number of listeners has been reached, the class name is already in use, or system resources are not available. Click here for a list of possible parameters and odbc states. |
| 54W05 | Error | 2668 | -1000L | "Temporary space limit exceeded" | The connection has exceeded its temporary-space usage limit. This limit is based in part on the amount of free-space remaining on the drive containing the temporary file. Try deleting unused files from the drive, or placing the temporary file on a drive with more space available. See the -dt server option to specify a directory for temporary files. Click here for a list of possible parameters and odbc states. |
| 54W06 | Error | 2639 | -973L | "The string is too long (%1)" | The string is longer than that allowed by the server. Click here for a list of possible parameters and odbc states. |
| 54W07 | Error | 2383 | -738L | "Password must be at least %1 characters" | The password is shorter than that allowed by the current min_password_length option setting. Click here for a list of possible parameters and odbc states. |
| 54W08 | Error | 2622 | -958L | "Password cannot be longer than %1 characters" | The password is longer than that allowed by the server. Click here for a list of possible parameters and odbc states. |