Page tree
Skip to end of metadata
Go to start of metadata
Query Processor Errors (500)s

501        20           There is no result-list for a SELECT statement.
502        18           Internal error encountered in merging rows; resubmit query batch.
504        11           Stored procedure '%.*s' not found.
508        20           No begin-row pointer found in plan.
509        11           User name '%.*s' not found.
510        20           Bad eop type 0x%x .
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.
512        16           Subquery returned more than 1 value.  This is illegal when the subquery follows =, !=, <, <= , >, >=, or when the subquery is used as an expression.
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'
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.
515        16           Attempt to insert NULL value into column '%.*s', table '%.*s'; column does not allow nulls. Update fails.%S_EED
516        18           Attempt to get system date/time failed.
517        16           Adding a value to a %s field caused overflow.
518        16           Cannot convert type '%s' to type '%s'.
519        16           Overflow resulted from MONEY multiplication.
520        16           Overflow resulted from MONEY division.
521        16           Overflow resulted from MONEY addition.
522        16           Overflow resulted from MONEY subtraction.
523        16           Overflow resulted from %s minus operation.
524        16           Overflow resulted from MONEY remainder (modulo) operation.
526        18           ASE 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'.
527        20           Cannot remove alarm.
528        20           System error detected during attempt to use upsleep system call.
529        16           Explicit conversion from datatype '%s' to '%s' is not allowed.
530        16           Attempt to insert NULL value into column %d in work table (table id %ld); column does not allow NULLS.  UPDATE fails.
532        16           The timestamp (changed to %.*s) shows that the row has been updated by another user.
533        20           Can't find a range table entry for range %d.
534        16           TEXT and IMAGE datatypes require DBLIB version 4.0 or greater.
535        16           Difference of two datetime fields caused overflow at runtime.
536        16           Invalid length parameter with value of %d passed to the substring function.
537        16           Overflow resulted from a SMALLMONEY remainder operation.
538        16           '%.*s' cannot be found.  This language might have been dropped.  Please contact a user with System Administrator (SA) role.
539        20           Unexpected internal access methods error %d, state %d. Please report to Technical Support the following information:
                             dbid=%d, objectid=%d, curcmd=%d, plasterror=%d, pstat=0x%x, p2stat=0x%x, xactid=(%d, %d).
540        16           Schema for database object '%.*s' has changed since compilation of this query. Please re-execute query.
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.
542        16           An invalid datetime value was encountered. Value exceeds year 9999.
543        18           Constraint id information not found upon constraint violation, dbname = '%S_DBID', table name = '%.*s'.  This is an internal error.
544        16           Unknown Constraint violation occurred, database =  '%.*s', table name = '%.*s', constraint name = '%.*s'.
545        18           Constraint violation occurred, entry for the constraint missing from system catalog, database =  '%.*s', table name = '%.*s', constraint name = '%.*s'.
546        16           Foreign key constraint violation occurred, dbname =  '%.*s', table name = '%.*s', constraint name = '%.*s'.%S_EED
547        16           Dependent foreign key constraint violation in a referential integrity constraint. dbname =  '%.*s', table name = '%.*s', constraint name = '%.*s'.%S_EED
548        16           Check constraint violation occurred, dbname =  '%.*s', table name = '%.*s', constraint name = '%.*s'.%S_EED
549        18           Constraint violation occurred, bad constraint type passed to the exception handler.
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.
551        20           An unknown EVAL was sent to the execution module.
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
553        16           The number of parameters/variables in the FETCH INTO clause does not match the number of columns in cursor '%.*s' result set.
554        16           The UPDATE/DELETE WHERE CURRENT OF to the cursor '%.*s' failed because the row has changed since it was fetched.
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.
556        16           The table referenced in the UPDATE/DELETE WHERE CURRENT OF is not part of the result set tables of cursor '%.*s'.
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.
558        16           Attempt to open cursor '%.*s' which is already open.
559        16           Attempt to use a cursor '%.*s' which is not open. Use the system stored procedure sp_cursorinfo for more information.
560        16           The UPDATE/DELETE WHERE CURRENT OF failed for the cursor '%.*s' because it is not positioned on a row.
562        16           The CURINFO datastream was not sent before the cursor command so no current cursor context is available.
563        16           There is already another cursor with the name '%.*s' at the nesting level '%ld'.
564        16           The cursor identifiers are not available.
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.
566        26           The procedure buffer is not linked to the procedure header for an execute cursor '%.*s'. This is probably an internal system problem.
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.
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.
569        16           The specified object with object ID '%d' is not found.
570        14           Only a person with System Security Officer (SSO) role can change another person's password.
571        16           Invalid user specified, password left unchanged.
572        14           Invalid caller's password specified, password left unchanged.
573        16           New password specified is too short. Minimum length of acceptable passwords is 6 characters.
574        16           New password supplied is the same as the previous password.  Please supply a different new password.
575        16           Error occured in internal encryptionroutines.
576        18           Access was denied into the master database.  Password left unchanged.
577        18           The caller of the set_password builtin was not found!  Password left unchanged.
578        18           Date acquisition function failed.  Unable to retrieve the correct date in the set_password builtin function.  Password left unchanged.
579        18           Unable to start a transaction in the set_password builtin. Password left unchanged.
580        18           Unable to update Syslogins in the set_password builtin.  Password left unchanged.
581        18           Unable to open Syslogins table in the set_password builtin.  Password left unchanged.
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.
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.
584        16           Explicit value specified for identity field in table '%.*s' when '%s' is OFF.
585        16           Explicit value must be specified for identity field in table '%.*s' when IDENTITY_INSERT or IDENTITY_UPDATE is ON.
586        16           Illegal identity value specified for identity field '%.*s' in table '%.*s'.
587        16           Identity value overflow for field '%.*s' in table '%.*s'.
588        20           Failure adding identity column to table '%.*s' via select into.
589        16           Invalid role string received.
590        16           Dynamic SQL error - Prepared statement '%.*s' does not exist.
591        16           Dynamic SQL error - Prepared statement '%.*s' is already being used by a cursor.
592        16           The DELETE WHERE CURRENT OF to the cursor '%.*s' failed because the cursor is on a join.
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.
594        16           The UPDATE WHERE CURRENT OF to the cursor '%.*s' failed because column '%.*s' being updated was not specified in the SELECT list.
595        16           Trying to return NULL from stored procedure for bit variable '%.*s'
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.
599        16           The procedure, '%.*s', that cursor '%.*s' is declared on has been dropped and recreated since the first time the cursor was opened.

  • No labels