Server Error Messages 9500 – 9599


 Warning - null value eliminated in set function
 Data exception - string data right truncated
 You must have one of the following role(s) to execute this command/procedure:  `%.*s'.  Please contact a user with the appropriate role(s) for help.
 An isolation level 0 cursor scan has failed on an attempted restart for cursor `%.*s', table `%.*s', index id `%d'.  The cursor is being closed.
 An isolation level 0 scan has failed on an attempted restart on table `%.*s', index id `%d'.
 Warning: Using only the first %d characters for password
 The builtin function `syb_sendmsg' is not supported.
 The builtin function `syb_sendmsg' failed to send the message `%.*s' to the destination address `%.*s' at port number %d, because the length of the Internet address is greater than the server limits. Please provide a valid destination address and retry.
 The builtin `syb_sendmsg' failed to send the message `%.*s' to the destination address `%.*s' at port number %d, because the port number is not valid. Please enter a valid (positive integer value between 0 and 65535) port number and retry.
 The builtin function `syb_sendmsg' failed to send the message `%.*s' to destination `%.*s' at port number %d because the Internet address is incorrectly formed or is non-existent. Please enter the Internet address in its correct form and retry.
 The builtin function `syb_sendmsg' failed to send the message `%.*s' to the destination address `%.*s' at port number %d due to an internal error which required the message to be sent atomically. Please report this error to your Systems Administrator.
 The builtin `syb_sendmsg' failed to send the message `%.*s' to destination `%.*s' at port number %d due to failure in opening or setting the socket to non-blocking mode. Please report this internal error to your Systems Administrator.
The builtin function 'syb_sendmsg' failed to send the message '%.*s' to the destination address '%.*s' due to a failure to bind the socket to a local port number %d provided by using dbcc tune. Please report this error to your Systems Administrator.
 The builtin function `syb_sendmsg' failed to send the message `%.*s' to the destination address `%.*s' at port number %d due to an internal error while doing the actual send. Please report this error to your Systems Administrator.
 The UPDATE/DELETE WHERE CURRENT OF to the cursor `%.*s' failed because the isolation level is at 0.
 %d is an invalid spid. You could use sp_who to identify the correct spid.
 Table `%.*s' does not exist in the database.
 Insert into work table (for deferred processing) failed while enforcing referential constraints. Check previous errors for possible causes. dbname = `%.*s', table name = `%.*s', constraint name = `%.*s'.%S_EED
 Failed to update the identity pre-burn factor for field `%.*s' in table `%.*s'. Please re-try the operation or contact your SA for details.
 Error occurred while creating the identity value for field `%.*s' in table `%.*s'. Please re-try the operation or contact your SA for details.
 The parameter that specifies the number of rows in a SET CURSOR ROWS statement must be an integer with a value greater than 0.
 The parameter that specifies the number of rows in a SET ROWCOUNT statement must be an integer with a value greater than 0.
 The builtin `syb_sendmsg' is not currently enabled. Please contact your Systems Administrator for more information.
 SELECT is not allowed in a dynamic EXECUTE IMMEDIATE statement. This SELECT may have been part of a stored procedure or a trigger.
 A positioned update/delete on a row in table `%.*s' failed. This is because cursor `%.*s' does not point to a valid row in an inner(outer) table of an outer(inner) join used in the query.
 The dynamic sql operation is not allowed with cursor `%.*s'.
 Attempt to acquire lock on wrong merge area during parallel merge. This is an internal error. Contact a system administrator and SET PARALLEL_DEGREE 1 for this query. 
 The optimizer could not find a unique index which it could use to scan table `%.*s' for cursor `%.*s'.
Deadlock during parallel merge. This is an internal error. Use SET PARALLEL_DEGREE 1 to run this query, and contact Sybase Technical Support to report the problem. 
Internal error: unable to locate an extra SDES for cursor '%.*s'. The cursor was probably compiled with the incorrect locking scheme for the target table. 
Internal error: unable to locate a temporary object during preprocessing.  
Interal error: could not determine the configuration value for parameter '%s'.  
Unable to obtain lock on system table.  
Insufficient number of worker processes to execute this parallel query. Increase the value of the configuration parameter 'number of worker processes'. 
Insufficient number of mailboxes to execute this parallel query. Increase the value of the configuration parameter 'number of mailboxes'. 
Insufficient amount of memory per worker process to execute this parallel query. Increase the value of the configuration parameter 'memory per worker process'. 
Insufficient number of messages to execute this parallel query. Increase the value of the configuration parameter 'number of messages'. 
Worker Process API internal error %d. Consider running this query serially by setting the session parameter 'parallel_degree' to 1. Please contact Sybase Technical SUpport  
Parameter passed to %s has an invalid type. It must be of type %s.  
Invalid time syntax in parameter for %s: '%.*s'.  
Invalid time value in parameter for %s: '%.*s'.  
AN ADJUSTED QUERY PLAN IS BEING USED FOR STATEMENT %d BECAUSE 
NOT ENOUGH WORKER PROCESSES ARE CURRENTLY AVAILABLE.  
ADJUSTED QUERY PLAN: 
Worker process (fid=%d, spid=%d) encountered error: %d, severity: %d, state: %d during parallel query initialization. If the problem persists, consider setting the value of session parameter 'parallel_degree' to 1 and rerunning the query.
The lightweight procedure ’%.*s’ cannot be executed because it does not exist. 
The specified password does not have any numeric characters. New passwords must have at least one numeric character. 
The identity gap ’%d’ specified is too large for the identity column’s precision of ’%d’. 
No Unicode character returned for the range 0xD800..0xDFFF (surrogates) because it is not permitted to create Unicode expression with only half of a surrogate pair.
 No Unicode character defined for this integer expression.
No Unicode scalar value returned for unmatched surrogate half.
 The position parameter passed in falls outside the source string.
The server failed to create or update a row in table ’%.*s’ because a varying-length column would start at offset %d. This starting location cannot be represented accurately in the table’s row format.
Character or binary data returned from Adaptive Server has been truncated. The client application does not support more than 255 bytes of data as a result column or output parameter.
Table(s) in the current query have access rules but the row level access configuration option is not enabled and ASE_ASM license is not available/enabled. Please enable row level access option and the ASE_ASM license to run the query with access rules.
The ordinal number of a column in the ORDER BY clause exceeds 255. The client application does not support column numbers over 255.
An insert or update to table ’%.*s’ places column ’%.*s’ at offset %d,ending at offset %d. The maximum permitted ending offset for this column is %d. This is a server internal error.

Number	Severity	Text and Explanation
9501	10	Warning - null value eliminated in set function Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
9502	16	Data exception - string data right truncated Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9503	14	You must have one of the following role(s) to execute this command/procedure: `%.s'. Please contact a user with the appropriate role(s) for help. 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.
9504	16	An isolation level 0 cursor scan has failed on an attempted restart for cursor `%.s', table `%.s', index id `%d'. The cursor is being closed. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9505	16	An isolation level 0 scan has failed on an attempted restart on table `%.s', index id `%d'. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9506	10	Warning: Using only the first %d characters for password Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.
9507	18	The builtin function `syb_sendmsg' is not supported. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
9508	16	The builtin function `syb_sendmsg' failed to send the message `%.s' to the destination address `%.s' at port number %d, because the length of the Internet address is greater than the server limits. Please provide a valid destination address and retry. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9509	16	The builtin `syb_sendmsg' failed to send the message `%.s' to the destination address `%.s' at port number %d, because the port number is not valid. Please enter a valid (positive integer value between 0 and 65535) port number and retry. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9510	16	The builtin function `syb_sendmsg' failed to send the message `%.s' to destination `%.s' at port number %d because the Internet address is incorrectly formed or is non-existent. Please enter the Internet address in its correct form and retry. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9511	18	The builtin function `syb_sendmsg' failed to send the message `%.s' to the destination address `%.s' at port number %d due to an internal error which required the message to be sent atomically. Please report this error to your Systems Administrator. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
9512	18	The builtin `syb_sendmsg' failed to send the message `%.s' to destination `%.s' at port number %d due to failure in opening or setting the socket to non-blocking mode. Please report this internal error to your Systems Administrator. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
9513	18	The builtin function 'syb_sendmsg' failed to send the message '%.s' to the destination address '%.s' due to a failure to bind the socket to a local port number %d provided by using dbcc tune. Please report this error to your Systems Administrator. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
9514	18	The builtin function `syb_sendmsg' failed to send the message `%.s' to the destination address `%.s' at port number %d due to an internal error while doing the actual send. Please report this error to your Systems Administrator. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
9515	16	The UPDATE/DELETE WHERE CURRENT OF to the cursor `%.s' failed because the isolation level is at 0. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9516	16	%d is an invalid spid. You could use sp_who to identify the correct spid. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9517	16	Table `%.s' does not exist in the database. Explanation:* Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9518	17	Insert into work table (for deferred processing) failed while enforcing referential constraints. Check previous errors for possible causes. dbname = `%.s', table name = `%.s', constraint name = `%.s'.%S_EED Explanation:* A worktable operation failed during processing. Check status of tempdb.
9519	18	Failed to update the identity pre-burn factor for field `%.s' in table `%.s'. Please re-try the operation or contact your SA for details. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
9520	18	Error occurred while creating the identity value for field `%.s' in table `%.s'. Please re-try the operation or contact your SA for details. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
9521	16	The parameter that specifies the number of rows in a SET CURSOR ROWS statement must be an integer with a value greater than 0. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9522	16	The parameter that specifies the number of rows in a SET ROWCOUNT statement must be an integer with a value greater than 0. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9523	18	The builtin `syb_sendmsg' is not currently enabled. Please contact your Systems Administrator for more information. Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
9524	16	SELECT is not allowed in a dynamic EXECUTE IMMEDIATE statement. This SELECT may have been part of a stored procedure or a trigger. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.
9525	16	A positioned update/delete on a row in table `%.s' failed. This is because cursor `%.s' does not point to a valid row in an inner(outer) table of an outer(inner) join used in the query. Explanation: Attempted to delete or update a non-existent row in a table. Check join statement in the named cursor targeting this table. Cursor fetch may have returned NULL values due to no matching rows.
9526	16	The dynamic sql operation is not allowed with cursor `%.s'. Explanation:* You cannot use a client cursor within a dynamically prepared statement.
9527	20	Attempt to acquire lock on wrong merge area during parallel merge. This is an internal error. Contact a system administrator and SET PARALLEL_DEGREE 1 for this query. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.
9528	16	The optimizer could not find a unique index which it could use to scan table `%.s' for cursor `%.s'. Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message. Not raised in 11.9.2.
9529	20	Deadlock during parallel merge. This is an internal error. Use SET PARALLEL_DEGREE 1 to run this query, and contact Sybase Technical Support to report the problem. Explanation:
9532	20	Internal error: unable to locate an extra SDES for cursor '%.s'. The cursor was probably compiled with the incorrect locking scheme for the target table. Explanation:*
9533	20	Internal error: unable to locate a temporary object during preprocessing. Explanation:
9534	20	Interal error: could not determine the configuration value for parameter '%s'. Explanation:
9536	18	Unable to obtain lock on system table. Explanation: Command failed due to internal Adaptive Server problem. Save the query and report the error to your System Administrator.
9537	17	Insufficient number of worker processes to execute this parallel query. Increase the value of the configuration parameter 'number of worker processes'. Explanation:
9538	17	Insufficient number of mailboxes to execute this parallel query. Increase the value of the configuration parameter 'number of mailboxes'. Explanation:
9539	17	Insufficient amount of memory per worker process to execute this parallel query. Increase the value of the configuration parameter 'memory per worker process'. Explanation:
9540	17	Insufficient number of messages to execute this parallel query. Increase the value of the configuration parameter 'number of messages'. Explanation:
9541	18	Worker Process API internal error %d. Consider running this query serially by setting the session parameter 'parallel_degree' to 1. Please contact Sybase Technical SUpport Explanation:
9543	16	Parameter passed to %s has an invalid type. It must be of type %s. Explanation:
9544	16	Invalid time syntax in parameter for %s: '%.s'. Explanation:*
9545	16	Invalid time value in parameter for %s: '%.s'. Explanation:*
9546	10	AN ADJUSTED QUERY PLAN IS BEING USED FOR STATEMENT %d BECAUSE Explanation: The remainder of this explanatory message appears in 9547.
9547	10	NOT ENOUGH WORKER PROCESSES ARE CURRENTLY AVAILABLE. Explanation: The first portion of this explanatory message appears in 9546.
9548	10	ADJUSTED QUERY PLAN: Explanation: This is a message header.
9549	17	Worker process (fid=%d, spid=%d) encountered error: %d, severity: %d, state: %d during parallel query initialization. If the problem persists, consider setting the value of session parameter 'parallel_degree' to 1 and rerunning the query. Explanation: The message indicates a problem initiating a parallel query. fid is the family id of the worker process. You can use set parallel_degree 1 to limit the session to serial operation.
9550	16	The lightweight procedure ’%.s’ cannot be executed because it does not exist. 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.
9551	16	The specified password does not have any numeric characters. New passwords must have at least one numeric character. 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.
9552	16	The identity gap ’%d’ specified is too large for the identity column’s precision of ’%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.
9553	16	No Unicode character returned for the range 0xD800..0xDFFF (surrogates) because it is not permitted to create Unicode expression with only half of a surrogate pair. 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.
9554	16	No Unicode character defined for this integer expression. 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.
9555	16	No Unicode scalar value returned for unmatched surrogate half. 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.
9556	16	The position parameter passed in falls outside the source string. 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.
9557	16	The server failed to create or update a row in table ’%.s’ because a varying-length column would start at offset %d. This starting location cannot be represented accurately in the table’s row format. 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.
9558	10	Character or binary data returned from Adaptive Server has been truncated. The client application does not support more than 255 bytes of data as a result column or output parameter. 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.
9559	14	Table(s) in the current query have access rules but the row level access configuration option is not enabled and ASE_ASM license is not available/enabled. Please enable row level access option and the ASE_ASM license to run the query with access rules. Explanation: Adaptive Server could not perform the requested action.
9560	10	The ordinal number of a column in the ORDER BY clause exceeds 255. The client application does not support column numbers over 255. 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.
9561	20	An insert or update to table ’%.s’ places column ’%.s’ at offset %d,ending at offset %d. The maximum permitted ending offset for this column is %d. This is a server internal error. Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.