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.
|