ASE Error Message (141 – 170)



Share this article :
NumberSeverityExplanation
14115 A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
14315 A compute-by item was not found in the order-by list. All expressions in the compute-by list must also be present in the order-by list.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
14415 Cannot use an aggregate in an expression used for the by-list of a GROUP BY clause.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
14515 A subquery with no aggregate functions may only contain expressions in its GROUP BY clause that are in the select-list. .

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
14615 Cannot perform an aggregate function on a column from a table not declared in the same subquery. .

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
14715 An aggregate function may not appear in a WHERE clause unless it is in a subquery that is in a HAVING clause and the column being aggregated is in a table named in a FROM clause outside of the subquery.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
14815 Incorrect time syntax in time string `%.*s' used with WAITFOR.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
14915 Time value `%.*s' used with WAITFOR is not a legal value. Check date/time syntax.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
15015 Both terms of an outer join must contain columns.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
15115 `%.*s' is an invalid money value.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
15215 Subqueries that use DISTINCT with a GROUP BY clause are not currently supported.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action. (This error is not raised in Release 11.0 and higher.)
15316 Variables/Parameters are not allowed in the ORDER BY clause.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
15415 %S_MSG is not allowed in %S_MSG.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
15515 `%.*s' is not a recognized %s option.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
15615 Incorrect syntax near the keyword `%.*s'.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
15815 Too many ORDER BY expressions. The maximum is %d.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
15915 For DROP INDEX – must give both the table and the index name in the form tablename.indexname

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message
16015 Rule does not contain a variable.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
16115 Rule contains more than one variable.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
16215 The select list item identified by the order by number `%ld' is a `*' – rather than a column name. When ordering by column number – a column name must appear in the select list position that corresponds to the order by number.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
16315 The COMPUTE BY list does not match the ORDER BY list.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
16415 GROUP BY expressions must refer to column names.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
16516 Privilege %s may not be GRANTed or REVOKEd.

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.
16615 %s does not allow specifying the database name as a prefix to the object name.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
16715 May not create a trigger on a temporary object.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
16815 The %S_MSG `%.*s' is out of the range of machine representation (%d bytes).

Explanation: Command failed. Check syntax and semantics.
16915 Expression `%d' and `%d' in the ORDER BY list are same. Expressions in the ORDER BY list must be unique.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.

 

Credit: http://infocenter.sybase.com/help/index.jsp

Related posts

ASE Error Message (200 - 249)
ASE Error Message (500 - 549)
ASE Error Message (550 – 599)
ASE Error Message (600 – 649)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM