Server Error Messages 4400 - 4499

Number

Severity

Text and Explanation

4401

16

 View `%.*s' no longer exists.

Explanation: A database maintenance operation failed. Take any corrective action indicated by the message. Check the Adaptive Server error log.

4402

16

 Infinite loop in view definition.  Cannot resolve the view definitions in the query to the underlying tables.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4403

16

 View `%.*s' is not updatable because it contains external aggregates , or group by clauses, or internal aggregates . Internal aggregates may be generated by certain subqueries .

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4404

16

 View `%.*s' is not updatable because either the view definition contains DISTINCT or the view is built upon a view created with DISTINCT option.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4405

16

 View `%.*s' is not updatable because the FROM clause names multiple tables.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4406

16

 View `%.*s' is not updatable because a field of the view is derived or constant.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4408

19

 The query and the views in it exceed the limit of %d tables.

Explanation: Command failed when a non-configurable limit was exceeded. Adaptive Server could not recover gracefully. Reconnect to Adaptive Server, and report the error to your System Administrator.

4409

20

 The columns in the query definition and the view definition do not match.

Explanation: Adaptive Server encountered an internal error affecting the current process. Reconnect to Adaptive Server. Report the error to your System Administrator so dbcc diagnostics can be run.

4411

16

 View `%.*s' does not allow this UPDATE because either it was created WITH CHECK OPTION or it spans another view created WITH CHECK OPTION, and one of the update columns appears in a multi-table expression in the WHERE clause of a CHECK OPTION view.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4412

16

 View `%.*s's definition contains `%.*s', which is a temporary object.  Views can only be based on permanent objects.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4413

16

 View resolution could not succeed because the previously mentioned objects, upon which the view directly or indirectly relies, do not currently exist.  These objects need to be recreated for the view to be usable.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4414

16

 View `%.*s' does not allow INSERT because it is derived from more than one object and it was either created WITH CHECK OPTION or it spans another view created WITH CHECK OPTION.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4415

18

 Internal system error:  corrupt sequence tree encountered while processing the DISTINCT view `%.*s'.  Notify a user with System Administrator (SA) role.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.

4416

19

 Could not allocate a work table while processing views. The total number of work tables generated by the query exceeds the limit (%d) of work tables. Simplify the query or the views referenced in the query.

Explanation: Command failed when a non-configurable limit was exceeded. Adaptive Server could not recover gracefully. Reconnect to Adaptive Server, and report the error to your System Administrator.

4417

16

 The view `%.*s' has one or more tables with any of the keywords HOLDLOCK/NOHOLDLOCK that conflicts with the query to be run AT ISOLATION 0.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4418

16

 Query has too many subqueries when all views are taken into account.  Error found on view `%.*s'.  The limit is %d subqueries.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4420

16

 View `%.*s' is not updatable, possibly due to an outer join being in the view, or due to a subquery being in the select list of the view.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4422

16

 View `%.*s' cannot be updated since no underlying tables are referenced.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4423

16

 View `%.*s' cannot be updated since view is the inner table of an outer join.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4424

16

 View `%.*s' contains a table being updated, and this table is referenced elsewhere in the query which is not allowed if create view WITH CHECK OPTION is used.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4425

16

 View `%.*s' cannot have WITH CHECK OPTION applied since it contains subqueries.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

4426

16

This query cannot be processed because it contains TEXT, IMAGE or off-row Java columns and references a view defined with a subquery, an outer join, or a distinct clause. 

Explanation: You cannot use view materialization for a query having TEXT/IMAGE columns. View materialization needs to create a work table to store the result, and what is copied to the work table is only the TEXT pointer. Forbiding queries that require view materilization and select text columns from that view avoids stackstaces.

4427

16

View ’%.*s’ cannot be updated since the view definition contains a UNION operator.

Explanation: You cannot update view definitions that contain UNION.