CHAPTER 6 Adaptive Server Error Messages
779
432 16 Security Label datatypes may not be used in an ORDER BY clause.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
433 17 Unable to allocate work table to process referential constraint. Query exceeds the
maximum limit (%d) of work tables. Either simplify the query or reduce the number of
referential constraints on the tables involved in the query.
Explanation: Resource error while trying to allocate worktable to process deferred
update on a table with referential constraints. Take corrective action described in
message.
434 16 Work table cannot be allocated for processing the order by clause which req uires a sort.
Maximum limit (%d) of work tables is exceeded while processing this que ry. Simplify the
query and retry.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
435 16 Database `%.*s' is not available. The `%s' statement will not be executed because the
cross-database referential constraint on table `%.*s' cannot be enforced. Contact your
System Administrator about the availability of database `%.*s'.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
436 16 The `%s' statement will not be executed because the cross-database referent ial constraint
on table `%.*s' cannot be enforced. A table or constraint definition is missing in database
`%.*s'. Contact your System Administrator.
Explanation: Command failed due to invalid or illegal request. Check syntax,
semantics, and permissions. Take any corrective action indicated by message.
441 18 Deadlock occurred in SQL Process %d, While accessing referencing tables.
Explanation: Command failed due to internal Adaptive Server problem. Perform any
diagnostic action indicated by message. Report the error to your System Administrator.
442 16 Maximum number of user tables under all sides of a UNION statement can not exceed
%d. Please simplify the query and retry.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
444 16 The index %d for the table %ld was not found in d ata base %d. T he in dex may have bee n
dropped while this query was being compiled.
Explanation: Adaptive Server could not perform the requested action. Contact your
System Administrator.
445 16 Compute clause referenced too many variable length columns; note th at each aggregate
occupies 2 columns, except for the AVG which occupies 4 columns. The maximum
number of variable length columns is %d
Explanation: Adaptive Server could not perform the requested action. Modif y query to
conform to the specified limits.
Number Severity Text and Explanation