Server Error Messages 7700 - 7799

Number

Severity

Text and Explanation

7701

16

 Overflow when converting from char to type %s, value = `%.*s'.

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

7702

16

 Overflow when converting from numeric(%d,%d) to type %s'%.*s', value = `%.*s'.

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

7703

16

 Overflow when converting from decimal(%d,%d) to type %s'%.*s', value = `%.*s'.

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

7704

16

 Truncation error when converting to exact numeric(%d,%d) from type %s'%.*s', value = `%.*s'.

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

7705

10

 Invalid pattern string. The character following the escape character must be percent sign, underscore, left square bracket, right square bracket, or the escape character.

Explanation: Check command syntax and semantics.

7706

10

 Pattern string is too long. The given pattern string `%.*s' is converted using the escape character `%.*s'. The converted string is longer than %d bytes.

Explanation: Check command syntax and semantics.

7707

10

 Illegal escape character found. There are fewer bytes than necessary to form a valid character.

Explanation: Check command syntax and semantics.

7708

10

 Pattern string is too complex. There are too many blocks requiring special attention for right bracket (]), circumflex (^), or dash (-).

Explanation: Check command syntax and semantics.

7709

20

 Server-initiated remote procedure call state error.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

7710

20

 Attempt to retrieve a returned parameter length from a server-initiated stored procedure without specifying the parameter name.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

7711

20

 Parameter not found while trying to retrieve the returned parameter length from a server-initiated stored procedure.

Explanation: Adaptive Server encountered an internal error affecting the current process. Report the error to your System Administrator.

7712

16

 Stored procedure `%.*s' may be run only in chained transaction mode. The `SET CHAINED ON' command will cause the current session to use chained transaction mode.

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

7713

16

 Stored procedure `%.*s' may be run only in unchained transaction mode. The `SET CHAINED OFF' command will cause the current session to use unchained transaction mode.

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

7714

16

 In a CREATE SCHEMA statement, the authorization id must match the current user name. The supplied authorization id, `%.*s', does not match the current user name, `%.*s'.

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

7715

18

 Object `%d' specified as a rule for tabid `%d', colid `%d' does not have a variable node in the tree.

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

7716

16

 Cannot convert CHAR value to REAL. The CHAR value has incorrect syntax.

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

7717

20

 Attempted to drop temporary table with object id %ld, which is not in the temporary object lists for this task.

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.

7718

16

 The `%s' command is not allowed within a multi-statement transaction in the `%.*s' database.

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

7719

17

 There is no memory available to save the current sequencer state -- cannot continue processing this query.

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.

7720

16

 Update/Delete from a table which is the inner table of an outerjoin is not allowed.  Command aborted.

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

7725

16

 Cursor `%.*s' was declared with a FOR UPDATE clause. This cursor was found to be read only.

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

7726

16

 Execute cursor `%.*s' is declared on a procedure which has more than one SQL statment. For the declaration of this cursor to be legal the procedure should have a single SELECT statement clause.

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

7727

26

 An internal error occurred for the cursor variable `%.*s'. It could not be found on any variable list of the procedure.

Explanation: An internal locking/synchronization rule was broken. Report the error to your System Administrator. Shut down and restart Adaptive Server.

7728

14

 Permission denied.  You must have the following role(s) to execute %.*s :  `%.*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.

7729

16

 Invalid role string `%.*s' entered.

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

7730

14

 SET ROLE fails.  The caller is not granted with the specified `%.*s' 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.

7731

16

 SET ROLE fails.  The caller cannot assume the new user identity (uid) in the current database.  Please contact a user with System Security Officer (SSO) role for help.

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

7732

16

 The UPDATE/DELETE WHERE CURRENT OF failed for cursor `%.*s' because the cursor is read only.

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

7733

18

 Unable to locate the base procedure header (Pss->phdr) which had been switched earlier.

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

7734

18

 The search for table name when adding a resdom in s_addident() failed. The resdom for the column `%.*s' did not contain the table name. 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.

7735

16

 The specfied row count `%d' for the cursor `%.*s' is invalid. The rowcount should always be greater than zero.

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

7736

20

 Unable to find lock request for tabid %ld dbid %d.  This is an internal error.

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.

7739

18

 Internal error - SELECT INTO not found, perhaps tree corrupted.

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

7740

18

 The declaration for cursor `%.*s' has the column `%.*s' in it's FOR UPDATE list which is not part of the SELECT list for the cursor. Either select that column or remove it from the FOR UPDATE list.

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

7741

18

 Internal error - Both SHARED AND UPDLOCK have been set on table `%.s'.

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

7742

16

 You must change your password using the sp_password system stored procedure before you can continue.

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

7743

16

 An explicit value for the identity field in table `%.*s' can only be specified in an insert statement when a field list is used.

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

7744

16

 Illegal attempt to update identity field `%.*s'.

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

7745

16

 Attempting to add a new identity field to a table `%.*s', via select into, which would have a field `%.*s' that inherits the identity property.

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

7746

16

 Attempting to add more than 1 new identity field to a table `%.*s', via  select into.

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

7747

16

 Unable to SET IDENTITY_INSERT to ON for table `%.*s' because it is already on for tabid %ld dbid %d.

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

7748

16

 Pseudo-column `SYB_IDENTITY' used incorrectly. No table in the query has the identity property.

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

7749

16

 Pseudo-column `SYB_IDENTITY' used ambiguously. Multiple tables in the query have the identity property.

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

7750

16

 Argument type `%s' is invalid for argument %d of `%s' function.

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

7751

16

 Unable to SET IDENTITY_INSERT to ON/OFF for table `%.*s' because the object either does not exist or cannot be opened.

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

7752

16

 Unable to SET IDENTITY_INSERT to ON/OFF for table `%.*s' because you are neither the DBO nor the object owner.

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

7753

16

 Unable to SET IDENTITY_INSERT to ON/OFF for object `%.*s' because the object is not a user table.

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

7754

16

 Operand data type `%s' is invalid for `%s' operator.

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

7755

18

 Attempt to switch base procedure header (Pss->phdr) more than once.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.

7756

16

 Unable to SET IDENTITY_INSERT to ON/OFF for table `%.*s' because the table does not have the identity property.

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

7757

16

 The order-by position number `%ld' is out of range of the number of items in the select-list.

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

7758

16

 The declaration for cursor `%.*s' has the column `%.*s' in it's FOR UPDATE OF list which is not updatable after view resolution.

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

7759

16

 The declaration for cursor `%.*s' has the column `%.*s' in it's FOR UPDATE OF list which is not updatable because it has the identity property.

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

7760

16

 Conversion of security label datatype to char/varchar datatype failed.

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

7761

16

 The data type `%s' is invalid for the %s function. Allowed types are: CHAR/VARCHAR and SENSITIVITY/SENSITIVITY_BOUNDARY.

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

7762

16

 Trigger label configuration incompatible with user's profile.

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

7763

16

 Procedure label configuration incompatible with user's profile.

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

7764

23

 Sysobjects entry NOT found for procedure buffer entry.

Explanation: The database may be corrupt. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

7765

23

 Invalid owner curread for view, procedure, or trigger in sysobjects entry.

Explanation: The database may be corrupt. Report the error to your System Administrator. Adaptive Server must be restarted and dbcc diagnostics run.

7766

16

 A conversion from `%s' label to character string resulted in an overflow.

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

7767

16

 THe user's curread label does not dominate the converted label.

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

7768

16

 Invalid label syntax.

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

7769

18

 Internal conversion error detected while converting to/from `%s' label datatypes.

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

7770

10

 Warning: There are other roles currently active.

Explanation: This is an informational message. Unless otherwise specified, no action is required. Contact your System Administrator about any warning issued in the message.

7771

16

 Insert into the sensitivity column of table `%.*s' attempted. Explicit inserts into the sensitivity column are not allowed.

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

7772

18

 Internal error encountered while processing @@update_mode global variable.

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

7773

16

 Execute cursor `%.*s' is declared on a procedure which contains a non-SELECT or a SELECT with a COMPUTE clause. For the declaration of this cursor to be legal it should have a single SELECT statement without a COMPUTE clause.

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

7774

16

 The procedure `%.*s' contains a select statement with FOR UPDATE clause. This should be the only statement in the procedure.

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

7775

16

 The column `%.*s' in FOR UPDATE list is not part of the SELECT list. Either select that column or remove it from the FOR UPDATE list.

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

7776

16

 Transaction to update certification state of object  %S_OBJID, database %S_DBID failed.

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

7777

16

 Changing certification state of object %S_OBJID, database %S_DBID to SUSPECT because of change in state of dependent object %.*s (previous object id %ld), database %S_DBID.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

7778

16

 Suspect procedure %S_OBJID, database %S_DBID found. Cannot execute query.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

7779

16

 UNCERTIFIED object %S_OBJID, database %S_DBID accessed by CERTIFIED object %S_OBJID, database %S_DBID. Cannot execute query.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

7780

16

 Procedure %S_OBJID, database %S_DBID with labels found UNCERTIFIED. Cannot execute query.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

7781

16

 Suspect view %S_OBJID, database %S_DBID found. Cannot execute query.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

7782

16

 Remote procedure call from within CERTIFIED stored procedure %S_OBJID, database %S_DBID not allowed. Cannot execute query.

Explanation: There may be possible corruption in a database or a database object. Take any corrective action indicated by the message. Consult the Adaptive Server System Administration Guide and the Troubleshooting Guide.

7783

10

 Internal error -- server failed to do garbage collection on this procedure, id = %ld.  Please save the query tree and procedure text and inform the technical support.  This is not a critical error, so server continues processing.

Explanation: There was an error during procedure query tree compression. This is not a critical problem as Adaptive Server can continue processing the procedure.

7784

16

 Illegal escape character found. There are fewer bytes than necessary to form a valid character.

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

7785

16

 Attempting to create a table `%.*s', via select into, with column `%.*s' whose numeric precision, %d, exceeds the maximum allowed precision (%d).

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

7786

16

 Unable to turn role off since user is not a valid user in the current database.

Explanation: Adaptive Server could not perform the requested action. The command violates a permission or privilege restriction. Check the command and working database context.

7787

16

 Sensitivity column of view `%.*s' accessed. A view's sensitivity column is not user accessible.

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

7788

10

 WARNING: An explicit or implicit HOLDLOCK/NOHOLDLOCK was specified for table `%.*s'; however, since this is an isolation level 0 scan, the HOLDLOCK/NOHOLDLOCK is ignored.

Explanation: Refer to the writeup for this error.

7789

16

 Unable to allocate work table for processing group by or distinct clause during query optimization. Maximum limit (%d) of work tables is exceeded. Simplify the query and retry.

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

7790

18

 Internal error - Unable to remap cursors during recompilation.  This is a non-fatal internal error.

Explanation: During recompilation, Adaptive Server remaps declared cursors from the old procedure header to the new header. This message means that an error is found during remapping.

7791

16

Unable to remap lockid for table %.*s in database %S_DBID. Printing diagnostic information: tobjp: 0x%x, lkr: 0x%x, rgtabid: %d.

Explanation: For temp tables and at times for user tables, the server needs to obtain the object ID at run time when applying table locks. This error indicates that the server was unable to obtain the ID for some reason.

7792

16

 An isolation level %d scan is being attempted on cursor `%.*s', but the cursor was declared at isolation level %d. You must re-declare the cursor at isolation level %d.

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

7793

16

An isolation level '%d' scan is being attempted by an ad hoc query, but the query  was compiled in the batch at isolation level '%d'.

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

7794

16

You cannot scan table '%.*s' at isolation level 0 because another process is running a utility command that is incompatible with level 0 scans. Please retry later.

Explanation: Another process is running a DROP INDEX, ALTER TABLE, TRUNCATE TABLE, REORG REBUILD, or CREATE CLUSTERED INDEX command on the table.

7795

18

 Internal error - Unable to process subqueries during transformations. Maximum limit (%d) of subqueries is exceeded. Please save the DBCC TRACE(100) output and inform technical support.

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

7796

18

 Internal error - Unable to process subqueries during transformations due to a corrupt query tree. Please save the output from DBCC TRACE(100) and inform technical support.

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