ASE Error Message (550 – 599)



Share this article :
NumberSeverityExplanation
55016 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.
55120 An unknown EVAL was sent to the execution module.

Explanation: Refer to the writeup for Error 551.
55216 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.
55316 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.
55416 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.
55516 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.
55616 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.
55716 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.
55816 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.
55916 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.
56016 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.
56216 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.
56316 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.
56416 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.
56516 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.
56626 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.
56714 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.
56814 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.
56916 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.
57014 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.
57116 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.
57214 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.
57316 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.
57416 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.
57516 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.
57618 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.
57718 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.
57818 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.
57918 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.
58018 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.
58118 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.
58216 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.
58316 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.
58416 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.
58516 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.
58616 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.
58716 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.
58820 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.
58916 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.
59016 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.
59116 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.
59216 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.
59316 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.
59416 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.
59516 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.
59617 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.
59916 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

Related posts

ASE Error Message (1 - 140)
ASE Error Message (200 - 249)
ASE Error Message (300 - 399)
ASE Error Message (400 - 499)
© 2017 ITsiti. All Rights Reserved
Powered by KEEM