CHAPTER 6 Adaptive Server Error Messages
777
411 20 Compute clause #%d, aggregate expression #%d is not in the select list.
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.
412 16 Cannot update more than 1 sysindexes row at a time.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
413 17 Maximum procedure %s count exceeded. Limit is %d. Modify the procedure to use
fewer %ss.
Explanation: Command failed due to resource limitation. Modify the command to fit
available resources, retry when the resource is available, or contact your System
Administrator to address the resource problem.
414 16 The current query would generate a key size of %d for a work table. This exce eds the
maximum allowable limit of %d.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
415 16 The current query would require an i nde x on a w ork t abl e to be built with %d keys. T he
maximum allowable number of keys is %d.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
416 16 Create of work table failed because row size would be %d. This exceeds the maximum
allowable size of a row in a table, %d.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
418 20 Can't find the real column name corresponding to the column heading `%.*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.
420 16 TEXT and IMAGE datatypes may not be used in an ORDER BY clause.
Explanation: Check query syntax.
421 16 TEXT, IMAGE and off-row Java datatypes may not be selected as DISTINCT.
Explanation: Adaptive Server could not perform the requested action. Rewrite the
command to conform to the requirement specified in the error message.
422 19 Too many nested expressions or logical operators to compile. Try splitting query or
limiting ANDs and ORs.
Explanation: Command failed when a configurable limit was exceeded. Reconnect to
Adaptive Server and perform any corrective action indicated by the message. Report the
error to your System Administrator.
Number Severity Text and Explanation