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