ASE Error Message (171 – 199)



Share this article :
NumberSeverityExplanation
17115 Can't use SELECT INTO in Browse Mode.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
17215 Can't use HOLDLOCK in Browse Mode

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
17315 The definition for column `%.*s' must include a datatype.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
17415 The function `%.*s' requires %d arguments.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
17515 Functions may only be nested to level %d.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
17615 Function `%.*s' is not yet implemented.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
17715 %s cannot create a temporary object (with `#' as the first character name.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
17815 A RETURN statement with a return status may only be used in a SQL stored procedure.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
17915 Can't use the OUTPUT option when passing a constant to a stored procedure.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
18015 There are too many parameters in this CREATE PROCEDURE statement. The maximum number is %d.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
18115 Can't use the OUTPUT option in a DECLARE statement.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
18215 Table and column names must be supplied for the READTEXT or WRITETEXT utility.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
18315 The scale (%d) for column `%.*s' must be within the range %d to %d.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
18415 Invalid money datatype specification for column `%.*s'. Only money(19/4) is allowed for non-external tables.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
18515 Data stream is invalid for WRITETEXT command in bulk form.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
18615 Data stream missing from WRITETEXT command.

Explanation: Command failed. Check the syntax of the WRITETEXT command.
18715 Odd number of bytes in IMAGE data.

Explanation: While inserting text/image data an upper limit on the send may have been reached. Check the data sent and consider using ct_command or other alternative.
18815 Can't specify a log-device in a CREATE DATABASE statement without also specifying at least one non-log-device.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
18915 Function `%.*s' requires %d to %d arguments.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
19015 Can not update the global variable `%.*s'.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
19115 Some part of your SQL statement is nested too deeply. Please re-write the query or break it up into smaller queries.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
19215 Can't create a view inside a stored procedure.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
19315 The object or column name starting with `%.*s' is too long. The maximum length is %d characters.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
19515 `%.*s' is not a recognized %S_MSG.

Explanation: Command failed due to invalid or illegal request. Adaptive Server cannot perform the requested action.
19615 SELECT INTO must be the first query in a SQL statement containing set operators.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
19715WITH CHECK OPTION is not allowed in the definition of a union view.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
19815 Browse mode is invalid for statements containing set operators.

Explanation: Command failed. Check syntax and semantics. Rewrite the command to satisfy the condition indicated in the message.
19915 An INSERT statement may not contain a SELECT statement that assigns values to a variable.

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 (200 - 249)
ASE Error Message (250 - 299)
ASE Error Message (500 - 549)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM