ASE Error Message (200 – 249)

Number	Severity	Explanation
201	16	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.
202	11	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.)
203	16	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.
204	20	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.
205	16	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.
206	16	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.
207	16	Invalid column name `%.*s'. Explanation: Refer to the writeup for Error 207.
208	16	%.*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.
209	16	Ambiguous column name %.*s Explanation: Command failed. Check syntax and semantics. A column name may need the full table specification or alias.
210	16	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.
211	16	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.
212	16	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.
213	16	Insert error: column name or number of supplied values does not match table definition. Explanation: Refer to the writeup for Error 213.
214	16	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.
216	20	Attempt to automatically drop temporary table failed. Explanation: Refer to the writeup for Error 216.
217	16	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.
218	16	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.
219	16	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.
220	16	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.
221	16	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.
222	20	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.
223	11	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
224	11	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.
225	11	Cannot run query–referenced object (name %.*s) dropped during query optimization. Explanation: Refer to the writeup for Error 225.
226	16	%s command not allowed within multi-statement transaction. Explanation: Refer to the writeup for Error 226.
227	16	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.
228	14	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.)
229	14	%s permission denied on object %S_OBJID / database %S_DBID / owner %.*s Explanation: Refer to the writeup for Error 229.
230	14	%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.
231	11	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.
232	16	Arithmetic overflow error for type %s value = %f. Explanation: Refer to the writeup for Error 232.
233	16	The column %.*s in table %.*s does not allow null values.%S_EED Explanation: Refer to the writeup for Error 233.
234	16	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.
235	16	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.
236	16	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.
237	16	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.
238	16	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.
239	16	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.
240	16	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.
241	16	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.
242	16	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.
243	16	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.
244	16	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.
245	16	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.
246	16	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.
247	16	Arithmetic overflow during %S_MSG conversion of %s value `%s' to a %s field. Explanation: Refer to the writeup for Error 247.
248	16	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.
249	16	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.