CHAPTER 6 Adaptive Server Error Messages
943
Server Error Messages 4500 - 4599
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.
Number Severity Text and Explanation
Number Severity Text and Explanation
4501 16 View `%.*s' has more columns defined than column names given.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
4502 16 View `%.*s' has more column names specified than columns defined.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
4503 20 The create view tree has a resdom with no right hand side. View `%.*s', resdom `%.*s'.
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.