ASE Error Message (550 – 599)

Number Severity Explanation
550 16 The attempted insert or update failed because the target view was either created WITH CHECK OPTION or spans another view created WITH CHECK OPTION. At least one resultant row from the command would not qualify under the CHECK OPTION constraint.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
551 20 An unknown EVAL was sent to the execution module.

Explanation: Refer to the writeup for Error 551.
552 16 A column insert or update conflicts with a rule bound to the column. The command is aborted. The conflict occurred in database `%.*s' / table `%.*s' / rule `%.*s' / column `%.*s'.%S_EED.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
553 16 The number of parameters/variables in the FETCH INTO clause does not match the number of columns in cursor `%.*s' result set.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
554 16 The UPDATE/DELETE WHERE CURRENT OF to the cursor `%.*s' failed because the row has changed since it was fetched.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
555 16 The UPDATE/DELETE WHERE CURRENT OF to the cursor `%.*s' failed because the key of the row used in identifying the row changed since it was fetched.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
556 16 The table referenced in the UPDATE/DELETE WHERE CURRENT OF is not part of the result set tables of cursor `%.*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.
557 16 The cursor `%.*s' can not be used as it could not be found. It is possible that either it was not declared or it is not available in the current context.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
558 16 Attempt to open cursor `%.*s' which is already open.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
559 16 Attempt to use a cursor `%.*s' which is not open. Use the system stored procedure sp_cursorinfo for more information.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
560 16 The UPDATE/DELETE WHERE CURRENT OF failed for the cursor `%.*s' because it is not positioned on a row.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
562 16 The CURINFO datastream was not sent before the cursor command so no current cursor context is available.

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.
563 16 There is already another cursor with the name `%.*s' at the nesting level `%d'.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
564 16 The cursor identifiers are not available.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
565 16 The open processing for cursor `%.*s' did not stop anywhere. The DECLARE CURSOR could have been an invalid statement or there is some internal problem.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
566 26 The procedure buffer is not linked to the procedure header for an execute cursor `%.*s'. This is probably an internal system problem.

Explanation: An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server.
567 14 You must have the following role(s) to execute this command/procedure: `%.*s' . Please contact a user with the appropriate role 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.
568 14 The caller does not have the required System Security Officer (SSO) role. Please contact a user with System Security Officer (SSO) role 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.
569 16 The specified object with object ID `%d' is not found.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
570 14 Only a person with System Security Officer (SSO) role can change another person's password.

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.
571 16 Invalid user specified password left unchanged.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
572 14 Invalid caller's password specified password left unchanged.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
573 16 New password specified is too short. Minimum length of acceptable passwords is 6 characters.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
574 16 New password supplied is the same as the previous password. Please supply a different new password.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
575 16 Error occurred in internal encryption routines.

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.
576 18 Access was denied into the master database. Password left unchanged.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
577 18 The caller of the set_password builtin was not found! Password left unchanged.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
578 18 Date acquisition function failed. Unable to retrieve the correct date in the set_password builtin function. Password left unchanged.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
579 18 Unable to start a transaction in the set_password builtin. Password left unchanged.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
580 18 Unable to update Syslogins in the set_password builtin. Password left unchanged.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
581 18 Unable to open Syslogins table in the set_password builtin. Password left unchanged.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.
582 16 Cursor `%.*s' was closed implicitly because the current cursor position was deleted due to an update or a delete. The cursor scan position could not be recovered. This happens for cursors which reference more than one table.

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.
583 16 The cursor `%.*s' had it's current scan position deleted either because of a DELETE/UPDATE WHERE CURRENT OF or a regular searched DELETE/UPDATE. You must do a new FETCH before doing an UPDATE or DELETE WHERE CURRENT OF.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
584 16 Explicit value specified for identity field in table `%.*s' when IDENTITY_INSERT is set to OFF.

Explanation: The command failed and no data was updated in the database because an integrity check or other semantic check on the data failed.
585 16 Explicit value must be specified for identity field in table `%.*s' when IDENTITY_INSERT is set to ON.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
586 16 Illegal identity value specified for identity field `%.*s' in table `%.*s'.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
587 16 Identity value overflow for field `%.*s' while inserting into table `%.*s'.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
588 20 Failure adding identity column to table `%.*s' via select into.

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.
589 16 Invalid role string received.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.
590 16 Dynamic SQL error – Prepared statement `%.*s' does not exist.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects / variable names and/or input data.
591 16 Dynamic SQL error – Prepared statement `%.*s' is already being used by a cursor.

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
592 16 The DELETE WHERE CURRENT OF to the cursor `%.*s' failed because the cursor is on a join.

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.
593 16 The UPDATE WHERE CURRENT OF to the cursor `%.*s' failed because column `%.*s' being updated was not specified in the FOR UPDATE OF list.

Explanation: Command failed. You tried to update a column not named in the cursor's FOR UPDATE list.
594 16 The UPDATE WHERE CURRENT OF to the cursor `%.*s' failed because column `%.*s' being updated was not specified in the SELECT list.

Explanation: Command failed. You tried to update a column not named in the cursor's SELECT list.
595 16 Trying to return NULL from stored procedure for bit variable `%.*s'

Explanation: Command failed due to invalid or illegal request. Check syntax / semantics and permissions. Take any corrective action indicated by message.
596 17 Your query overflowed the space allocated for aligning internal data structures. Please simplify your query by breaking it up into a series of shorter queries.

Explanation: Command failed due to resource limitation. Modify the command to fit available resources retry when the resource is available or contact your System Administrator to address the resource problem.
599 16 The procedure `%.*s' that cursor `%.*s' is declared on has been dropped and recreated since the first time the cursor was opened.

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

You May Also Like

Leave a Reply?