ASE Error Message (250 – 299)



Share this article :
NumberSeverityExplanation
25116 Unable to allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
25216 Can't group by a bit field.

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.
25316Maximum number of group-by expressions exceeded. Limit is %d / found %d aggregate expressions.

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.
25416 Maximum number of columns in a work table (%d) 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.
25516 Size of row in the worktable for grouped aggregate / %d bytes exceeds the maximum row size (%d bytes). Cannot run this query.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
25616 The data type `%s' is invalid for the %s function. Allowed types are: CHAR/VARCHAR and BINARY/VARBINARY.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
25716 Implicit conversion from datatype `%s' to `%s' is not allowed. Use the CONVERT function to run this query.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
25820 Database `%.*s' missing during query recompile.

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.
25916Ad-hoc updates to system catalogs not enabled. A user with System Security Officer (SSO) role must reconfigure system to allow this.

Explanation: Refer to the writeup for Error 259.
26116 `%.*s' is not a recognized global variable.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
26216 %s permission denied / database %S_DBID / owner %.*s

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.
26316 Must specify table to SELECT * FROM.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
26416 Column name %.*s appears more than once in the result column list.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
26516 Insufficient result space for %S_MSG conversion of %s value `%s' to a %s field.

Explanation: See the writeup for Error 265. If this error was raised when using a system stored procedure on large databases or devices – it may be due to an Adaptive Server problem. Contact Sybase Technical Support to upgrade to a version in which the problem is resolved.
26616 Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRAN is missing. Previous count = %ld / Current count = %ld.

Explanation: Check command syntax for missing COMMIT or ROLLBACK TRANSACTION. Use @@trancount in stored procedures to check transaction count.
26716 Object `%.*s' cannot be found.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
26816 You can't run SELECT INTO in this database. Please check with the Database Owner.

Explanation: Refer to the writeup for Error 268.
26916 NULL value cannot be specified for conversion from datatype `%s' to `%s'.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
27016 Table `%.*s' can't be modified.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
27216 Can't update a TIMESTAMP column.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
27310 Warning: A non-null value cannot be inserted into a TIMESTAMP column by the user. The database timestamp value has been inserted into the TIMESTAMP field instead.

Explanation: This is an informational message. Unless otherwise specified – no action is required. Contact your System Administrator about any warning issued in the message.
27420 A SYSTEM exception was raised with an unrecognized minor number %d.

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.
27616 The parameter `%.*s' in the procedure `%.*s' was not declared as an OUTPUT parameter.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
27716There was a transaction active when exiting the stored procedure `%.*s'. The temporary table `%.*s' was dropped in this transaction either explicitly or implicitly. This transaction has been aborted to prevent database corruption.

Explanation: Refer to the writeup for Error 277.
27816TEXT / IMAGE and off-row Java datatypes may not be used in a GROUP BY clause.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
27916 TEXT and IMAGE datatypes and off-row Java datatypes are invalid in this subquery or aggregate expression.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
28016 Only TEXT and IMAGE datatypes are valid with the TEXTPTR function.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
28116 %d is not a valid style number when converting from DATETIME to a character string.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
28210 Procedure `%.*s' attempted to return a status of NULL which is not allowed. A status of 0 will be returned instead.

Explanation: This is an informational message. Unless otherwise specified – no action is required. Contact your System Administrator about any warning issued in the message.
28316 You can't use browse mode with DBLIB 2.0 — you must upgrade to DBLIB 4.0 in order to run this query.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
28416 Rules may not be bound to TEXT or IMAGE datatypes.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
28516 READTEXT and WRITETEXT commands may not be used with views.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
28616 The logical tables INSERTED and DELETED may not be updated.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
28716 %s command not allowed within a trigger.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
28816 The PATINDEX function operates on CHAR / VARCHAR and TEXT datatypes only.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
29016 Trace 3604 is illegal within a stored procedure.

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

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.
29216 There is insufficient result space to convert SMALLMONEY value to CHAR.

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.
29416 The conversion from CHAR to SMALLMONEY resulted in a SMALLMONEY overflow error.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
29616 The conversion of CHAR to SMALLDATETIME resulted in a SMALLDATETIME 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.
29716 There is insufficient result space to convert SMALLDATETIME value to CHAR.

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.
29816 The conversion from DATETIME to SMALLDATETIME resulted in a SMALLDATETIME overflow error.

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.

 

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

Related posts

ASE Error Message (141 - 170)
ASE Error Message (200 - 249)
ASE Error Message (400 - 499)
ASE Error Message (500 - 549)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM