ASE Error Message (250 – 299)

Number	Severity	Explanation
251	16	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.
252	16	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.
253	16	Maximum 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.
254	16	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.
255	16	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.
256	16	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.
257	16	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.
258	20	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.
259	16	Ad-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.
261	16	`%.*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.
262	16	%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.
263	16	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.
264	16	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.
265	16	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.
266	16	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.
267	16	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.
268	16	You can't run SELECT INTO in this database. Please check with the Database Owner. Explanation: Refer to the writeup for Error 268.
269	16	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.
270	16	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.
272	16	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.
273	10	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.
274	20	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.
276	16	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.
277	16	There 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.
278	16	TEXT / 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.
279	16	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.
280	16	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.
281	16	%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.
282	10	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.
283	16	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.
284	16	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.
285	16	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.
286	16	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.
287	16	%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.
288	16	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.
290	16	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.
291	16	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.
292	16	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.
294	16	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.
296	16	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.
297	16	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.
298	16	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.