ASE Error Message (1 – 140)



Share this article :
NumberSeverityExplanation
2110 WARNING – Fatal Error %ld occurred at %S_DATE. Please note the error and time and contact a user with System Administrator (SA) authorization.

Explanation: This is an informational message. Unless otherwise specified no action is required. Contact your System Administrator about any warning issued in the message.
10115 Line %d: SQL syntax error.

Explanation: Command failed. Check syntax and semantics.
10215 Incorrect syntax near `%.*s'.

Explanation: Refer to the writeup for Error 102.
10315 The %S_MSG that starts with `%.*s' is too long. Maximum length is %d.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
10415 Order-by items must appear in the select-list if the statement contains set operators.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
10515 Unclosed quote before the character string `%.*s'.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
10616 Too many table names in the query. The maximum allowable is %d.

Explanation: Command failed due to invalid or illegal request. Check syntax and semantics and permissions. Take any corrective action indicated by message.
10715 The column prefix `%.*s' does not match with a table name or alias name used in the query. Either the table is not specified in the FROM clause or it has a correlation name which must be used instead.

Explanation: Refer to the writeup for Error 107.
10815 The order-by position number `%ld' is out of range of the number of items in the select-list.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
10915 There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
11015 There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
11115 %s must be the first command in a query batch.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
11215 Variables are not allowed in %s statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
11315 Missing end comment mark '*/'.

Explanation: Command failed. Check syntax and semantics.
11415 `%.*s' is not a recognized DUMP DATABASE/TRANSACTION truncation option.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
11515 The offset `%d' given in a CONTROLROW command does not correspond to the beginning of a statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
11615 The symbol `*' can only be used for a subquery select list when the subquery is introduced with EXISTS or NOT EXISTS.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
11715 The %S_MSG name `%.*s' contains more than the maximum number of prefixes. The maximum is %d.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
11815 `%s' option name length plus value string length must total less than %d characters.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
11915 Must pass parameter number %d and subsequent parameters as `@name = value'. Once the form `@name = value' has been used all subsequent parameters must be passed in the form `@name = value'.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
12015 The SELECT list for the INSERT statement contains fewer items than the INSERT list. The number of SELECT values must match the number of INSERT columns.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
12115 The SELECT list for the INSERT statement contains more items than the INSERT list. The number of SELECT values must match the number of INSERT columns.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
12215 The debug option `%d' is larger than the maximum allowed. The highest option available is %d.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
12315 Must attach a value to the binary prefix `0x'; zero-length binary value is not allowed.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
12415 CREATE PROCEDURE contains no statements.

Explanation: Command failed. The CREATE PROCEDURE command must contain at least one SQL statement.
12615 Cannot nest CREATE PROCEDURE statements.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
12715 This CREATE may only contain 1 statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
12815 The name `%.*s' is illegal in this context. Only constants / constant expressions or variables allowed here. Column names are illegal.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
12915 Fillfactor `%d' is not a valid percentage; fillfactor must be between 1 and 100.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
13015 The comparison operator `= ALL' is not currently supported.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
13115 The size (%d) given to the %S_MSG `%.*s' exceeds the maximum. The largest size allowed is %d.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
13215 The label `%.*s': has already been declared. Label names must be unique within a query batch or stored procedure.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
13315 A GOTO statment references the label `%.*s' but the label has not been declared.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
13415 The variable name `%.*s' has already been declared. Variable names must be unique within a query batch or stored procedure.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
13515 Cannot use a BREAK statement outside the scope of a WHILE statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
13615 Cannot use a CONTINUE statement outside the scope of a WHILE statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
13715 Must declare variable `%.*s'.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
13815 Illegal correlation clause in a subquery.

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.)
13915 Cannot assign a default value to a local variable.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
14015 Can only use IF UPDATE within a CREATE TRIGGER.

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 (141 - 170)
ASE Error Message (171 - 199)
ASE Error Message (200 - 249)
ASE Error Message (400 - 499)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM