Server Error Messages 500 - 599

Number

Severity

Text and Explanation

501

20

 There is no result-list for a SELECT statement.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator. (Not raised in Adaptive Server 11.0 and higher.)

502

18

 Internal error encountered in merging rows; resubmit query batch.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.

504

11

 Stored procedure `%.*s' not found.

Explanation: Command failed. Check your database for the object not found and re-enter the command with the correct name.

508

20

 No begin-row pointer found in plan.

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.

509

11

 User name `%.*s' not found.

Explanation: Command failed. Check your Adaptive Server environment for the object not found and re-enter the command with the correct name.

510

20

 Bad eop type 0x%x .

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.

511

16

 Attempt to update or insert row failed because resultant row of size %d bytes is larger than the maximum size (%d bytes) allowed for this table. 

Explanation: Refer to the writeup for Error 511.

512

16

 Subquery returned more than 1 value.  This is illegal when the subquery follows =, !=, <, <= , >, >=, or when the subquery is used as an expression.

Explanation: Refer to the writeup for Error 512.

513

16

 A column insert or update conflicts with a rule imposed by a previous CREATE RULE command. The command was aborted. The conflict occurred in database `%S_DBID', table `%S_OBJID', column `%.*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 Release 11.0 and higher.)

514

20

 Expression stack overflow.  Usually this is because built-in functions have been nested too deeply.  Try to rephrase the query using less deeply nested functions.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

515

16

 Attempt to insert NULL value into column `%.*s', table `%.*s'; column does not allow nulls. Update fails.%S_EED

Explanation: Refer to the writeup for Error 515.

516

18

 Attempt to get system date/time failed.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.

517

16

 Adding a value to a %s field caused overflow.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

518

16

 Cannot convert type `%s' to type `%s'.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

519

16

 Overflow resulted from MONEY multiplication.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

520

16

 Overflow resulted from MONEY division.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

521

16

 Overflow resulted from MONEY addition.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

522

16

 Overflow resulted from MONEY subtraction.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

523

16

 Overflow resulted from %s minus operation.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

524

16

 Overflow resulted from MONEY remainder (modulo) operation.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

526

18

SQL Server has run out of alarms. Re-run your command when there are fewer users running WAITFOR, or ask your System Administrator to raise the configuration parameter ’number of alarms’. 

Explanation: Retry later, or increase the configuration parameter `number of alarms'.

527

20

 Cannot remove alarm.

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.

528

20

 System error detected during attempt to use upsleep system call.

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.

529

16

 Explicit conversion from datatype `%s' to `%s' is not allowed.

Explanation: Command failed due to invalid request. Consult the Adaptive Server Reference Manual for information on datatype conversions.

530

16

 Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS.  UPDATE fails.

Explanation: Refer to the writeup for Error 530.

532

16

 The timestamp (changed to %.*s) shows that the row has been updated by another user.

Explanation: The command failed and no data was updated in the database because an integrity check or other semantic check on the data failed.

533

20

 Can't find a range table entry for range %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.

534

16

 TEXT and IMAGE datatypes require DBLIB version 4.0 or greater.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

535

16

 Difference of two datetime fields caused overflow at runtime.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. The result of the DATEDIFF function may be too large.

536

16

Invalid length parameter with value of %d passed to the substring function. 

Explanation: Check command syntax. There may be more constraints to report than sp_helpconstraint can fit.

537

16

 Overflow resulted from a SMALLMONEY remainder operation.

Explanation: Adaptive Server could not perform the requested action. Check your command for missing or incorrect database objects, variable names, and/or input data.

538

16

 `%.*s' cannot be found.  This language might have been dropped.  Please contact a user with System Administrator (SA) role.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

539

20

Unexpected internal access methods error %d, state %d. Please report to Technical Support the following information: dbid=%d, objectid=%ld, curcmd=%d, plasterror=%ld, pstat=0x%lx, p2stat=0x%lx, xactid=(%ld, %d).

Explanation: Refer to the writeup for Error 539.

540

16

 Schema for table `%.*s' has changed since compilation of this query.  Please re-execute query.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

541

18

 An unknown arithmetic exception type was reported.  The transaction has been aborted.  This is an internal system error.  Please contact a user with System Administrator (SA) role.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.

542

16

 An invalid datetime value was encountered. Value exceeds year 9999.

Explanation: Adaptive Server could not perform the requested action. Rewrite the command to conform to the requirement specified in the error message.

543

18

 Constraint id information not found upon constraint violation, dbname = `%S_DBID', table name = `%.*s'.  This is an internal error.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.

544

16

 Unknown Constraint violation occurred, database =  `%.*s', table name = `%.*s', constraint name = `%.*s'.

Explanation: Command failed due to invalid or illegal request. Check syntax, semantics, and permissions. Take any corrective action indicated by message.

545

18

 Constraint violation occurred, entry for the constraint missing from system catalog, database =  `%.*s', table name = `%.*s', constraint name = `%.*s'.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.

546

16

 Foreign key constraint violation occurred, dbname =  `%.*s', table name = `%.*s', constraint name = `%.*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.

547

16

 Dependent foreign key constraint violation in a referential integrity constraint. dbname =  `%.*s', table name = `%.*s', constraint name = `%.*s'.%S_EED

Explanation: Refer to the writeup for Error 547.

548

16

 Check constraint violation occurred, dbname =  `%.*s', table name = `%.*s', constraint name = `%.*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.

549

18

 Constraint violation occurred, bad constraint type passed to the exception handler.

Explanation: Command failed due to internal Adaptive Server problem. Perform any diagnostic action indicated by message. Report the error to your System Administrator.

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 occured 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 occured in internal encryptionroutines.

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.