ASE Error Message (200 – 249)



Share this article :
NumberSeverityExplanation
20116 Procedure %.*s expects parameter %.*s which was not supplied.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
20211 Internal error — Unable to open table at query execution time.

Explanation: Command failed. There may be a Adaptive Server problem. Contact Sybase Technical Support. (This error is not raised in Release 11.1 and higher.)
20316 The name `%.*s' is not a valid identifier.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
20420 Normalization error; node %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.
20516 All queries in a SQL statement containing set operators must have an equal number of expressions in their target lists.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
20616 Operand type clash: %s is incompatible with %s

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
20716 Invalid column name `%.*s'.

Explanation: Refer to the writeup for Error 207.
20816 %.*s not found. Specify owner.objectname or use sp_help to check whether the object exists (sp_help may produce lots of output).

Explanation: Refer to the writeup for Error 208.
20916 Ambiguous column name %.*s

Explanation: Command failed. Check syntax and semantics. A column name may need the full table specification or alias.
21016 Syntax error converting DATETIME from BINARY/VARBINARY string.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
21116 Syntax error converting SMALLDATETIME from BINARY/VARBINARY string.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
21216 Expression result length exceeds maximum: max – %d found – %d

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
21316 Insert error: column name or number of supplied values does not match table definition.

Explanation: Refer to the writeup for Error 213.
21416 Cannot convert parameter %.*s to type %.*s expected by procedure.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
21620 Attempt to automatically drop temporary table failed.

Explanation: Refer to the writeup for Error 216.
21716 Maximum stored procedure nesting level exceeded (limit %d).

Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
21816 Given parameter %.*s is too large; maximum size for this parameter is %d bytes.

Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
21916 Print format failed to match with a result column.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
22016 Arithmetic overflow error for type %s value = %ld.

Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
22116 Column of type (%s) does not allow nulls. It may not be compared with null.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
22220 Unintelligible query plan step encountered.

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.
22311 Object %ld specified as a default for tabid %ld / colid %d is missing or not of type default.

Explanation: Command failed. Check your database for the object not found and re-enter the command with the correct name
22411 Object %d specified as a rule/check constraint for tabid %d / colid %d is missing or not of type default.

Explanation: Command failed. Check your database for the object not found and re-enter the command with the correct name.
22511 Cannot run query–referenced object (name %.*s) dropped during query optimization.

Explanation: Refer to the writeup for Error 225.
22616 %s command not allowed within multi-statement transaction.

Explanation: Refer to the writeup for Error 226.
22716 Arithmetic overflow error ocurred while converting the string `%.*s' to type %s.

Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
22814 Query is based on a view that no longer exists (id = %ld)–cannot run.

Explanation: Command failed. Check your Adaptive Server environment for the object not found and re-enter the command with the correct name. (This error is not raised in Adaptive Server 11.1 and higher.)
22914 %s permission denied on object %S_OBJID / database %S_DBID / owner %.*s

Explanation: Refer to the writeup for Error 229.
23014 %s permission denied on column %.*s of object %S_OBJID / database %S_DBID / owner %.*s

Explanation: You do not have the permission to execute this command. Have the object owner or a user with the needed role run this command.
23111 Getdefault: no such default. id=%ld dbid=%d

Explanation: Command failed. Check your database for the object not found and re-enter the command with the correct name.
23216 Arithmetic overflow error for type %s value = %f.

Explanation: Refer to the writeup for Error 232.
23316 The column %.*s in table %.*s does not allow null values.%S_EED

Explanation: Refer to the writeup for Error 233.
23416 There is insufficient result space to convert MONEY value to CHAR.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
23516 Precision error during %S_MSG conversion of %s value `%s' to a %s field.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
23616 The conversion from CHAR to MONEY resulted in a MONEY overflow error.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
23716 There is insufficient result space to convert MONEY value to %s.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
23816 There is insufficient result space to convert %s value (= %d) to MONEY.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
23916 Table `%.*s' does not exist. Please refer to sysobjects for correct name.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
24016 There is insufficient result space to convert DATETIME value to CHAR.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
24116 Scale error during %S_MSG conversion of %s value `%s' to a %s field.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
24216 The conversion of CHAR to DATETIME resulted in a DATETIME value out of range.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
24316 Type `%.*s' is not a defined system type.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
24416 The conversion of CHAR value `%.*s' overflowed an INT1 field use a larger integer field.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
24516 Domain error during %S_MSG conversion of %s value `%s' to a %s field.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
24616 The conversion of CHAR value `%.*s' overflowed an INT2 field use a larger integer field.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
24716 Arithmetic overflow during %S_MSG conversion of %s value `%s' to a %s field.

Explanation: Refer to the writeup for Error 247.
24816 The conversion of CHAR value `%.*s' overflowed an INT4 field. Maximum integer value exceeded.

Explanation: Adaptive Server could not perform the requested action. Modify your command to meet the Adaptive Server requirement for the objects or variables shown in the error message.
24916 Syntax error during %S_MSG conversion of %s value `%s' to a %s field.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.

 

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

Related posts

ASE Error Message (1 - 140)
ASE Error Message (141 - 170)
ASE Error Message (250 - 299)
ASE Error Message (400 - 499)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM