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 |
|---|---|---|---|---|---|
| 42WA4 | Error | 2612 | -948L | "PARTITION BY not allowed in reference to window '%1'" | When an existing window name is referenced from an inline window specification, the inline specification must not have a PARTITION BY clause. Click here for a list of possible parameters and odbc states. |
| 42WA5 | Error | 2613 | -949L | "ORDER BY not allowed in window '%1'" | When an existing window name is referenced from an inline window specification, either the inline window or the referenced window may have an ORDER BY, but not both. Click here for a list of possible parameters and odbc states. |
| 42WA6 | Error | 2614 | -950L | "Frame not allowed for window '%1'" | Frames are not allowed on rank functions or on windows referenced from inline window specifications. Click here for a list of possible parameters and odbc states. |
| 42WA7 | Error | 2626 | -962L | "Argument to GROUPING aggregate must be a grouping column in the GROUP BY clause" | Only a grouping column is permitted as an argument to the GROUPING aggregate function. An argument that contains anything other than a single grouping column expression will not be accepted. Click here for a list of possible parameters and odbc states. |
| 42WA8 | Error | 2628 | -964L | "Window function used in predicate" | A window function was used in the WHERE or HAVING clause of a SELECT statement. Consider making the SELECT into a derived table, putting the window function in the select list of the derived table, and changing the predicate to reference the derived column. Click here for a list of possible parameters and odbc states. |
| 42WA9 | Error | 2629 | -965L | "Window function requires ORDER BY" | Rank functions and window functions that use the RANGE keyword must specify an ORDER BY clause. Click here for a list of possible parameters and odbc states. |
| 42WAA | Error | 2630 | -966L | "Composite ORDER BY not allowed with RANGE" | Window functions that use the RANGE keyword may only ORDER BY a single column. Click here for a list of possible parameters and odbc states. |
| 42WAB | Error | 2632 | -968L | "User '%1' already has EXECUTE permission" | You attempted to give EXECUTE permission on a stored procedure to a user that already has EXECUTE permission on that procedure. Click here for a list of possible parameters and odbc states. |
| 42WAC | Error | 2661 | -994L | "Too many arguments for function or procedure '%1'" | You supplied an argument list that the database server cannot handle. This can happen if the argument list of the function or stored procedure is too long. Rebuilding the database with a larger page size could prevent this error. Click here for a list of possible parameters and odbc states. |
| 42WAD | Error | 2691 | -1022L | "Invalid value for attribute '%1' in service" | The service definition contains a USING, FORMAT, or GROUP attribute with an invalid value. Click here for a list of possible parameters and odbc states. |
| 42WAE | Error | 2692 | -1023L | "Missing value for attribute '%1' in service" | The service definition contains a USING, FORMAT, or GROUP attribute with a missing value. Click here for a list of possible parameters and odbc states. |
| 42WAF | Error | 2693 | -1024L | "Unsupported property '%1' in service USING attribute" | The service definition contains a USING attribute with an unsupported property. Click here for a list of possible parameters and odbc states. |
| 42WB0 | Error | 2694 | -1025L | "Duplicate attribute '%1' in service" | The service definition contains a duplicate attribute. Click here for a list of possible parameters and odbc states. |
| 42WB1 | Error | 2695 | -1026L | "USING attribute cannot coexist with FORMAT or GROUP attributes" | The service definition for the specified service type cannot specify a USING attribute along with a FORMAT or GROUP attribute. Click here for a list of possible parameters and odbc states. |
| 42WB2 | Error | 2696 | -1027L | "Service type does not allow '%1' attribute" | The service definition for the specified service type does not allow the given attribute to be specified Click here for a list of possible parameters and odbc states. |
| 42WB3 | Error | 2700 | -1031L | "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. |
| 42WB4 | Error | 2701 | -1032L | "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. |
| 42WB5 | Error | 2710 | -1041L | "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. |
| 42WB6 | Error | 2720 | -1051L | "Cannot create a materialized view because option '%1' has an inappropriate setting" | You attempted to create a materialized view, but one of the database options is currently set to a value not permitted while creating a materialized view. Click here for a list of possible parameters and odbc states. |
| 42WB7 | Error | 2721 | -1052L | "Cannot update materialized view because option '%1' has an inappropriate setting" | You attempted to update/refresh a materialized view but one of the database options is currently set to a value that is not permitted while updating a materialized view, or, the option's setting does not match the value when the view was created. Click here for a list of possible parameters and odbc states. |