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.