Messages on this page are sorted by SQLCODE. Locate the appropriate code in the table below, and click the link for a full description of the message.
| SQL Code | Msg Type | Number | SQL State | Message | Possible Cause |
|---|---|---|---|---|---|
| -1028L | Error | 2697 | WB014 | "Connection attempting BACKUP has uncommitted transactions" | A connection attempting to perform a BACKUP...WAIT BEFORE START or BACKUP...WAIT AFTER END has uncommitted transactions. A COMMIT or ROLLBACK must be performed before executing the backup. Click here for a list of possible parameters and odbc states. |
| -1029L | Error | 2698 | 0AW15 | "Support for materialized views is not available for this database" | The statement being executed requires support for materialized views, but the database being used does not have the materialized view capability. Click here for a list of possible parameters and odbc states. |
| -1030L | Error | 2699 | WW063 | "Secure HTTP connections are not supported on this platform" | A Secure HTTP connection was attempted, but is not supported on this platform. Click here for a list of possible parameters and odbc states. |
| -1031L | Error | 2700 | 42WB3 | "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. |
| -1032L | Error | 2701 | 42WB4 | "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. |
| -1033L | Error | 2702 | 08W89 | "Unable to start database server: Server fatal error" | The database server failed to start because a fatal error or assertion failure occurred. More information may be available in the Windows event log or Unix system log or by manually starting the database server. Click here for a list of possible parameters and odbc states. |
| -1034L | Error | 2703 | WW064 | "The '%1' attribute is not valid with procedure type '%2'" | This attribute is not applicable to the given procedure type. Click here for a list of possible parameters and odbc states. |
| -1035L | Error | 2704 | WL008 | "LOAD TABLE not permitted on mirrored database" | LOAD TABLE statements are not permitted when a database is being mirrored, since the file being loaded might not be accessible by the other server. Click here for a list of possible parameters and odbc states. |
| -1036L | Error | 2705 | 08W90 | "The DBN/DBF parameters do not match the database for this alternate server name" | The DBN or DBF parameters specified do not match the database using the specified alternate server name. Click here for a list of possible parameters and odbc states. |
| -1037L | Error | 2706 | 55W16 | "Cannot drop or modify object '%1' because at least one other object ( %2 '%3') depends upon it" | You attempted to drop or modify an object, such as a table or a column, that is used by another object, such as a materialized view, that cannot be automatically invalidated. The dependent object must be disabled or dropped before a drop or modification can be permitted. Click here for a list of possible parameters and odbc states. |
| -1038L | Error | 2707 | 55W17 | "Cannot use view '%1' because it has been disabled" | You attempted to reference a view that has been disabled. The view must be enabled before it can be used again. Click here for a list of possible parameters and odbc states. |
| -1039L | Error | 2708 | 08W91 | "Cannot connect to mirror server. Use server name '%1' to find the primary server" | You have attempted to connect to the mirror server in a mirroring system. You should change your connection string or DSN to use the server name for the mirroring system. Click here for a list of possible parameters and odbc states. |
| -1040L | Error | 2709 | 55W18 | "Cannot use view '%1' because it is invalid" | You attempted to reference an invalid view. The view must be enabled before it can be used again. Click here for a list of possible parameters and odbc states. |
| -1041L | Error | 2710 | 42WB5 | "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. |
| -1042L | Error | 2711 | WW065 | "Cannot add a comment to a table declared as LOCAL TEMPORARY" | You attempted to add a comment to a table that has been declared as LOCAL TEMPORARY. This is not allowed. Click here for a list of possible parameters and odbc states. |
| -1043L | Error | 2712 | 57W01 | "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 an 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. |
| -1044L | Error | 2713 | 28W11 | "Invalid password: %1" | The attempt to create a new user ID or change a password failed. The function specified by the verify_password_function option disallowed the password. Click here for a list of possible parameters and odbc states. |
| -1045L | Error | 2714 | WB015 | "Invalid backup parameter value" | One or more of the parameters supplied to the backup operation has an invalid value. Click here for a list of possible parameters and odbc states. |
| -1046L | Error | 2715 | 55W19 | "Illegal column definition: %1" | You are attempting to define a column in a way that is not allowed. Click here for a list of possible parameters and odbc states. |
| -1047L | Error | 2716 | 55W20 | "This database does not support encrypted tables" | You tried to create an encrypted table in a database that does not support them. Click here for a list of possible parameters and odbc states. |