Server Error Messages 4400 - 4499
942
4412 16 View `%.*s's definition contains `%.*s', which is a temporary object. Views can o nly 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, upo n
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 Admi nistrator.
4416 19 Could not allocate a work table while processing view s. The t otal num ber of work tables
generated by the query exceeds the limit (%d) of work tables. Simplif y t he 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. Erro r fo und 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 i n 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.
Number Severity Text and Explanation